Excel - Advanced

Course Summary

This one-day course is designed for the experienced Excel user who wishes to examine the more advanced features of this sophisticated spreadsheet package. A good familiarity with spreadsheet design and layout is assumed. The aim of the course is to develop skills in the higher-level data analysis, formula building, formatting and automation features within Excel. Macro building is covered but Visual Basic for Applications (VBA) is the subject of a separate course.

What you will learn

• Advanced worksheet formatting and Excel shortcuts
• Using named ranges in formulae
• Formula Auditing - tracking changes
• ‘What if' forecasting using one and two variable data tables and scenarios
• Formula building
• LOOKUP functions
• Automatic Outline
• Restricting input using protection and data validation
• Using the form tools
• Goal Seek and Solver analysis
• Using the Scenario Manager
• Importing data into Excel
• Navigation using hyperlinks, command buttons and sheet and range naming
• Excel macros

Workshop Timetable

9.15am Welcome and coffee

9.30am

• Session start
• Delegate introductions and explanation of day
• Using named ranges and tracking changes

11.00am Break

11.15am

• ‘What If' forecasting
• Using the form tools in Excel spinners, list boxes and other formula building

12.30pm Lunch

1.15pm

• Automatic Outline
• Importing data into Excel in various formats
• Restricting input. Goal Seek and Solver analysis
• Using the LOOKUP functions

3.00pm Break

3.15pm

• Developing navigation facilities in complex sheets using hyperlinks and graphic buttons
• Developing Excel Macros

4.30pm Close