How to use XLOOKUP in Google Sheets

Posted on September 18, 2019November 13, 2021 by Paul

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...read more

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

Posted on September 18, 2019November 13, 2021 by Paul

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...read more

Google Sheets edit history

Posted on September 17, 2019November 13, 2021 by Paul

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...read more

Filter Pivot Table with Slicer in Google Sheets

Posted on September 16, 2019November 13, 2021 by Paul

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...read more

How to Use Pivot Tables in Google Sheets

Posted on September 13, 2019November 13, 2021 by Paul

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...read more