Understanding Data Types in Google Sheets
Learn about the different types of data you can use in a spreadsheet.
Tutorials
Use Named Ranges to Simplify your Formulas
Named ranges give an alternate name to a cell or range of cells. You can then use them in your formulas to make the formulas easier to read. As you can see in the image below, the range of Sheet1!F5:F1007 has been named LemonVariety. The named range makes the formula easier to read and more … Read more
Summarize Data by Quarter in Google Sheets
Summarize your Google Sheets data by quarter using three methods: functions, pivot tables, and query.
How to Use Dates and Times in Google Sheets Formulas
Dates are notoriously finicky to use in spreadsheets. You can’t type them into a formula and expect it to work. However, there are a few different ways to use them in formulas. Once you know how, using dates is much easier. Method 1 – Surround Dates and Times with Quotes For the first example, dates … Read more
Google Sheets Date Formulas: Calculate, Format & Fix Dates
Learn the nuances of working with dates and times in Google Sheets.