Excel Project – Index/Contents sheet

 Price: $25 incl GST

Duration: 1.25 hours

Index or a Contents sheet are required for Excel files that have multiple tabs.

The techniques covered in this session can also be applied to Instruction sheets and other sheets to improve the general navigation around your Excel files.

Six techniques are covered

  • Manual hyperlinks
  • Using cell links to navigate
  • Applying the HYPERLINK function
  • Using range names (including an unbreakable hyperlink)
  • Macros
  • Using an old Excel macro plus new dynamic arrays

As always lots of shortcuts will be shared along the way.

Date: 27/08/2020
Time: 1:00 PM AEST
Event: Excel Project - Index Sheet (1.25 hrs)
Topic: Index Sheet
Public: Public
Registration: Click here to register.