Tips, tutorials, and add-ons
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 your Google Sheets data by quarter using three methods: functions, pivot tables, and query.
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
Learn the nuances of working with dates and times in Google Sheets.
Learn how dates and times work in Google Sheets. They are numbers, but they come with many nuances you need to understand.