Excel 2019 Advanced Tutorial

[@TheDisciplinedPoser]

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

[@LearnitTraining]

Glad it was helpful!

[@jenniferlorence1950]

@@LearnitTraining; How do I get access to the Exercise files??

[@michellegong6614]

Can't agree more

[@hawaiianengineer]

@@jenniferlorence1950 You canfind it in the description. It's a zip file.

[@ahmednavivwala1707]

0:20

[@zinzinzibidi]

Best Free Excel Tutorial I've ever seen.

[@LearnitTraining]

Thank you for the kind words ZinZin!

[@frankvandenblock6596]

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]

@@LearnitTraining 0:33

[@dribeiro7813]

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

[@LearnitTraining]

Awesome! Thank you!

[@hyabbelay3729]

@@LearnitTraining aaaq14ff

[@ahmednavivwala1707]

0:47

[@fluffysnugglebunny9176]

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

[@LearnitTraining]

Haha not the best choice of words there we must admit

[@rutvijshah3534]

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

[@LearnitTraining]

You're very welcome!

[@ahmednavivwala1707]

0:49

[@jiminslostjams250]

I was desperately looking for data file. There are many material in the KZbin 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]

You are very welcome Jimins!

[@carlav1306]

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!

[@sushobhon_ROY17]

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

[@LearnitTraining]

You are most welcome!

[@isaacAdam]

The best Excel Tutorial I ever watched

[@LearnitTraining]

Thank you for the kind words isaac!

[@marygracelaguin9547]

The best Excel Tutorial ever!

[@LearnitTraining]

Wow, thanks!

[@oudomchan3494]

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

[@xavierbloomberg6063]

Man your explaining method are just next level.

[@LearnitTraining]

Thank you for your continued support Xavier!

[@akashkamal3758]

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

[@khushbupatel1322]

Best video ever your teaching style is so perfect, i have learned a lot from this video. Thank You

[@LearnitTraining]

You are very welcome Khushbu! Thank you for watching!

[@nechiw8182]

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

[@LearnitTraining]

Awesome, thank you!

[@jamescompton7607]

This is GOLDEN. Thank you man. Keep it going!

[@LearnitTraining]

Appreciate it!

[@irinavistar7417]

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]

Awesome, thank you!

[@ahmednavivwala1707]

0:11

[@enlighten92]

Thoroughly enjoyed this and learnt a lot of new features.

[@LearnitTraining]

Thank you for watching Rohit!

[@JhayzBoy2012]

This is the second tutorial for me. It is really helpful. Thank you so much.

[@LearnitTraining]

Thank you for your continued support Mang Sian Lian!

[@iwalewa_ery]

Your teaching style is superb. Thanks a zillion.

[@LearnitTraining]

You are very welcome Esther! Thank you for watching!

[@offlineshipon]

Going to add checklist by date wise 31-08-2024: 21:26 02-09-2024: 36:57 03-09-2024: 1:00:00 04-09-2024: 1:17:25 05-09-2024: 1:31:37(xD) Thanks Faz 💕💕

[@LearnitTraining]

👍👍👍👍

[@CarniFlex1]

Your teaching style and voice are relaxing and soothing me.

[@LearnitTraining]

Thank you for kind words!

[@eileenmohan9756]

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]

Awesome, thank you!

[@whospower]

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!

[@jargonmaster2042]

I like your tutorials. Much love from Kenya

[@LearnitTraining]

Awesome! Thank you!

[@niudartakh2058]

Thank you very much. The course is very useful, explanation of each step is very clear.

[@LearnitTraining]

You are welcome!

[@tusharkumar8569]

Thank you learnit for providing this very informative excel video. I have completed each lesson. 🥰😊

[@LearnitTraining]

You are welcome 😊

[@MmePhillips]

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]

Thank you so much!

[@ragkan7577]

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

[@LearnitTraining]

Glad you like them!

[@cb5697]

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

[@LearnitTraining]

Glad you like them!

[@millieg939]

I am loving it. The language, style presentation is awesome

[@LearnitTraining]

Thank you! 😃

[@dlkhazz6801]

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

[@LearnitTraining]

Glad you like them! Thank you for watching!

[@jacquelinemeneses9621]

Thanks for this free tutorial! Very informative and straightforward.

[@LearnitTraining]

You're very welcome!

[@babuumakantvuppala9598]

Excellent trainer. Super teaching skills.

[@Team8LA]

