Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Excel 2021 Pivot Tables Tutorial
Play lesson

Excel Training - Excel 2021 Pivot Tables Tutorial

4.0 (5)
41 learners

What you'll learn

This course includes

  • 102 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

Excel 2021 Pivot Tables Tutorial Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://tinyurl.com/4v7zd9md 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. 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 Learnit is no longer associated with this channel/video. (C) 2025 Bomberry Productions Any illegal reproduction of this content will result in immediate legal action.

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere