Excel 2019 Advanced Tutorial
Vložit
- čas přidán 5. 08. 2024
- 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.
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
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.
Awesome, thank you!
0:11
Thank you for the courses. You explain in an encouraging and motivating way. Looking forward to many new videos!!
Glad you like them!
Thanks a billion!!!❤️ Your teaching style is easy to understand plus the excercise worksheets made available are bonus.
Awesome! Thank you!
@@LearnitTraining aaaq14ff
0:47
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 !
I have finished first video and now i'm at 1:10:22 of this video. Thank you Learnit Training.
I’ve already finished the first two videos and learned a lot. Thanks for your hard work.
Glad you like them! Thank you for watching!
This is probably the best excel tutorial I've come upon (that is free). Very thorough and easy to understand. Thank you.
Glad it was helpful!
@@LearnitTraining; How do I get access to the Exercise files??
Can't agree more
@@jenniferlorence1950 You canfind it in the description. It's a zip file.
0:20
Excellent trainer. Super teaching skills.
This was a great learning tool, "expose ourselves to..." made me chuckle continuously.
Haha not the best choice of words there we must admit
Great vid. I believe the 'dots' around the charts are called 'handles'.
You provide great videos. Not rushed like some videos. You explain the procedure and have us try it. Thanks
You are welcome Deloris!
Very in depth and step by step. Great coaching. Thank you!
You're very welcome!
0:37
This is the only channel have a to-the-point explanation with easy understanding. Thanks for delivering such fantastic content free of cost.
You're very welcome!
0:49
Perfect, thank you so much :) so clear, understantable! Great job
You're very welcome!
Absolutely brilliant. Thanks a ton for clearing a lot of concepts. cheers
You're very welcome!
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) 😊
You are so welcome!
0:25
Thanks for this free tutorial! Very informative and straightforward.
You're very welcome!
This is the best tutorial ever, easy to understand with good examples! had to subscribe
Awesome, thank you!
Excellent training material; great training methodology. Thanks a lot.
You are welcome!
Thanks for sharing this I love excel and your content
excellent video!! thank you so much for this series!
You're very welcome!
Excellent presentation allowed me to understand and learn at a perfect pace.. Learnt a lot. Thank you.
Glad it was helpful!
THANK YOU VERY MUCH FOR SUCH AN AMAZING COURSE!! REALLY HELPED ME!
You're very welcome!
love the content, makes it look so easy 😁thank you for making these tutorials
Glad you like them!
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.
You're very welcome!
@@LearnitTraining 0:33
Thank you for this course, it is amazing and thanks for sharing your knowledge. :)
Glad you enjoy it!
I was desperately looking for data file. There are many material in the CZcams
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
You are very welcome Jimins!
This is GOLDEN. Thank you man. Keep it going!
Appreciate it!
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.
Thank you for the kind words Brhanfit!
This is the second tutorial for me. It is really helpful. Thank you so much.
Thank you for your continued support Mang Sian Lian!
I was searching for the exact analytics skills using excel in internet and found this video..... its amazing , Thanks a lot.
You are most welcome!
Thanks a lot, the course is really very detailed and helpful
You are welcome! Thank you for watching and an extra big thank you for subscribing!
Best Free Excel Tutorial I've ever seen.
Thank you for the kind words ZinZin!
Thoroughly enjoyed this and learnt a lot of new features.
Thank you for watching Rohit!
Best video ever your teaching style is so perfect, i have learned a lot from this video. Thank You
You are very welcome Khushbu! Thank you for watching!
Just thank you. It helped me a lot!!
Glad it helped!
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!
Thank you so much!
The best tutorial. clean and clear.
Glad you think so!
What a content!!! Really appreciate you man. Thanks a lot!!!
You are very welcome!
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
Awesome, thank you!
I am looking forward to the tutorial
The best Excel Tutorial ever!
Wow, thanks!
Thanks man 👍
Thank you! This is very useful!
Thank you for watching Monica!
The best Excel Tutorial I ever watched
Thank you for the kind words isaac!
Thank you so much for this video. This has helped me understand more.
Glad it was helpful!
Cool stuff!! Thanks a lot! Big help
Glad it helped!
Thank You Faz. really enjoyed it.
Glad you enjoyed it!
How are we getting the first column with Emp Id to take up a smaller space than the Title, creating tables?
fantastic course, so helpeful, thank you
You're very welcome!
This video was of immense help, thank you sooo much
You're so welcome!
Thanks a bunch! Wanna become a pro like you man.
Keep watching and you will be a pro soon!
I am loving it. The language, style presentation is awesome
Thank you! 😃
Man your explaining method are just next level.
Thank you for your continued support Xavier!
best excel course ever. thanks a lot
Thank you for the kind words Foday!
Excellent Tutorial. Beautifully explained. Thanks Faiz.
You are most welcome! Thank you for watching!
Sean Bugler did a good job in Excel 2016 videos.
It will be awesome if Sean be the teacher for these Courses again.
Excellent tutorial !!! Much appreciated 😀
Glad it was helpful!
useful video.
thanks.
Great video. Very helpful!
Glad it was helpful!
Amazing tutorial. You are a great teacher!!
Thank you so much!
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.
Hi FAZ great video, Sorry I do not see the pivot table file in the excercise file folder which one is it?
Thank you for that great illustration
Thank you for watching!
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.
Thank you so much. This was very useful
You're very welcome!
I like your tutorials. Much love from Kenya
Awesome! Thank you!
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.
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!
Thank you very much. The course is very useful, explanation of each step is very clear.
You are welcome!
thank you so much!!! very helpful.
You're welcome!
Your teaching style and voice are relaxing and soothing me.
Thank you for kind words!
Thank you learnit for providing this very informative excel video. I have completed each lesson. 🥰😊
You are welcome 😊
Tank you for your great tutorial.
Welcome 😊
Thank you thank you thank you!! Now I feel confident at my new admin job.
You are welcome! We hope you keep learning!
Very Useful. Thanks for this man
Glad it was helpful!
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!😁
Awesome, thank you!
Excellent tutorial. I really learned a lot.
Glad it was helpful!
this was so helpful thanks you so much
You're so welcome!
wow , this is great . Thanks so much . Is super useful .
Glad it was helpful!
Your teaching style is superb. Thanks a zillion.
You are very welcome Esther! Thank you for watching!
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.
I think you can make a good meditation guru, your voice is soothing in that way XD
Wow, thanks
thank you so much I learn that thing because of your video.
You are welcome!
Great job, thank you very much
Our pleasure!
Thank you for this tutor. I learnt a quite lot.
Glad it was helpful!
Very good tutorial, very helpful thumbs up , have recommended to all my colleagues thanks..
Thank you for sharing sumera! It helps us tremendously!
It was tremendously helpful.
Thank you for watching!
U earned a Subscriber!!! Great work..
Welcome aboard!
This is such a great help! Thank you very much :)
Glad it helped!
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?
I hope is not too late. You can use this formula:
=COUNTIF(DesiredRange, "0")
thanks we understand more in office especially excel
You are welcome
I learnt a lot, thank you
You are welcome!
a great video many thanks
You are welcome!
Thank you so much for this
You're so welcome!
thank you so much!
You are very welcome!
Thanks a bunch.
You're welcome!