Advanced Microsoft Excel
Course
Online
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Online
-
Class hours
16h
-
Duration
Flexible
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit. We also know how difficult it is to find quality instruction that is:
Easy to follow
Gets you the results you want
Teaches you advanced methods that you can quickly put into practice
That’s why we developed our online Advanced Excel course. It’s split into five clear sections to get the results you want right away. Your teacher is Simon Hurst, an Excel expert and trainer for 20+ years; whose experienced instruction will transform your Excel skills in under a week with none of the usual frustration.
Facilities
Location
Start date
Start date
About this course
Use advanced graphs in minutes instead of wasting hours trying to figure them out
Increase interactivity by automating your spreadsheets with macros and VBA
Solve complex problems with superpower functions
Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.
And more!
Available in Versions: 2007,2010,2013, 2016, 2016/365 and 2019 PC
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 4 years
Subjects
- Excel
- Microsoft Excel
- Microsoft excel training
- MS Excel
- Reducing
- Reducing Risk
- Increasing Efficiency
- Techniques
- SuperPowers
- Tables
Course programme
Section 1: Introduction
- Unit 1.1 - What's New in Excel 2019?
- Unit 2.1 - Templates
- Unit 2.2 - Increasing Efficiency and Reducing Risk
- Unit 2.3 - Data Validation
- Unit 3.1 - Functions with Superpowers
- Unit 3.2 - Array Formulae
- Unit 3.3 - Tables
- Unit 3.4 - Advanced Range Names
- Unit 3.5 - WhatIf Analysis
- Unit 3.6 - Problem Solving
- Unit 4.1 - Form Controls
- Unit 4.2 - Visual Basic and Macros
- Unit 5.1 - Conditional Formatting
- Unit 5.2 - Charts that Inspire
- Unit 5.3 - Sparklines
- Unit 5.4 - Graphics Tricks and Techniques
- Unit 6.1 - Working with External Data
- Unit 6.2 - Advanced Uses of PivotTables
- Unit 6.3 - Power Pivot
- Unit 6.4 - Reporting with Power Pivot
- Unit 7.1 - Course Plenary
Advanced Microsoft Excel