Please ensure Javascript is enabled for purposes of website accessibility
Microsoft Excel 2019 And 365: Beginner To Advanced
0( 0 REVIEWS )
6h 37m

This course is designed for those interested to learn the basics of Excel 2019, right from introductory topics, and get comfortable with Functions, Formatting, Data Analysis, Advanced Functions such VLOOKUPS, INDEX, MATCH, IF, Nested IFs, Text Formulas and SUMIFS/COUNTIFS, Power Query, Dashboards, Macros and Automate with VBA.

Read more.
Course Skill Level
Time Estimate
6h 37m



We are a collective of highly experienced professionals from the UK and North America who have packed decades of practical skills into top courses!

Only want this course? Buy this course for $199 $29 and keep lifetime access. Click here

About This Course

Are you looking to learn Excel 2019 and quickly? We have developed a crash course on how to get the best out of Excel 2019 that can be completed in under 7 hours!

It is a perfect course for you if you are about to start a new role or project, or perhaps you are preparing for a fairly in-depth interview in the next few days and you want to spend a few evenings or the weekend to bolster your Excel skills!

The course is presented by the highly experienced Andrew Dove, an Accounting Professional from the UK and covers the most important Excel topics that professionals need to be accomplished in. As with all of our courses, we are experienced professionals first and so we can truly empathise with your needs and this shows in the topics we choose and the style in which we teach you.

Take a look at the lessons list and if that sounds like the kind of curriculum that really resonates with you then sign up and we look forward to seeing you on the inside where we can help you raise your skills!

Course Details
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)

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, EAs, PAs, Engineers, Office Managers and pretty much anyone who has to use Excel

Our Promise to You
By the end of this course, you will have learned Excel 2019/365 from introductory to advanced topics.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about Excel 2019/365.

Course Curriculum

Section 1 - Starting Excel
Introduction 00:00:00
Course File 1 00:00:00
Starting Excel 00:00:00
Understanding Excel Interface 00:00:00
Getting Familiar With The Excel Workbook And Worksheets 00:00:00
Explaining The Ribbon 00:00:00
Saving An Excel File 00:00:00
Section 2 - What You Can Enter
Combined What You Can Enter In A Cell 00:00:00
Relative And Absolute Cell Referencing 00:00:00
Entering Formula Order Of Operations 00:00:00
Date Serial Numbers 00:00:00
Section 3 - Sheets, Rows And Columns
Copy And Drag 00:00:00
Working With Rows And Columns 00:00:00
Working With Sheets 00:00:00
Section 4 - Functions, Ranges And Shortcuts
Functions 00:00:00
SUM Function 00:00:00
Copy And Drag Formula 00:00:00
More Basic Functions 00:00:00
Named Ranges 00:00:00
Names Constants And Formula 00:00:00
Shortcuts 00:00:00
More Shortcuts 00:00:00
Section 5 - Formatting And Conditional Formatting
Course File 2 00:00:00
Formatting Font 00:00:00
Formatting Alignment 00:00:00
Formatting Borders 00:00:00
Formatting Numbers 00:00:00
Conditional Formatting PreConfigured 00:00:00
Conditional Formatting With Formula 00:00:00
Conditional Formatting Dialogue Box Formula Trick 00:00:00
Section 6 - Printing
Icons Shapes And Formatting 00:00:00
Printing Page Layout 00:00:00
Printing Headers Footers 00:00:00
Section 7 - Managing Data
Data Sort 00:00:00
Filtering 00:00:00
Tables 00:00:00
Text To Columns 00:00:00
Flash Fill 00:00:00
Data Validation 00:00:00
Group And Outline 00:00:00
Freeze Panes 00:00:00
Section 8 - Managing Text And Working With Formulas And Functions
Relative And Absolute Referencing 00:00:00
VLookup 00:00:00
Index Match 00:00:00
IF 00:00:00
Nested If 00:00:00
Countif Countifs 00:00:00
SumIf SumIfs 00:00:00
Len 00:00:00
Right Left Mid 00:00:00
Search 00:00:00
Common Error Types 00:00:00
IfError 00:00:00
Section 9 - Charts
Chart Basics 00:00:00
Chart Series And Column Charts 00:00:00
Bar Charts 00:00:00
Pie Charts 00:00:00
Composite Charts 00:00:00
Section 10 - Pivot Tables, Power Query And Dashboards
Power Query Intro 00:00:00
Power Query Consolidation 00:00:00
Pivot Tables 00:00:00
Setting Up A Pivot Table 00:00:00
Pivot Table Field Settings 00:00:00
Pivot Table Calculated Fields 00:00:00
Pivot Table Groupings 00:00:00
Pivot Table Slicers And Timelines 00:00:00
Dashboards Part 1 00:00:00
Dashboards Part 2 00:00:00
Section 11 - Macros
What Is A Macro 00:00:00
Recording A Macro 00:00:00
Relative And Absolute Macros 00:00:00
Section 12 - Intro To VBE And VBA
Introduction To VBE 00:00:00
Object Model 00:00:00
Module Worksheets Classes 00:00:00
Variables And Constants 00:00:00
VBA Formatting 00:00:00
If Statement 00:00:00
Select Case 00:00:00
For Loop 00:00:00
DoWhile DoUntil Loop 00:00:00
ForEach Loop 00:00:00
Errors Part 1 00:00:00
Errors Part 2 00:00:00
Consolidate 00:00:00