Advanced Functions of Google Sheets
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.
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.
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.
The Joy it Gives
This blog has been quiet for over a year. Of course, I have to write my first post after a long time while experiencing flaky internet. Such has been the last few months for us - a lot of changes sometimes wanted and some surprises. Two of our For Dummies books...
What is Ajax?
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,...