Microsoft Excel 2019 (365): Crash Course

Master Excel 2019 (365) in under 7 hours!

What you’ll learn

This is a crash course in Excel 2019 to take you from Beginner To Advanced level in under 7 hours
You will learn introductory topics such as the Excel interface, sheets, rows, columns and data types
Get comfortable with Functions (Basic, Copying Functions, Named Ranges)
Formatting (Format the Sheet, Format Numbers and Conditional Formatting)
Data Analysis with Sorting, Filtering and Validation
Advanced Functions such VLOOKUPS, INDEX, MATCH, IF, Nested IFs, Text Formulas and SUMIFS/COUNTIFS
Data Consolidating with Power Query
Advanced Data Analysis with Pivot Tables
Visualise your Data with key Excel Charts and Dashboards
Speed up your work by recording and tweaking Macros
Automate with VBA (Object Model, Logic Programming and Managing Errors)

No prerequisites
A copy of Excel 2019 or Excel 365 (However this course works perfectly with 2016, 2013,2010 & 2007)

Who this course is for:

This is perfect for any professional who needs to get up and running with Excel 2019 very quickly, whether you have just started a new project, a new job or have an interview coming up.
Analysts, Accountants, Finance Business Partners, Financial Controllers, Project Managers, Office Managers, EA’s, PA’s, Engineers, Office Managers and pretty much anyone who has to use Excel