Microsoft (MS) Excel – Advanced
This 1-day course is a Microsoft Excel Advanced course aimed at experienced Excel users who need to create and manipulate more complex models using the advanced features of Excel. Participants should be existing users of MS Excel. They should be able to create, edit and manipulate spreadsheets containing formulae and functions. They should be able to create a basic chart and pivot table. Ideally they will have completed the Excel Introduction and / or Excel Intermediate course(s).
Course Content
The content of the Course is outlined:
Module 1: - Using Excel Functionality
- Create complex formulae
- Use a wide range of Excel functions – Mathematical / Statistical / Financial / Text / Lookup / Date & Time
- Link worksheets and workbooks via formulae
- Import CSV / TXT files and Parse the Data
Module 3: - Managing Multiple Workbooks
- Protecting the Sheet & the Workbook
- Sharing Workbooks
- Apply Conditional Formatting
- Use advanced sorting and filtering features
Module 5: - Using Excel Macros
- Create and use a keystroke macro
- Create Charts and customise layouts
- Create Sparkline charts for quick visual analysis
Module 2: - Excel Data Features
- Use the Data Features – Sort, Filter, Advanced Filter, Subtotal, Grouping, Slicers
- Use Data Validation and Audit a workbook
- Analyse data using Scenarios / What Ifs / Goalseek / Forecast Feature
Module 4: - Using Pivot Tables
- Create advanced Pivot Tables to analyse data and Dashboards
- Formulas in a Pivot Table
- Add extra calculation fields to the Pivot Table
Upcoming Courses
Current Month
No Events