Skip to content
Sheets Help

Google Sheets Add-Ons

  • Add-Ons
  • Basics
  • Tutorials

Tutorials

Named Functions in Google Sheets

September 22, 2023September 16, 2022 Adam Steinfurth

Create your own named functions.

Categories Tutorials Tags custom, custom function, lambda, named function

Types of Date and Time Functions in Google Sheets

May 4, 2023September 10, 2022 Adam Steinfurth

The date and time functions in Google Sheets can be grouped into different categories based on their purpose.

Categories Tutorials Tags date, day, hour, isoweeknum, minute, week number, weekday, year

30/360, Actual/365, and Actual/360 Day Counts

July 15, 2023August 31, 2022 Adam Steinfurth

Learn the three day counting conventions that banks use to calculate interest.

Categories Tutorials Tags accounting, amortization, bank, day count, day counting, days360, interest

Create a Column of Random Numbers

June 12, 2024August 17, 2022 Adam Steinfurth

Learn several methods to generate a column of random numbers.

Categories Tutorials Tags arrayformula, COUNTA, int, rand, randarray, random

Summarize Unique Values In Google Sheets

November 1, 2024July 14, 2022 Adam Steinfurth

Learn how to list, count, and sum unique values from a table of data.

Categories Tutorials Tags COUNTIF, pivot table, query, SUMIF
Older posts
Newer posts
← Previous Page1 … Page16 Page17 Page18 … Page21 Next →

Keep your data sorted automatically

StaySorted moving a row automatically

Install StaySorted

Join over 30,000 users

  • Home
  • Subscriber Portal
  • Functions
  • About
  • Contact
© 2026 Sheets Help • Built with GeneratePress