Skip to content
Sheets Help

Tips, tutorials, and training

  • Basics
  • Tutorials
  • Functions

Tutorials

Conditionally Count Unique Values in Google Sheets

December 31, 2022December 19, 2022 by Adam Steinfurth

Three techniques to count unique values based on specified criteria.

Categories Tutorials Tags array, count, countuniqueifs, function, query, unique Leave a comment

Named Functions in Google Sheets

December 3, 2022September 16, 2022 by Adam Steinfurth

Create your own named functions.

Categories Tutorials Tags custom, custom function, lambda, named function Leave a comment

Types of Date and Time Functions in Google Sheets

November 3, 2022September 10, 2022 by 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 Leave a comment

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

November 12, 2022August 31, 2022 by 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 Leave a comment

Create a Column of Random Numbers

November 14, 2022August 17, 2022 by Adam Steinfurth

Generate a column of random numbers.

Categories Tutorials Tags arrayformula, COUNTA, int, rand, randarray, random Leave a comment
Older posts
Page1 Page2 … Page5 Next →

Makers of:

Insert Special Characters Add-On Icon Insert Special Characters

TripTally Logo TripTally

Google Sheets Basics – Create, Design, and Share

See the course
  • Home
  • Basics
  • Functions
  • Tutorials
  • About
  • Contact
© 2023 Sheets Help • Built with GeneratePress