Excel 2019 Advanced Tutorial
Excel 2019 Advanced Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/36ZPKzO
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:
www.learnitanytime.com
Enroll in our live, instructor-led Excel classes:
www.learnit.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
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.
Пікірлер: 504
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!
very useful tutorial ... lots of insights but the best part is that the instructor keeps you engaged
Thanks a billion!!!❤️ Your teaching style is easy to understand plus the excercise worksheets made available are bonus.
@LearnitTraining
2 жыл бұрын
Awesome! Thank you!
@hyabbelay3729
2 жыл бұрын
@@LearnitTraining aaaq14ff
@ahmednavivwala1707
9 ай бұрын
0:47
I have finished first video and now i'm at 1:10:22 of this video. Thank you Learnit Training.
This is probably the best excel tutorial I've come upon (that is free). Very thorough and easy to understand. Thank you.
@LearnitTraining
3 жыл бұрын
Glad it was helpful!
@jenniferlorence1950
2 жыл бұрын
@@LearnitTraining; How do I get access to the Exercise files??
@michellegong6614
2 жыл бұрын
Can't agree more
@hawaiianengineer
2 жыл бұрын
@@jenniferlorence1950 You canfind it in the description. It's a zip file.
@ahmednavivwala1707
9 ай бұрын
0:20
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.
@LearnitTraining
3 жыл бұрын
Awesome, thank you!
@ahmednavivwala1707
9 ай бұрын
0:11
I so excited to start the courses!! Thank you so much!!
Hey Faz, thank you so much for making this course!! You guided through very clear !
Thank you for the courses. You explain in an encouraging and motivating way. Looking forward to many new videos!!
@LearnitTraining
3 жыл бұрын
Glad you like them!
This was a great learning tool, "expose ourselves to..." made me chuckle continuously.
@LearnitTraining
3 жыл бұрын
Haha not the best choice of words there we must admit
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) 😊
@LearnitTraining
2 жыл бұрын
You are so welcome!
@ahmednavivwala1707
9 ай бұрын
0:25
I’ve already finished the first two videos and learned a lot. Thanks for your hard work.
@LearnitTraining
2 жыл бұрын
Glad you like them! Thank you for watching!
Excellent trainer. Super teaching skills.
Great vid. I believe the 'dots' around the charts are called 'handles'.
I was searching for the exact analytics skills using excel in internet and found this video..... its amazing , Thanks a lot.
@LearnitTraining
2 жыл бұрын
You are most welcome!
This is the only channel have a to-the-point explanation with easy understanding. Thanks for delivering such fantastic content free of cost.
@LearnitTraining
2 жыл бұрын
You're very welcome!
@ahmednavivwala1707
9 ай бұрын
0:49
Very in depth and step by step. Great coaching. Thank you!
@LearnitTraining
3 жыл бұрын
You're very welcome!
@ahmednavivwala1707
9 ай бұрын
0:37
A very good tutorial. Clear examples, good pace, covers all topics and is pleasant to listen to. Thank you for providing this free of charge.
@LearnitTraining
Жыл бұрын
You're very welcome!
@ahmednavivwala1707
9 ай бұрын
@@LearnitTraining 0:33
Perfect, thank you so much :) so clear, understantable! Great job
@LearnitTraining
3 жыл бұрын
You're very welcome!
Thank you for this course, it is amazing and thanks for sharing your knowledge. :)
@LearnitTraining
2 жыл бұрын
Glad you enjoy it!
Excellent presentation allowed me to understand and learn at a perfect pace.. Learnt a lot. Thank you.
@LearnitTraining
3 жыл бұрын
Glad it was helpful!
You provide great videos. Not rushed like some videos. You explain the procedure and have us try it. Thanks
@LearnitTraining
3 жыл бұрын
You are welcome Deloris!
I was desperately looking for data file. There are many material in the KZread but no body share the files. Finally i have found it at your channel. Starting now and five my feed back later. Thanks a lot
@LearnitTraining
2 жыл бұрын
You are very welcome Jimins!
The way you deliver the idea and concept of each feature is really great. I really thank you for all your clear and attractive plus free help. God be with you at all times.
@LearnitTraining
2 жыл бұрын
Thank you for the kind words Brhanfit!
This is the best tutorial ever, easy to understand with good examples! had to subscribe
@LearnitTraining
2 жыл бұрын
Awesome, thank you!
Absolutely brilliant. Thanks a ton for clearing a lot of concepts. cheers
@LearnitTraining
2 жыл бұрын
You're very welcome!
excellent video!! thank you so much for this series!
@LearnitTraining
3 жыл бұрын
You're very welcome!
Thanks for this free tutorial! Very informative and straightforward.
@LearnitTraining
2 жыл бұрын
You're very welcome!
THANK YOU VERY MUCH FOR SUCH AN AMAZING COURSE!! REALLY HELPED ME!
@LearnitTraining
3 жыл бұрын
You're very welcome!
Thanks for sharing this I love excel and your content
Excellent training material; great training methodology. Thanks a lot.
@LearnitTraining
3 жыл бұрын
You are welcome!
Best video ever your teaching style is so perfect, i have learned a lot from this video. Thank You
@LearnitTraining
2 жыл бұрын
You are very welcome Khushbu! Thank you for watching!
love the content, makes it look so easy 😁thank you for making these tutorials
@LearnitTraining
6 ай бұрын
Glad you like them!
Sean Bugler did a good job in Excel 2016 videos. It will be awesome if Sean be the teacher for these Courses again.
Thanks a lot, the course is really very detailed and helpful
@LearnitTraining
2 жыл бұрын
You are welcome! Thank you for watching and an extra big thank you for subscribing!
This is the second tutorial for me. It is really helpful. Thank you so much.
@LearnitTraining
2 жыл бұрын
Thank you for your continued support Mang Sian Lian!
Thank you so much for this tutorial - I learnt so much! Definitely will be recommending to a friend who would like to learn advanced excel!
@LearnitTraining
2 жыл бұрын
Thank you so much!
Your teaching style and voice are relaxing and soothing me.
@LearnitTraining
2 жыл бұрын
Thank you for kind words!
I think you can make a good meditation guru, your voice is soothing in that way XD
@LearnitTraining
3 жыл бұрын
Wow, thanks
Thoroughly enjoyed this and learnt a lot of new features.
@LearnitTraining
2 жыл бұрын
Thank you for watching Rohit!
Hello Faz Jarim, I have a workbook in excel, with 28 sheets. I want to run Active and Inactive command in row. Example, if i want to Inactive an employeeID, it was lead all sheets (28) bring Inactive as employeeID. Can possible in the excel. Plesse need information about it.
This is GOLDEN. Thank you man. Keep it going!
@LearnitTraining
2 жыл бұрын
Appreciate it!
Best Free Excel Tutorial I've ever seen.
@LearnitTraining
2 жыл бұрын
Thank you for the kind words ZinZin!
Just thank you. It helped me a lot!!
@LearnitTraining
3 жыл бұрын
Glad it helped!
Thank you learnit for providing this very informative excel video. I have completed each lesson. 🥰😊
@LearnitTraining
2 жыл бұрын
You are welcome 😊
How are we getting the first column with Emp Id to take up a smaller space than the Title, creating tables?
I am looking forward to the tutorial
Faz - great presentation - I am refreshing after a long time ..this is just what I needed. Love yr style of holding our hands along the way..with appreciation - hoping you have more presentation, let me know..Seanna
@LearnitTraining
8 ай бұрын
Awesome, thank you!
I am loving it. The language, style presentation is awesome
@LearnitTraining
2 жыл бұрын
Thank you! 😃
Man your explaining method are just next level.
@LearnitTraining
2 жыл бұрын
Thank you for your continued support Xavier!
this video is a big help for me, the explanation is so easy to understand! Thank you so much, you just gained one subscriber here!😁
@LearnitTraining
Жыл бұрын
Awesome, thank you!
I am Iraqi live in Anbar . it's my great pleasure to which such wonderful videos on your channel . My pleasures would be greater, if the speech of the videos were a bit slower and nearer to UK accent , so that I and other Asians could catch up the lessons perfectly. For US, American English is more difficult than the UK one. However east or west you are really the best.
D1: Single & Multi-Level Sorting 16:50 D2: Formatting & Editing Chart Elements 32:28 D3: Printing Charts 48:52 D4: Refreshing & Changing Source Data in Pivot Tables 1:03:05 D5: Applying Built-In Conditional Formatting 1:14:12 D6: Protection 1:26:56 D7: To go over
@ahmednavivwala1707
9 ай бұрын
1:26:58
Thank you! This is very useful!
@LearnitTraining
3 жыл бұрын
Thank you for watching Monica!
Thank you so much for this video. This has helped me understand more.
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
Hello in previous version of 2019 for filter drop-down am using shortcut is alt+down arrow but in 2019 shortcut is not working not working for filter drop down.
What a content!!! Really appreciate you man. Thanks a lot!!!
@LearnitTraining
2 жыл бұрын
You are very welcome!
Thank you very much. The course is very useful, explanation of each step is very clear.
@LearnitTraining
2 жыл бұрын
You are welcome!
The best tutorial. clean and clear.
@LearnitTraining
3 жыл бұрын
Glad you think so!
Hi FAZ great video, Sorry I do not see the pivot table file in the excercise file folder which one is it?
Excellent Tutorial. Beautifully explained. Thanks Faiz.
@LearnitTraining
3 жыл бұрын
You are most welcome! Thank you for watching!
Thanks man 👍
Cool stuff!! Thanks a lot! Big help
@LearnitTraining
3 жыл бұрын
Glad it helped!
Where do you go to download the files to go along?
This video was of immense help, thank you sooo much
@LearnitTraining
2 жыл бұрын
You're so welcome!
The best Excel Tutorial ever!
@LearnitTraining
2 жыл бұрын
Wow, thanks!
The best Excel Tutorial I ever watched
@LearnitTraining
2 жыл бұрын
Thank you for the kind words isaac!
best excel course ever. thanks a lot
@LearnitTraining
2 жыл бұрын
Thank you for the kind words Foday!
Very good tutorial, very helpful thumbs up , have recommended to all my colleagues thanks..
@LearnitTraining
2 жыл бұрын
Thank you for sharing sumera! It helps us tremendously!
fantastic course, so helpeful, thank you
@LearnitTraining
3 жыл бұрын
You're very welcome!
Great stuff! Just wondering would you like to cover a bit more about the "Error Bar" option for the char1? 32:28. Thanks so much!
I like your tutorials. Much love from Kenya
@LearnitTraining
2 жыл бұрын
Awesome! Thank you!
Excellent tutorial !!! Much appreciated 😀
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
Thanks a bunch! Wanna become a pro like you man.
@LearnitTraining
3 жыл бұрын
Keep watching and you will be a pro soon!
Your teaching style is superb. Thanks a zillion.
@LearnitTraining
2 жыл бұрын
You are very welcome Esther! Thank you for watching!
wow , this is great . Thanks so much . Is super useful .
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
Amazing tutorial. You are a great teacher!!
@LearnitTraining
2 жыл бұрын
Thank you so much!
Great video. Very helpful!
@LearnitTraining
3 жыл бұрын
Glad it was helpful!
Thank You Faz. really enjoyed it.
@LearnitTraining
3 жыл бұрын
Glad you enjoyed it!
Thank you for that great illustration
@LearnitTraining
Жыл бұрын
Thank you for watching!
useful video. thanks.
Thank you so much. This was very useful
@LearnitTraining
2 жыл бұрын
You're very welcome!
Hi, great videos. How u use the count function if u have a columne with a value of zero and dont want to count that cell in, all others cells can be positiv and negative number in?
@Cropupset
3 жыл бұрын
I hope is not too late. You can use this formula: =COUNTIF(DesiredRange, "0")
Hello Faz, the intermediate file you open a the begging of the course is not in your shared files, is there anyway you or your team can check this. Thank you/
@alextagbo7504
3 жыл бұрын
Goto the sheet tab below and click on the arrow at the LHS till the very end, you will find this sheet name (Creating Tables).. Hope it was helpful!
@insurgent0
3 жыл бұрын
@@alextagbo7504 thank you
thank you so for this course but i want more for advanced formal how to create reports data,mis report,vlookup,hlookup,i need a to z course and short keys how to analysis data for job purpose.
Excellent tutorial. I really learned a lot.
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
Thank you thank you thank you!! Now I feel confident at my new admin job.
@LearnitTraining
Жыл бұрын
You are welcome! We hope you keep learning!
Excellent tutorial, thank you. The "go ahead" gets a little distracting though.
@LearnitTraining
3 жыл бұрын
Noted!
You can also insert a comment by selecting the cell and right click on it and then scroll down to 'Insert Comment'
U earned a Subscriber!!! Great work..
@LearnitTraining
2 жыл бұрын
Welcome aboard!
thank you so much!!! very helpful.
@LearnitTraining
2 жыл бұрын
You're welcome!
Tank you for your great tutorial.
@LearnitTraining
Жыл бұрын
Welcome 😊
This is such a great help! Thank you very much :)
@LearnitTraining
3 жыл бұрын
Glad it helped!
this was so helpful thanks you so much
@LearnitTraining
3 жыл бұрын
You're so welcome!
how do you draw arrows and/or squares around certain areas of the spreadsheet, during your presentation? Is that an Excel add-in?
@LearnitTraining
3 жыл бұрын
HI Tywin! That is Zoomit!
Very Useful. Thanks for this man
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
I like your explanation and especially your intonation. Are you Joey Wheeler in Yu-Gi-Oh American version ? lol, just kidding.. I feel alike. Thanks for sharing.
Thank you for this tutor. I learnt a quite lot.
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
I learnt a lot, thank you
@LearnitTraining
Жыл бұрын
You are welcome!
It was tremendously helpful.
@LearnitTraining
2 жыл бұрын
Thank you for watching!