Excel 2021 Pivot Tables Tutorial

Excel 2021 Pivot Tables Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/3SDEMaR
Who it's for: Anyone who uses Excel and wants to learn one of the most powerful tools Excel offers.
What it is: Pivot Tables helps you easily take a very large dataset and create a table that only displays the information you need.
What you'll learn: You’ll learn how to easily create, modify, and update Pivot Tables and charts.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Organizing Data in Tables 5:55
More Data Organization Techniques 13:17
Data Mining 17:58
Custom Sort Command and Functions 22:42
Merge Data Using XLOOKUP 33:28
Pivot Tables - Setup 42:01
Pivot Tables - Building Reports 49:38
Pivot Tables - Formats, Drilldowns, and Refreshing 57:45
Pivot Tables - Designing for Reports and Charts 1:04:50
Pivot Tables - Cal Fields, Items, and Grouping 1:15:35
Power Pivot - Turning It On 1:21:43
Power Pivot - Adding Data and Establishing Relationships 1:23:51
Power Pivot - RELATED Function and Pivot Tables 1:28:57
Conclusion 1:33:23
#excel #exceltutorial #exceltips #pivottables
(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[@mohammadmohsinkhan6485]

best tutorial ever, Good Job Mr. Karim

[@LearnitTraining]

Thank you!

[@nkaraobasi1099]

Thank you Faz, you are a good tutor.

[@LearnitTraining]

Thank you for the kind words!

[@dkerze]

This is an awesome training video. Thanks for this. Excellent instructor. Very knowledgeable and easy to follow along.

[@LearnitTraining]

Thank you for watching!

[@KaytsAloy]

great training, very cool and competent trainer..............thank you.✌

[@LearnitTraining]

Glad you enjoyed it!

[@ManiShankar-we2wow]

Thank you for an wonderful tips and tricks with Pivot table!. This is really helpful for people who works lot on data with Excel. Great work Team!

[@LearnitTraining]

You are very welcome! Thank you for the kind words!

[@paulajohnston3015]

I love your training and so helpful. More please!! Thanks

[@LearnitTraining]

Thank you so much Paula! We will keep it up!

[@dilipsalgaonkar2207]

Faz you are too good. So well explained. Hats off.

[@LearnitTraining]

Thank you so much 😀

[@___GuRu___]

Thank you very much for this impressive training. The way you explain the material is crystal clear and super methodically which makes it a real joy to follow these courses. Keep up the great work guys!

[@LearnitTraining]

You're very welcome!

[@JeanMcAllister-sp9lt]

Awesome presentation! Excellent coverage of material. Loved the way you said what you were going to show, then showed what you said you were going to show, and finally summarized what you showed. Also, the emphasis of the changes to the tool bar were very helpful.

[@LearnitTraining]

Glad it was helpful!

[@cryptombt5880]

I truly truly love this channel guys. You have helped me achieve soooooooooo much. Thank you so much

[@LearnitTraining]

We are so glad we were able to help you MaxT! We wish you continued success!

[@rehmansoofi]

Brilliant

[@LearnitTraining]

Thank you!

[@danivilla2517]

Super Super nice tutorial. It helps tons thank you so much. Excel has an incredible power

[@LearnitTraining]

You are welcome!

[@joycenaicker6251]

Thank you. Learnt a lot from this video.

[@LearnitTraining]

Thank you for the kind words!

[@priyankachourasiya9712]

I understand and very useful for me this video ... Thank you so much 🥰

[@LearnitTraining]

You are very welcome!

[@emileriksen2481]

@@LearnitTraining Is there any chance you can upload a sheet that is "clean" so not worked on already, so we can do the different exercises in the video ourselves? Excellent content otherwise!

[@priyankachourasiya9712]

I have waiting for watching this video

[@LearnitTraining]

Hope you enjoyed it!

[@Abhi_shakti]

In Insert Tab view, i cannot see Add ins command Group, (video time: 9:46) besides illustrations menu. How can i bring that? Though Addin options is available in Home tab.

[@roshanrox9285]

Hello There! i want one excel Formula > how to calculate OT1, OT2, Regular hour in excel. if hours fall between 00:00 to 05:00 it is OT2 , if hours fall between 05:00 to 8:30 it is OT1, if hours fall between 8:30 to 18:00 it is regular hour, if hours fall between18:00 to 21:00 it is OT1, if hours fall between 21:00 to 24:00 is OT2. For example if employee starts work at 02:00 and ends at 22:00 then total working hour will be 20:00, Regular Hour will be 09:30, OT1 will 06:30 , OT2 will be 04:00. (OT=OVERTIME)

[@LearnitTraining]

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

[@priyankachourasiya9712]

I have a question ? Next video also excel topic ??

[@LearnitTraining]

Yes! Excel 2021 Power User will be premiering next Friday.

[@alabihafizabolade7816]

I am getting error for the revenue Column after using the related formula

[@LearnitTraining]

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

[@arifishtiaq8826]

I can't download the Exercise file, would you please help me

[@LearnitTraining]

Hello! The exercise files are in the course description. Make sure you're using a computer that allows you to download files from OneDrive.

[@abhijithtpadmanabhan]

i didnt get the file you mentioned from the link

[@LearnitTraining]

Exercise Files: bit.ly/3SDEMaR

[@abhijithtpadmanabhan]

@@LearnitTraining its a different file, kindly replace it or provide the correct file

[@krantikumar894]

Unable see the screen

[@LearnitTraining]

Hi Kranti! The video should be up and ready to rewatch. Let us know if you're still having this issue.

[@abhijithtpadmanabhan]

You are providing the wrong link, the wrong file

[@LearnitTraining]

Hello Abhijith! We just checked the file and it is the same file that is used in the video. Please be sure you are on the tab.