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