Advanced Microsoft Excel
Advanced Microsoft Excel
Advanced Microsoft Excel
Course Overview
Looking To Finally Be An Advanced Excel User?
Do you have an intermediate understanding of Excel but are keen to break through to real mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user?
Take your Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more.
Why Excel Matters:
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.
What you get with this Advanced Excel course:
• 120+ modules of training, covering the most business-relevant areas of Microsoft Excel.
• 90+ videos and over 50 downloadable exercises.
• Tailored learning. If you have some Excel knowledge, you can use the filter to show only what you most need to learn.
• You’ll be an advanced level user after taking this Microsoft Excel course.
In this course you will learn:
• 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
More about us:
• We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
• We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
• Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
• Our platform is award-winning and improving all the time.
If you are not 100% happy with your EwB Advanced Microsoft Excel course, you have 30 days to exchange or refund.
About the author:
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels.
Simon has been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis. He can bring these years of practical experience to our Advanced Excel course, ensuring that the course explains advanced concepts clearly and concisely, and with real, practical applications.
Syllabus:
Section 1: Introduction
▸
Unit 1.1 - What's New in Excel 2019?
Section 2: Efficiency and Risk
▸
Unit 2.1 - Templates
▸
Unit 2.2 - Increasing Efficiency and Reducing Risk
▸
Unit 2.3 - Data Validation
Section 3: Advanced Techniques
▸
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
Section 4: Excel Interactivity
▸
Unit 4.1 - Form Controls
▸
Unit 4.2 - Visual Basic and Macros
Section 5: Spreadsheet Impact
▸
Unit 5.1 - Conditional Formatting
▸
Unit 5.2 - Charts that Inspire
▸
Unit 5.3 - Sparklines
▸
Unit 5.4 - Graphics Tricks and Techniques
Section 6: Turning Data into Decisions
▸
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
Section 7: Course Plenary
▸
Unit 7.1 - Course Plenary