Excel Yourself/10 Essential Excel Functions

  • Free

10 Essential Excel Functions

  • Course
  • 5 Lessons

These 10 functions can help you solve many problems in Excel. Discover the SUM function's super powers. Some of these require the subscription version of Excel. Others have been around for decades. Functions covered: SUM, SUMIFS, XLOOKUP, IF, IFERROR, UNIQUE, FILTER, (BYROW and BYCOL), EDATE + INDEX Version: M365 - Subscription Recorded: May 2026 Level: Mixed - Beginner to Advanced Duration: 1 Hour Price: Free

Contents

10 Essential Excel Functions

Course materials - click links below to download

 The session materials
  • a pdf manual which you can print out and make notes in
  • Excel file to work through during the session
  • the completed file to review if you need to
10 Essential Excel Functions.pdf
10 Essential Excel Functions 2026.xlsx
10 Essential Excel Functions 2026 completed.xlsx

Course Video

10 Essential Functions 2026 Recording