Google Sheets CONCATENATE Function to Combine Data from Multiple Cells Together
Learn how you can concatenate strings, columns, and different data formats in Google Sheets using the CONCATENATE function and its alternatives.
Category: Google Sheets tutorials
Tutorials and guides related to the use of Google Sheets functions and features.
Google Sheets Date Format | The How to Guide For Beginners
Learn about the Google Sheets date format: which date formats are available, how they work, which date functions you can use, and much more.
How to Use Google Sheets As a Database For Your Business
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 with Google Sheets
Google Apps Script tutorial for programming with Google Sheets. Learn how to create custom functions, custom menus, and connect to other data sources.
How to Link Data Between Multiple Spreadsheets
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.
SPARKLINE Google Sheets Function: How You Can Create Miniature Charts in a Cell
With the Google Sheets SPARKLINE function, you can create miniature charts contained within a cell. Learn how it works!
What is a Gantt Chart? — and How to Create it in Google Sheets
Learn what a Gantt chart is and how to create Gantt charts in Google Sheets using conditional formatting, stacked bar charts, and templates.
How to Make a Chart or How to Create a Graph in Google Sheets
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.
How to Sort Data in Google Sheets | Advanced Tutorial
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.
Conditional Formatting in Google Sheets | The Ultimate Guide With Examples
In this ultimate guide, learn how you can apply conditional formatting in Google Sheets and explore miscellaneous use cases supported by real-life examples.