Category: Google Sheets Tutorials

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

Learn about the Google Sheets date format: which date formats are available, how they work, which date functions you can use, and much more.

Do you need to set up a database for your small business? Check out how you can use Google Sheets as a database for an e-commerce store, website or app.

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

Review this blog post to learn how to link data between Google Sheets by utilizing different approaches, and pick the one that will suit you the best.

Learn what a Gantt chart is and how to create Gantt charts in Google Sheets using conditional formatting, stacked bar charts, and templates.

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.

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

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

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