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