Thank you thank you thank you!! Now I feel confident at my new admin job.

[@LearnitTraining]

You are welcome! We hope you keep learning!

[@trulyarunachali]

The best tutorial. clean and clear.

[@LearnitTraining]

Glad you think so!

[@fodaydaboh1958]

best excel course ever. thanks a lot

[@LearnitTraining]

Thank you for the kind words Foday!

[@manishgoyal1482]

What a content!!! Really appreciate you man. Thanks a lot!!!

[@LearnitTraining]

You are very welcome!

[@shashisinha5844]

Excellent Tutorial. Beautifully explained. Thanks Faiz.

[@LearnitTraining]

You are most welcome! Thank you for watching!

[@walikas]

Thank you for that great illustration

[@LearnitTraining]

Thank you for watching!

[@UPENDRAKUMAR-kv2mc]

Very nice tutorials. But I could not find the sheets that you are telling to refer... I mean the datasets that you are showing. Could you please provide link for that....

[@LearnitTraining]

Hi Upendra - the link to the exercise files is in the video description

[@simpleexcelexamples9619]

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]

You are so welcome!

[@ahmednavivwala1707]

0:25

[@MJKhan-t9j]

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

[@LearnitTraining]

Glad you enjoy it!

[@invenew]

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.

[@Vortex__24]

This video was of immense help, thank you sooo much

[@LearnitTraining]

You're so welcome!

[@tusharabdullah4344]

Where is the practice file I did not find from project files?

[@delorissmith8248]

You provide great videos. Not rushed like some videos. You explain the procedure and have us try it. Thanks

[@LearnitTraining]

You are welcome Deloris!

[@cerulinesoul]

Absolutely brilliant. Thanks a ton for clearing a lot of concepts. cheers

[@LearnitTraining]

You're very welcome!

[@CreativeHorizonNow]

Amazing tutorial. You are a great teacher!!

[@LearnitTraining]

Thank you so much!

[@hookmasteriii]

Excellent tutorial !!! Much appreciated 😀

[@LearnitTraining]

Glad it was helpful!

[@crkcrk81]

Very helpful video. However, the exercise files linked in the video description already have all of the exercises applied, making it very hard to follow along with the video, as all of the exercises have to be undone before they can be done again.

[@LearnitTraining]

Hi Charles - use the xlsx files that have the word "clean" in them. They are starting files to use for the class

[@nomanghaforzai1012]

Sean Bugler did a good job in Excel 2016 videos. It will be awesome if Sean be the teacher for these Courses again.

[@themoneyman9717]

I just finished the first video, I'm about to see the second one but I can't use the "Onedrive" files that I downloaded. Please can I get it through another means? I'd be really grateful 🙏

[@sukhninj]

Tank you for your great tutorial.

[@LearnitTraining]

Welcome 😊

[@ElsaAndAnnie]

Excellent training material; great training methodology. Thanks a lot.

[@LearnitTraining]

You are welcome!

[@bharathnv5044]

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.

[@querrythis]

Excellent presentation allowed me to understand and learn at a perfect pace.. Learnt a lot. Thank you.

[@LearnitTraining]

Glad it was helpful!

[@nanahauwauhauwau955]

I learnt a lot, thank you

[@LearnitTraining]

You are welcome!

[@ahmedmohamudduale2797]

thanks we understand more in office especially excel

[@LearnitTraining]

You are welcome

[@sumeramalik480]

Very good tutorial, very helpful thumbs up , have recommended to all my colleagues thanks..

[@LearnitTraining]

Thank you for sharing sumera! It helps us tremendously!

[@Amelia-bx3pg]

thank you so much!!! very helpful.

[@LearnitTraining]

You're welcome!

[@chiebukaibeh9111]

Hello there, I really appreciate the effort you put into your videos it's really helpful. I have question though, can I do a subtotal on an initially done subtotal? I hope you understand my question

[@LearnitTraining]

Hello Chiebuka! You can get help directly from our instructors at Offsite, our online community -www.offsitebylearnit.com/

[@tolulopeesho852]

Nice presentation. Thank you

[@LearnitTraining]

You are welcome

[@MayTeng_BeautyWellbeing]

wow , this is great . Thanks so much . Is super useful .

[@LearnitTraining]

Glad it was helpful!

[@lalakid2139]

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

[@usmanabdullahi3560]

Thank you for this tutor. I learnt a quite lot.

