Microsoft Excel – Advanced
Excel for the Real World: Supercharge your Microsoft Excel Skills to the next level
Structuring the organisation of information in a workbook is crucial to developing powerful models. Our Advanced course is designed to help attendees work with larger spreadsheet models. This course will explore how existing data can be mined using different analysis techniques. The course will examine several real world problems and discuss how these can be tackled using techniques available in Excel.
Choice of Flexible Delivery Options:
~ 1 Day of Training
~ 2 Mornings / 2 Afternoons / 2 Evenings
Organiser
Programme Benefits
There is a huge amount to gain by being confident at this level. There are many features to learn and this course will save you hours and hours of work as you start to make the most of Excel and what it has to offer.
Who should Attend
This class is for users familiar with primary Excel features but who need more powerful features like lookups, error-handling, macros and scenario analysis.
Learning Objectives
This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You’ll have a powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role.
Prerequisites
- Participants should be existing users of Microsoft Excel.
- If you have attended or understand the concepts covered at the intermediate level, this course may be your next step.
Course Outline
- Create multi-sheet spreadsheet models
- Protect workbooks and worksheets
- Use the tracking tool to debug spreadsheets
- Creating Sparklines and Mapping Data
- Learn lookup and conditional formulae
- Customise graphs
- Forecasting Data
