Google Sheets Formulas
How to Split a Cell Vertically in Google Sheets (2 Simple Ways)
Learn how to split a cell vertically in Google Sheets using built-in features and Google Apps Script. Step-by-step guides to make data tidy!
Read article
Blog
1285 articles
Google Sheets Formulas
How to Add Days to a Date in Google Sheets (4 Quick Methods)
Add days to a date in Google Sheets using formulas, the WORKDAY and EDATE functions, or Google Apps Script for automatic updates.
Read article
Google Sheets Formulas
How to Create Dynamic Cell References in Google Sheets
Learn to create dynamic cell references in Google Sheets using IMPORTRANGE, VLOOKUP, FILTER, and Apps Script for real-time data updates!
Read article
Google Sheets Formulas
How to Reference a Cell in Another Google Sheets Workbook
Learn to reference cells in another Google Sheets workbook with IMPORTRANGE or Apps Script for dynamic, cross-workbook data linking.
Read article
Google Sheets Basics
How to Convert Timestamp to Date in Google Sheets
Learn how to convert timestamps to dates in Google Sheets using INT, TO_DATE, TEXT, SPLIT functions, or by formatting cells directly.
Read article
Charts in Google Sheets
How to Build a Gantt Chart in Google Sheets (3 Quick Methods)
Learn how to build a Gantt chart in Google Sheets using conditional formatting, stacked bar charts, or Google Charts with Apps Script.
Read article
Charts in Google Sheets
How to Add Error Bars to Charts in Google Sheets
Learn how to add and customize error bars in Google Sheets using fixed values, percentages, or standard deviation for chart analysis.
Read article
Google Sheets Formulas
How to Calculate Age from Date Of Birth in Google Sheets
Learn how to calculate age from date of birth in Google Sheets using DATEDIF, YEARFRAC, and methods for years, months, and days.
Read article
Google Sheets Intermediate Tutorials
How to Import Data from Website to Google Sheets
Learn how to import website data into Google Sheets using IMPORTXML, IMPORTHTML, IMPORTDATA, or manual copy-paste methods.
Read article
Google Sheets Formulas
Pull Data from Another Tab Based on Criteria in Google Sheets
Learn how to pull data from another tab in Google Sheets using QUERY, FILTER, VLOOKUP, INDEX-MATCH, and ARRAYFORMULA based on criteria.
Read article
Google Sheets Intermediate Tutorials
How to Change Page Orientation in Google Sheets
Easily change page orientation in Google Sheets by opening print settings and selecting between portrait or landscape in just a few clicks.
Read article
Charts in Google Sheets
How to Create an Organizational Chart in Google Sheets
Learn how to create an organizational chart in Google Sheets using the chart tool, Google Drawings, or Google Slides from your data.
Read article