Login
Excel Yourself/Custom Functions and Range Names 2025 (80 min)
Buy now

Custom Functions and Range Names

DIY functions

Learn how to make your own Excel Functions. This course requires the subscription version of Excel.

Functions created in this course are:
  • SheetName - returns the sheet name of a reference
  • IFBLANK - handles blank cells
  • SUMCOL - sum each column a two-dimensional spill range
  •  SUMROW - sum each row in a two-dimensional spill range
  • SUMDA - sum the row or a column in a two-dimensional spill range

  

  • $25

Custom Functions and Range Names 2025 (80 min)

Learn how to create your own custom functions to perform specialised calculations.
Buy now

Contents

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 - this contain all the custom functions

Custom Functions and Range Names 2025.xlsx
  • 233 KB
Custom Functions and Range Names 2025.pdf
  • 886 KB
Custom Functions and Range Names 2025 completed.xlsx
  • 237 KB

Course Video

Introdustion to Custom Functions 2025 recording
  • (1h 19m 52s)
  • 315 MB

Course Quiz

Test your new found knowledge with 10 multiple choice questions.
Custom Functions and Range Names Quiz