Search Results

Here's what we found

19 results for: google sheets
Google Sheets course cover

Google Sheets – The Comprehensive Masterclass

Master the Powerful Features of Google Sheets from data collection, automation to proper data analysis and visualization. This course will teach you everything you need to know about Google Sheets. Plus you’ll benefit from our EXCLUSIVE bonuses.

Google Sheets – How to Create a Unique List from Multiple Columns

Use the hidden Google Sheets FLATTEN function to get a unique list of values from multiple columns. You just have to combine it with UNIQUE and you’re done!

Top 10 Tips to Make the Most of Google Sheets

This is the list of my favorite tips and functions in Google Sheets. If you’re new to Google Sheets, this list will give you an overview of the potential of Sheets. If you’re advanced, you’ll probably find some new features and functions you didn’t know about.

Google Sheets QUERY Function Explained

The Query function in Google sheets is one of the most powerful Google Sheets functions. It’s easy to learn if you follow the rules laid out in this tutorial. You’ll be ready to solve any data analysis problem in Google Sheets.

How to Use Google Sheets IMPORTRANGE Function

Learn how to use IMPORTRANGE in Google Sheets. You can also use it together with QUERY to import and append data from multiple sheets. IMPORTRANGE is great when you’d like to import data from other spreadsheets.

How to Create MULTIPLE Dependent Dropdown Lists in Google Sheets

There is a trick you can use to create multiple dependent dropdown lists on the same sheet in Google Sheets. It’s simple trick that doesn’t involve Apps Script. Check it out here.

How to Setup Dependent Drop-Down Lists in Google Sheets

Learn how to create dependent drop-down lists in Google Sheets. Dependent drop-downs can be tricky in Google Sheets because you can’t add a formula to the drop-down version of the data validation. But there is another way.

How to Create QR Code for Free in Google Sheets

Easily create QR codes for free. You can copy and paste the QR code into any application including Microsoft Word, Excel and PowerPoint. I use a function in Google Sheets to set this up. You can grab your copy and replace the URLs with your own.

How to Use the Google Sheets FILTER Function

Learn how to properly use the FILTER Function in Google Sheets. You can use the Filter function to check for one condition or apply it to multiple columns. You can also sort the filtered results by wrapping FILTER inside the SORT function.

What are Cleanup Suggestions and Column Statistics in Google Sheets

Find out to quickly use column stats in Google Sheets to get information about a specific column. Cleanup suggestions is another new feature in Sheets – but can you rely on it?

Do You Need to Learn Google Sheets?

What can Google Sheets do and should I learn it? This was a question I asked myself some time ago. I noticed more companies were switching to Google Sheets specially because of the events of 2020. In this post I talk about what Google Sheets can do.

How to Create a Yearly Calendar with ONE Excel Formula (Use in Google Sheets too)

Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.

Free Guide!

The ONE Critical Excel Skill You Need

This free Excel guide will help you to:

  • Pinpoint the Excel skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill