How to filter by Color in Google Sheets

While working on your Google Sheet, you might come across data that is categorized by color. It could be the cell’s background color or the text color itself. It can be incredibly useful to filter using these colors. For instance, say you have a list of students highlighted in green if they’ve passed and in red if they’ve failed. 

You can create a filter to look at only the passed or failed students.

4 methods to filter by color in Google Sheets

  • Using Filter by color from the Filter icon in the toolbar
  • Using Filter by color from the Filter option in the menu bar
  • Using Google Apps Script
  • Using a third-party add-on

Read more

How to sort by Color in Google Sheets

When you’re working on Google Sheets, you might come across data that is distinguished by color. It can be useful to sort the data by color and make the sheet look neater. For instance, take the data of students highlighted in red and green below. Red means they’ve failed a test and green means they’ve passed it.

The same data when sorted by color looks much neater and cleaner. 

4 methods to sort by color in Google Sheets

  • Using Sort by color from the Filter icon in the toolbar
  • Using Sort by color from the Filter option in the menu bar
  • Using Google Apps Script
  • Using a third-party add-on

Read more

How to unmerge cells in Google Sheets

You may come across merged cells while working on your Google Sheets. The cells can be vertically or horizontally merged. It can look something like this.

When you have merged cells in Google Sheets, it’s difficult to sort or filter the data present in those cells. Fortunately, unmerging cells is as easy as merging them. 

3 methods to unmerge cells in Google Sheets

  • Using the Merge cell icon in the toolbar
  • Using the Format option in the menu bar
  • Using Keyboard shortcuts

Read more

How to write fractions in Powerpoint

When preparing a presentation for a mathematics class, you may want to use fractions. You may also need to use fractions when preparing a presentation for a company. PowerPoint offers many types of fractions that you can use.

3 ways that you can use to enter fractions in Powerpoint Slide.

  • Use the Keyboard
  • Use the Fraction Tool
  • Use the Inking Tool

We will show you all the above methods. We will also show the respective advantages of these methods.

Let us start.

Read more

How to Separate First and Last Names in Google Sheets

When you’re working on Google Sheets, you might sometimes have data with names. It is possible that you might want to separate the first and last names for mailers, greeting cards, etc. It is especially useful when you’re doing a mail merge. Splitting the names manually might work when you have little data. However, it can become tedious for large amounts of data. 

4 methods to separate first and last names in Google Sheets

  • Using the SPLIT formula
  • Using Split text to columns
  • Using the Split Names add-on
  • Using Text functions

Read more

How to underline text in Google Sheets

While working on Google Sheets you’d need to underline texts. There are several ways to underline a Google cell, multiple cells, and text. We will cover the many methods and how we can do it with shortcuts. 

2 ways to underline text in Google Sheets

Method 1: Underlining a text string within a cell 

1.1 Underlining the entire string 

1.2 Underlining multiple strings in different cells

1.3 Underlining part of the text string

Method 2: Underlining the cell itself 

2.1 Underlining one cell

2.2 Underlining multiple cells at once

Lets Start.

Read more

How To Round Numbers in Google Sheets

You often come across values that you need to round off in a data set. It could be rounding up a number to the nearest two decimal points. You might need to round down a number to the nearest whole number or integer. Google Sheets provides four functions for this. Let’s cover them today.  

4 ways to round numbers in Google Sheets

The four main functions to round numbers are ROUND, ROUNDUP, ROUNDDOWN and MROUND.

Rounding up on Google Sheets follows the general rules as explained below: 

  • If the number to the right of the digit to be rounded is less than five, then the digit remains the same. 
  • If the number to the right of the digit to be rounded is more than or equal to five, then the function increments the number by 1. 

Method 1: Using ROUND function 

1.1 Rounding off to the nearest whole number 

1.2 Rounding off number to set decimal points

1.3  Rounding off numbers beyond the decimal point 

Method 2: Using ROUNDUP function 

2.1 Rounding up numbers to the next whole number 

2.2 Rounding up numbers while keeping set decimal points intact 

2.3 Rounding up numbers beyond decimal places

Method 3: Using ROUNDDOWN function  

3.1 Rounding down numbers to the next whole number

3.2 Rounding down numbers while keeping set decimal points intact  

3.3 Rounding down numbers beyond decimal places

Method 4: Using MROUND function

Let’s go over the functions in detail.

Read more

How to Enable autocorrect in Google Docs

When you’re typing in your doc, it’s strenuous to check the spelling of each and every word. It can make your writing more difficult than it has to be. Google Docs allows you to use autocorrect to make your writing process much easier. It is especially useful if you misspell a particular word frequently.

3 methods to enable autocorrect in Google Docs

  • Using the Preferences option
  • Customizing by adding a particular word
  • By enabling Spelling and grammar check

Read more

How to group Pictures in MS Word

You may have several pictures in your Word document. When editing the document, the pictures move independently. If you would like them to move together, you must group them.

2 ways of grouping pictures in your Word document:

  • Using Picture Tools
  • Using Right-Click

We will explain both methods using simple step-by-step instructions.

Let us begin.

Read more