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)
Requirements
-
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
