International experts in Excel

Your power-packed agenda.  

Make use of the Applications list:

• Add applications to the Applications list.

Modify and copy an application:

• Modify the Applications list.
• Change a workbook name in a multi-workbook application.
• Copy an application.

Document data flow with LinkTags:

• Create LinkTags to document data flow among sheets, workbooks and external files.
• Navigate LinkTags.

Create a diagram of data flow:

• Use the ESP add-in to create a table that describes data flow among sheets, workbooks and external files.
• Use the ESP add-in to create an Input-Process-Output diagram of the data flow.
• Modify the diagram created.

Trace links:

• Trace flow of data.

Create and use outlines:

• Create outline based upon named styles.
• Navigate levels without an outline.

Record changes:

• Enter notes about changes into comments and onto the Changes sheet.
• Filter and sort the changes history.

Prepare application for others to use:

• Apply Data Validation to user inputs.
• Allow only number, time or date entry as appropriate.
• Find which cells have validation.
• Locate failed validation cells.

Update the version number:

• Know the purpose of the version number.

Protect worksheets and workbook:

• Protect sheets from unwanted and accidental change.
• Protect or unprotect some or all sheets simultaneously.
• Prevent sheets from being deleted, moved or renamed.

Include Menu sheet shortcuts for those without ESP:

• Provide rapid and hyperlink trail navigation.

Learn more about named styles:

• Reset overridden styles.
• Remove duplicate styles.
• Delete styles created by accident.
• Know when to create a new style and when not.

Customise standard worksheets and workbooks:

• Customise the standard workbooks and worksheets.
• Add your own standard worksheets and workbooks.

Discover miscellaneous tips:

• Trace links.
• Enter various common formulae.
• Include reliable VLOOKUP and SUMIF functions.
• Synchronise sheets.

Who should attend:

• Regular users of Excel who are familiar with the basics of formula construction, formatting and printing, as well as with all the agenda items covered in the ESP essentials and ESP next step 1 courses.