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

New courses launched

SIA Group is pleased to announce the introduction of three new courses focussed on building team performance in diverse organisations.

TPD™ Boosts Team Performance

SIA Group‘s TPD™ tool is leading to improvements in team morale, motivation, and performance at the University of Middlesex.