Excel 2021 Pivot Tables Tutorial

Excel 2021 Pivot Tables Tutorial

Get Ad-Free Training by becoming a member today!

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:

For Private Group Trainings please visit:

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.

[IT_Wizz]

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!

[dkerze]

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

[mohammadmohsinkhan]

best tutorial ever, Good Job Mr. Karim

[paulajohnston]

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

[ManiShankar-wewow]

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!

[JeanMcAllister-splt]

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.

[dilipsalgaonkar]

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

[KaytsAloy]

great training, very cool and competent you.✌

[cryptombt]

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

[danivilla]

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

[joycenaicker]

Thank you. Learnt a lot from this video.

[priyankachourasiya]

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

[priyankachourasiya]

I have waiting for watching this video

[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.

[roshanrox]

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)

[bolaj_r]

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

[priyankachourasiya]

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

[abhijithtpadmanabhan]

You are providing the wrong link, the wrong file

[abhijithtpadmanabhan]

i didnt get the file you mentioned from the link

[arifishtiaq]

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