Cool Google Sheets Features You Didn't Know About

TIL - Two cool Google Sheets features, clicking on a cell in a pivot table to create a new table and using named functions.

I have been using Google Sheets for a long time now, and I recently learned two new features that I think are really cool.

1. Click on a cell in a pivot table to create a new table with all the data that is represented by that cell.

This is a great way to drill down into your data, and get more insights. For example, if you have a pivot table that shows sales by product category, you can click on a cell in the “Total Sales” column to see a new table that shows the sales for that product category by region.

2. Google Sheets supports named functions.

Named functions, like named variables, make it easy to build easy-to-read and understand spreadsheets. For example, you could create a named function called BMI that calculates the body mass index of a person. =BMI(weight, height) is much easier to understand and maintain compared to =703*A1/(A2*0.393701)^2. You could also use the BMI function in your other spreadsheets like any other function.

Not only TIL about this, but this is also a new Google Sheets feature. You can find more info in the docs for creating & using named functions.

Hope you will find these features useful as well! Feel free to reach out with your feedback.

Enjoyed this post? Never miss out on future posts by following me.