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.Instructor
We are a collective of highly experienced professionals from the UK and North America who have packed decades of practical skills into top courses!
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout 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 |