Functions and Formulas

There are thousands of functions in Google Sheets and Microsoft Excel, but below are videos on some of the most useful ones for music teachers to get you started.

Click here for a "cheat sheet" of the formulas below plus many more!

Combine First and Last Names with AMPERSAND (&) and PROPER.

Click here for the spreadsheet used in the video.

Split First and Last Names.

Click here for the spreadsheet used in the video.

Calculate Attendance Quickly with COUNTA, COUNTIF, and DIVIDE.

Click here for the spreadsheet used in the video.

Budget Quickly and Efficiently with SUM, SUMIF, and MULTIPLY (*).

Click here for the spreadsheet used in the video.

Quickly find all the Wednesdays in a date range with WEEKDAY.

Quickly find shared students in multiple ensembles with COUNTIF.

Click here for the spreadsheet used in the video.

Cross-Reference Data with XLOOKUP.

Click here for the spreadsheet used in the video.

Use AI to help you write your formulas.

Click here for the spreadsheet used in the video.