Skip to main content Help with accessibility Skip to main navigation

Excel Intermediate/Advanced Range Naming - Online 19 Apr 21

Event Date:

19 April 2021 1:30 PM - 2:30 PM

Closing Date:


Range Naming in Excel

  • Defining Range Names
  • Using Range Names in formulae and functions
  • Mange Range Names

Naming ranges in Excel has many advantages, making your workbooks easier to read, making formulas faster to type and debug, and allowing to create ranges with variable-size to make your spreadsheets dynamic and easy to update.

Online training will be delivered via MS Teams. You will receive joining instructions before your selected session.

On successful completion of this course you will be able to:

  • Define and manage Range Names
  • Use Advanced Formatting features and apply conditional formatting
  • Adjust the view with split and freeze panes options
Course information




Sharon Tew