Category: Google Sheets Tutorials

Google Apps Script tutorial for programming with Google Sheets. Learn how to create custom functions, custom menus, and connect to other data sources.

Google Sheets provides plenty of shortcuts to optimize your workflow with spreadsheets. Check out the hotkeys by category and see how they work in action.

Converting your Excel files to Google Sheets format? Explore various ways to do this, and choose the best one based on your needs!

How will you choose to sort data in Google Sheets: the built-in functionality, or Google Sheets functions, such as SORT and QUERY. Read more in this tutorial.

A tutorial on how you can pull tables and lists from web pages into Google Sheets using the IMPORTHTML function.

Learn how you can concatenate strings, columns, and different data formats in Google Sheets using the CONCATENATE function and its alternatives.

In this ultimate guide, learn how you can apply conditional formatting in Google Sheets and explore miscellaneous use cases supported by real-life examples.

Read the definitive tutorial on how to make a chart or how to create a graph in Google Sheets, and check out the real-life use cases.

Learn how you can build a custom currency exchange rate monitor in your spreadsheet, or import financial data using API without a single line of code.

SPLIT is a Google Sheets function to divide data into fragments. Check out how it works, as well as other options to split cells in spreadsheets.