YoVDO

Excel 2021 Pivot Tables Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Mining Courses Data Analysis Courses Data Visualization Courses Data Organization Courses Power Pivot Courses XLOOKUP Courses

Course Description

Overview

Master Excel 2021 Pivot Tables in this comprehensive tutorial. Learn to organize and analyze large datasets efficiently, create custom reports, and visualize data using Pivot Tables and charts. Explore data mining techniques, custom sorting, and XLOOKUP functions. Dive into advanced features like Power Pivot for handling complex data relationships. Perfect for Excel users looking to enhance their data analysis skills and streamline their workflow. Includes hands-on exercises and covers everything from basic setup to advanced Pivot Table design and Power Pivot integration.

Syllabus

Start
Organizing Data in Tables
More Data Organization Techniques
Data Mining
Custom Sort Command and Functions
Merge Data Using XLOOKUP
Pivot Tables - Setup
Pivot Tables - Building Reports
Pivot Tables - Formats, Drilldowns, and Refreshing
Pivot Tables - Designing for Reports and Charts
Pivot Tables - Cal Fields, Items, and Grouping
Power Pivot - Turning It On
Power Pivot - Adding Data and Establishing Relationships
Power Pivot - RELATED Function and Pivot Tables
Conclusion


Taught by

Learnit Training

Related Courses

Introduction to Data Science
University of Washington via Coursera
Big Data Analytics in Healthcare
Georgia Institute of Technology via Udacity
More Data Mining with Weka
University of Waikato via Independent
Mining Massive Datasets
Stanford University via edX
Pattern Discovery in Data Mining
University of Illinois at Urbana-Champaign via Coursera