Excel - Advanced

In-House & Bespoke Training Programmes offer the ideal forum to learn new skills by targeting training to the specific needs of a group of employees. We can design content to meet your development and training requirements. Also, and very importantly, the cost per person is often less than booking the same people on an open course session if you have 8+ delegates. This is a very cost-effective way to take advantage of, and benefit from, our powerful training opportunities.

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