Microsoft Excel – Intermediate
Excel for the Real World: Bring your Excel skills to a New Level
Our intermediate course is designed to introduce new features of Excel that will enable users to be understand more of Excel ‘s features.
Choice of Flexible Delivery Options:
1 Day of Training
2 Mornings / 2 Afternoons / 2 Evenings
Organiser
Programme Benefits
The objective of our Microsoft Excel Intermediate training course is to develop a good working knowledge of Excel to include features such as functions and formulae, sorting and filtering data, working with charts and pivot tables.
Who should Attend
The Microsoft Excel Intermediate course is aimed at users who have basic experience with Excel and want to build on their current knowledge to set up their own spreadsheets and manipulate existing ones.
Learning Objectives
Upon successful completion of this course, you will deepen your understanding of Excel and be ready to custom formulas, apply built-in Excel functions and manipulate data to extract the insights you need.
Prerequisites
- Participants should be existing users of Microsoft Excel who can create, edit, format and print a spreadsheet.
- If you have attended or understand the concepts covered at the foundation level, this course may be your next step.
Course Outline
- Create complex formulae incorporating relative and absolute cell addressing
- Use a wide range of Excel functions such as Sumif, Countif, IF, Or, And, Lookups, ISError and many more
- Build and apply Conditional Formatting
- Link Sheets and Files
- Manipulate Data – Sorting, Filtering, Validation
- Create Pivot Tables
- Create a wide range of Charts
