Excel Pivot Tables Tutorial - From Basics to Advanced Techniques
Offered By: Learnit Training via YouTube
Course Description
Overview
Syllabus
Start
Introduction
What are Pivot Tables?
Preparing Data for Analysis
Pivot Table Components
Building Pivot Tables to Show Different Values
Adding Fields to Pivot Tables
Using Built-In Filters
Filtering Data with Slicers
Displaying New Values from Data Sources
Inserting Pivot Charts
XLOOKUP
Joining Data Sets with XLOOKUP
Introduction to Advanced Pivot Tables
Inserting Pivot Tables from Tables
Calculated Fields
Using the Timeline Tool
Report Filter Pages
Pivot Table Layouts
Creating Pivot Table Designs
Adding Power Pivot Tabs to the Ribbon
Adding Tables to Power Pivot Data Model
Creating Table Relationships
Creating Columns with DAX Expressions
Displaying New Source Data in Power Pivot Tables
Data Mining with Flash Fill
Conclusion
Taught by
Learnit Training
Related Courses
Excel によるデータの分析と可視化Microsoft via edX Data Visualization and Dashboards with Excel and Cognos
IBM via Coursera Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera The Complete Microsoft Excel Pivot Tables and Pivot Charts
Udemy Microsoft Excel: Data Analysis with Excel Pivot Tables
Udemy