Excel 2019 Expert Tutorial

Excel 2019 Expert Tutorial

Get Ad-Free Training by becoming a member today!

Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.

What it is: Microsoft’s spreadsheet application used to clean and organize data.

What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Advanced section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Expert training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.

For ad free training and certificates please join Learnit Anytime:

Enroll in our live, instructor-led Excel classes:

For Private Group Trainings please visit:

Start 0:00
Introduction 0:03
Creating & Applying Named Ranges 1:24
Navigating with Named Ranges 9:42
IF Functions (Part 1) 11:26
IF Functions (Part 2) 15:17
Introduction to Nesting Functions 18:07
The Round Function 22:16
Formula Auditing Tools 25:39
Introduction to VLOOKUP 29:40
VLOOKUP 33:58
IFERROR 36:13
Database Functions – SUMIF & AVERAGEIF 38:37
Database Functions – SUMIFS 42:42
Text Functions 46:13
Consolidate by Position 53:17
Consolidate by Category 57:34
Goal Seek 1:00:31
Introduction to Data Tables 1:03:22
Data Tables 1:06:25
Scenario Manager 1:07:45
Macros – Adding the Developer Tab 1:12:28
Macros – Recording & Running the Header Macro 1:14:42
Macros – Visual Basic Editor & Form Control 1:20:29
Macros – Adding Macros to the Ribbon 1:25:02
Macros – Exercise 1:27:38

#Excel

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[PatriziaValMadiona]

One of the few tutors that I truly enjoyed listening to and kept me interested all the way! Your random sense of humor is on point too!

[malts]

Thank you so much, really appreciate the time and effort for completing this useful tutorials for us. :)

[thinzartheinttheintthu]

I do appreciate your time and effort in creating this fruitful tutorial. You rock!

[thisissyedbasim]

Thank you sooo much for this wonderful course. Really enjoyed learning it!

[danblas]

Are you kidding!!!! This is FANTASTIC! The samples are PHENOMINAL & dude is crystal clear! Thanks so much!!

[hollydunne]

Really well put together. A lot better than any of the paid for courses I have seen. Clear explanation of how nested functions work and super useful explanation of some of the analytics functions like the WhatIf analysis tabs. Perfect jumping off point at the end for anyone hoping to progress to learn macros. I added notes in a text box to each sheet of the student workbook provided as I followed along with the video - this will be a great resource for quick reference to the tools covered.

[ernestosabatercalvet]

Thank you for the detailed and easy to understand module, It really kept me active all the time!!!

[THAONGUYEN-hxkj]

You guys are amazing. Thank you so much for the free lesson

[jasmine]

Great teacher and educational chennel. Please upload pivote table master and expert lever.👏🏽👏🏽👏🏽👍🏾👍🏾👍🏾

[yuniol]

D1: IF Functions (Part 2) 15:17
D2: Introduction to VLOOKUP 29:40
D3: Text Functions 46:13
D4: Goal Seek 1:00:31
D5: Macros – Adding the Developer Tab 1:12:28
D6: Macros – Exercise 1:27:38
D7: To go over

[Ruru-zpol]

This tutorial is well planned and easy to follow! I had been struggling to know when to use certain functions. With there remaining one day for me to certify in Excel Expert, I decided to follow this video and it really helped. Thank you!

[huongphan]

Thanks for intuitive tutorial excels. I haven't used excel for awhile so your tutorials really helped me a lot. So many excel tutorial out there but this one is the best.

[miks]

Thanks a lot for putting together such a comprehensive training

[kafamyanmar]

Thank you so much for caring and sharing of excel learning for your learner!

[MehmetAliMD]

I am looking forward to watching it mate! I am sure that it's going to be another effective tutorial as good as previous tutorials which I'd had watched regarding excel were so cool.

[maxnyc]

You can do Xlookup instead of either Vlookup or Hlookup as Xlookup can look up vertically or horizontally.

[rubyshoukat]

I was looking for Excel 2019 tutorial, lucky to find your site. You have done a awesome job explaining it in detail and giving chance to practice together. No dough you are excellent tutor and keep your audiences engage. They are many utube tutorials on excel but none matches with your.
Thank you

[hpourmamih]

Hi Faz, thank you very much for this beautiful corse . in one word you are awesome!!!

[tetocaloscojones]

PMT Data Table. Practices grid still needs to use the same order for Months and rates (apparently does not affect the switch between months and rates. I tried but i had to use the same order as Alternative in order to get the same result). Regards

[jonathanowen]

This was a very helpful Excel course. The instruction is clear and the practice assignments reinforce the concepts. I learned a lot!