Login
Excel Yourself/Custom Functions and Range Names (1.5 hrs)
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 (1.5 hrs)

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 2022.pdf
Custom Functions and Range Names 2022.xlsx

Course Video

Custom Functions and Range Names Video Recording

Course Quiz

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