Copyright 2017 BEST Learning Centre Ltd. All rights reserved.

Company Number: 10262623

  • Wix Facebook page
  • Instagram Social Icon

Microsoft Advanced Excel

Demystify some of the most complex business relevant areas of Microsoft Excel.

With 160 videos and loads of practice exercises you will be able to use the most hard to grasp Excel functions in no time. 

Our CPD UK certified online course covers what you need to know in business rather than what-Excel-can-do.

This course covers:

  • Using advanced graphs and presentation techniques to maximise impact

  • How macros and VBA automate your spreadsheets and increase interactivity

  • How superpower functions can solve complex problems

  • Using PivotTables and PowerPivots to turn raw data into clear information that supports key decisions

Section 1:

Design and Risk

 

Unit 1.1 - Templates
Unit 1.2 - Efficiency and Risk
Unit 1.3 - Data Validation

Syllabus

Section 2: Advanced Techniques

Unit 2.1 - Functions and Super Powers
Unit 2.2 - Array Formulae
Unit 2.3 - Tables
Unit 2.4 - Advanced Range Names
Unit 2.5 - What If?
Unit 2.6 - Problem Solving

Section 3: Excel Interactivity

Unit 3.1 - Form Controls
Unit 3.2 - Visual Basic and Macros

Section 4: Spreadsheet Impact

Unit 4.1 - Practical Interactivity with VBA
Unit 4.2 - Conditional Formatting
Unit 4.3 - Charts that Inspire
Unit 4.4 - Sparklines
Unit 4.5 - Graphics Tricks and Techniques

Section 5: Turning Data into Decisions

 

Unit 5.1 - Working with External Data
Unit 5.2 - Advanced Uses of PivotTables
Unit 5.3 - PowerPivot
Unit 5.4 - Reporting with PowerPivot