Tag: Google Sheets

Google Sheets edit history

Posted on by DevPaulC
How many times it happened that you deleted or modified something in a Google Sheet or you shared a Google Sheet for collaboration and other people modified it. How do you go back? There is not Undo ? Well, now there is. Google Sheet Edit History For this example I wrote in a cell the following text: "This Cell". Then I typed over: "This Cell was modified". And then I typed over: "This Cell was modified 3 times" Click on the cell in a Google Sheet that you want to see previous values and right click for menu Click...read more

Filter Pivot Table with Slicer in Google Sheets

Posted on by DevPaulC
Pivot Tables are the most powerful tools that you can use in your Google Sheets. A slicer is the feature that can filter out Pivot Tables easily. Very useful when you need to keep all your data together but you want to present parts of it (slices) In a previous example you can see how to create a simple Pivot Table in Google Sheets. We used an Education case study where the teacher Amanda wanted to have a summary of their students grades ready for the Teacher-Parent conference. Amanda keeps track of the grades in a simple Google Sheet...read more

How to Use Pivot Tables in Google Sheets

Posted on by DevPaulC
Pivot Tables are one of the most powerful features that is mostly known in Excel. However, Google Sheets is becoming more and more popular. Google Sheets is very similar with Excel from many point of views and of course it has the very popular Pivot Table. If you want to learn more about Pivot Tables in Excel, find all the related posts in the Excel category. Case Study Amanda is a teacher and wants to keep track of the grades of her students in a Google Sheet. With every test, she writes a line with the test date, student...read more