Excel - Level 3
This course is for the serious Excel user and covers topics including nested functions and recording and running macros.
Learning Objectives
- Understand and Apply Advanced Formulas
- Link Files
- Use Auditing Tools
- Understand and use Pivot Tables
- Use Data Analysis Tools
- Create ‘What-if?' Scenarios
- Create and use Form Controls
- Understand the basics of Macros and Visual Basic For Application
Focus
- Advanced Functions
- Linking Worksheets and Workbooks
- Styles
- Auditing the Worksheet
- Pivot Tables
- Data Analysis
- Scenario Manager
- Form Controls
- Introduction to Visual Basic & Macros
Duration: 1 day
What's New
SIA Group achieves ILM Approved Centre status
SIA Group achieves Institute of Leadership & Management (ILM) Approved Centre status and has a variety of options for accredited and assessed learning programmes.
SIA Group joins together with the Institution of Mechanical Engineers
SIA Group joins together with the Institution of Mechanical Engineers - the fastest growing professional engineering institution in the UK.