[@LearnitTraining]

Glad it was helpful!

[@2wheeledgreco271]

Cant find the correct excel file from the zip???

[@mss9466]

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

[@LearnitTraining]

You're very welcome!

[@ahmednavivwala1707]

0:37

[@positivity5727]

Thank you so much for this video. This has helped me understand more.

[@LearnitTraining]

Glad it was helpful!

[@jonathanowen9917]

Excellent tutorial. I really learned a lot.

[@LearnitTraining]

Glad it was helpful!

[@whereszeinab]

I think you can make a good meditation guru, your voice is soothing in that way XD

[@LearnitTraining]

Wow, thanks

[@mdrabbani1167]

It was tremendously helpful.

[@LearnitTraining]

Thank you for watching!

[@umeshdhole3666]

thank you so much I learn that thing because of your video.

[@LearnitTraining]

You are welcome!

[@brhanfit6470]

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]

Thank you for the kind words Brhanfit!

[@chamikaruwan684]

Very grateful to you, Learned lot of this vedio

[@LearnitTraining]

You are very welcome!

[@anishaamin944]

U earned a Subscriber!!! Great work..

[@LearnitTraining]

Welcome aboard!

[@yannikamiller6350]

Great video. Very helpful!

[@LearnitTraining]

Glad it was helpful!

[@alcq2006]

Just thank you. It helped me a lot!!

[@LearnitTraining]

Glad it helped!

[@juniorbosso6943]

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

[@Silas832]

Great job, thank you very much

[@LearnitTraining]

Our pleasure!

[@damilolaolaogbebikan5789]

I find this video very easy to understand. However, in calculating the subtotal, my icon is completely greyed out. Please why's that?

[@damilolaolaogbebikan5789]

I practiced with a set of data of my own. I found out my subtotal icon was completely greyed out after selecting a cell within the table. What do I do?

[@LearnitTraining]

Hi Damiola! You can get your questions answered at Offsite, our online community - www.offsitebylearnit.com

[@adambalaz1604]

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

[@LearnitTraining]

You're very welcome!

[@todaysmelody6723]

Cool stuff!! Thanks a lot! Big help

[@LearnitTraining]

Glad it helped!

[@RebeccasFinanceTutorials]

Thanks for sharing this I love excel and your content

[@yuniol1116]

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]

1:26:58

[@siusangho7946]

thanks so amazing, i can learn alot from Excel. :)

[@LearnitTraining]

You are welcome!

[@VijayPatel-gi6wc]

thank you sir you teach very nice and good i learned lot

[@LearnitTraining]

Thank you very much!

[@wutehmccurry5621]

Where do you go to download the files to go along?

[@mina0653]

excellent video!! thank you so much for this series!

[@LearnitTraining]

You're very welcome!

[@way2ebusiness]

please how to stop entering duplicated values with a specific number of duplicates depending on specific conditions, waiting for reply

[@LearnitTraining]

Hi way2 ebusiness! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com

[@chamathwickramasinghe6613]

Thank you so much. This was very useful

[@LearnitTraining]

You're very welcome!

[@mirodeniro3595]

I thought I knew how to use Excel .... after watching your video , I realized I am a beginner!

[@LearnitTraining]

Hi Miro! We all can learn more!

[@DanielLamarche]

I am unable to use the data tables provided. Every time I want to insert a Slicer for example Excel prompts to supply information to connect to an external dataset.

[@LearnitTraining]

Hi Daniel! Please be sure that the data you are reference has been converted to a table first

[@tam6915]

Thank you

[@LearnitTraining]

You're welcome

[@nadyamoscow2461]

Thanks a lot, the course is really very detailed and helpful

[@LearnitTraining]

You are welcome! Thank you for watching and an extra big thank you for subscribing!

[@parvezhussain3085]

Thank you guys

[@LearnitTraining]

Thank you for watching Parvez!

[@thebosh7801]

why can't i find the "creating tables" sheet in the exercise files i downloaded? am i looking in the wrong place?...lol

[@LeoCervp]

Me neither

[@naufalmuhammadalif-siths]

I also had same issue. But, I found that the tab was just not apparent. You can click small arrow button on the left of the tabs list.

[@lowvoltageghost888]

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]

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]

@@alextagbo7504 thank you

[@saidurrahmansujon5691]

Thanks a bunch! Wanna become a pro like you man.

[@LearnitTraining]

Keep watching and you will be a pro soon!