Script is disabled Advanced Functions of Google Sheets - Portal Integrators
Select Page

Advanced Functions of Google Sheets

by

Previously we talked about the features of Google Hangouts. Are you guys ready for our next topic? Alright, this week we will be talking about the advanced functions of Google Sheets that probably not all of us know.

Okay before we proceed, just a recap “Google Sheets” is a data tracking tool, it is an excellent tool if you are well versed how to use it.

The first advanced function that we will be talking about is what’s called “Conditional Formatting.” What it means is it allows you to select a cell and set a rule for it to do something that corresponds to the rule.

 

 

To do this, you just need to highlight the cell that you wanted to format conditionally, then on the menu bar click on format and click “Conditional Formatting.”

 

 

 

 

 

 

 

 

 

 

Then on the right pane click on add new rule. Apply to range shows the cells that have been highlighted and under “Format cells if…” you would see the conditions that are available. Just set the conditions based on your needs.

The second function that will help a lot of people is how to add formulas. You might find at times that you need to add a particular kind of formula like average, sum, etc.

 

 

 

 To insert a formula first you need to select the cell where you want the answer to the formula to show up, then you click insert on the menu, then hover on “Function”, and you would see a list of formulas.

 

 

 

 

 

 

 

After selecting the formula, it would show you instructions on how to implement the formula.

 

 

 

The third function is how to sort a list by alphabetical order. First, you need to make sure that you select all of the data, especially the rows. Then you click on data at the menu bar and select “sort range by column,” choose whether the column should be arranged from A-Z or vice versa. It will then change the order, and the rows would follow if you have highlighted it from before.

 

 

 

The last thing that I want to show you as an advance function of google sheets is how to freeze the panes. A lot of times, when you had a lot of data on the spreadsheet, you have to keep on scrolling, it is sometimes confusing especially when you got a label on the column, and you have to remember what is the name of that column is. All you have to do is click on “View” on the menu bar and hover on “Freeze,” you would get an option to freeze the rows or columns.

Send us your questions on G Suite

9 + 1 =

Related Blog Post
What is Ajax?

What is Ajax?

Ajax and javascript are great for creating dynamic web applications, but before we discuss the AJAX let us first talk about how the browser works. The browser gets information to display a page. How does it work? When a browser request a page from the website the...

Google Forms Part 2

Google Forms Part 2

On last week’s Gsuite blog, we gave an overview and a tutorial on how to use “Google Forms” to create a great looking and very useful and efficient forms that you can send out via email, links, etc. This week we will continue where we left off. Just a quick recap,...