Excel 2019 Advanced Tutorial

Excel 2019 Advanced 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
Overview of List Design 1:02
Formatting Lists as Tables 4:47
Filtering Records from Lists or Tables 6:45
Removing Duplicates from Lists or Tables 10:19
Flash Fill 13:40
Single & Multi-Level Sorting 16:50
Inserting Automatic Subtotals in Lists 21:27
Inserting Data Charts Using Recommended Charts 27:36
Formatting & Editing Chart Elements 32:28
Creating & Applying Custom Chart Templates 36:58
Adding & Removing Data from Charts 40:38
Inserting Sparklines 43:23
Printing Charts 48:52
Inserting Pivot Tables 49:57
Filtering Pivot Tables 55:04
Using Report Layouts in Pivot Tables 59:58
Refreshing & Changing Source Data in Pivot Tables 1:03:05
Inserting Pivot Charts 1:07:21
Data Validation 1:09:18
Applying Built-In Conditional Formatting 1:14:12
Creating Custom Conditional Formats 1:17:26
Linking Data 1:20:23
Comments 1:24:41
Protection 1:26:56

#Excel

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

[carlav]

Thank you for this. There were so many features about Excel I had forgotten about since I have not used it in my latest jobs!

[akashkamal]

very useful tutorial ... lots of insights but the best part is that the instructor keeps you engaged

[oudomchan]

I have finished first video and now i'm at 1:10:22 of this video. Thank you Learnit Training.

[lalakid]

Hey Faz, thank you so much for making this course!! You guided through very clear !

[dribeiro]

Thanks a billion!!!❤️ Your teaching style is easy to understand plus the excercise worksheets made available are bonus.

[juniorbosso]

I so excited to start the courses!! Thank you so much!!

[irinavistar]

What a great tutorial !!! I have already watched the first two videos. Looking forward to the rest !!!! Thank you very much, Faz, for putting it all together.

[cb]

Thank you for the courses. You explain in an encouraging and motivating way. Looking forward to many new videos!!

[TheDisciplinedPoser]

This is probably the best excel tutorial I've come upon (that is free). Very thorough and easy to understand. Thank you.

[dlkhazz]

I’ve already finished the first two videos and learned a lot. Thanks for your hard work.

[babuumakantvuppala]

Excellent trainer. Super teaching skills.

[simpleexcelexamples]

Love the content of this video and your way of teaching! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students) 😊

[ragkan]

love the content, makes it look so easy 😁thank you for making these tutorials

[adambalaz]

Perfect, thank you so much :) so clear, understantable! Great job

[fluffysnugglebunny]

This was a great learning tool, "expose ourselves to..." made me chuckle continuously.

[livewire]

Thank you for this course, it is amazing and thanks for sharing your knowledge. :)

[rutvijshah]

This is the only channel have a to-the-point explanation with easy understanding. Thanks for delivering such fantastic content free of cost.

[nechiw]

This is the best tutorial ever, easy to understand with good examples! had to subscribe

[mss]

Very in depth and step by step. Great coaching. Thank you!

[sushobhon_ROY]

I was searching for the exact analytics skills using excel in internet and found this its amazing, Thanks a lot.