Category: Google Sheets

How to Make a Word Search Puzzle in Excel (or Google Sheets)

Posted on by DevPaulC
In this tutorial you'll learn how to make a printable word search that you can use as activity for children. This is a very simple method that you can use for free and you can create a template that you can later modify to add as many words as you want. This method uses formulas available in Google Sheets or Excel so you can follow this method regardless of the software you are using. The Formulas There are two formulas used in this tutorial. Let's first look at what these formulas are doing. CHAR (number) Char(number) formula returns the...read more

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

How to use XLOOKUP in Google Sheets

Posted on by DevPaulC
XLOOKUP may be a new function to Excel but it is not new to spreadsheet software. Google Sheets already has the LOOKUP function that works exactly like Excel's XLOOKUP. What about Excel's XLOOKUP support for Google Sheets? As Excel Released the XLOOKUP for most of the users now (if you don't have XLOOKUP in your Excel see here why), many users are asking what happens if you try to open a file that has an XLOOKUP formula in Google Sheets. As of February of 2020, this is not supported yet. You get an error when you try to do...read more