International experts in Excel

Your power-packed agenda.  

Include Welcome and List sheets:

• Understand the purpose of the Welcome sheet.
• Insert a drop-down list to select from.
• Enter list and use good technique for maintainability.

Navigate with Menu sheet hyperlinks:

• Navigate forward and back with hyperlinks.
• Learn keyboard shortcuts for navigation.
• Discover the Menu sheet.
• Use the AbleOwl ESP sheet name and tab colour conventions.
• Modify the Menu sheet.
• Navigate with Menu sheet keyboard shortcuts.

Link with Source and Destination Areas:

• Understand what Source and Destination Areas are and how they avoid the problems of spaghetti spreadsheets.
• Locate dependents and precedents quickly and reliably.
• Hyperlink forward and back through formula links.

Create a multi-workbook application:

• Create a top-level workbook with hyperlinks to lower-level workbooks.
• Link data correctly from one workbook to another.

Automate placing data into reports:

• Create reports that extract data from a table.

Drill down to audit report values:

• Drill down from a report cell to see the values summed on the source table.

Include crosschecks:

• Set up various types of crosscheck formulae.
• Use the ESP add-in to enter crosscheck formulae and formatting.
• Understand the issues in creating effective crosschecks.
• Make errors stand out so they are not overlooked.
• Use ESP add-in to create a Crosschecks sheet for ease of checking all crosschecks.

Who should attend:

• Regular users of Excel who are familiar with the basics of formula construction, formatting and printing, as well as with all ESP essentials agenda items. See the agenda above.