YoVDO

Intermediate Microsoft Excel Tutorial - How to Use Power Pivot in Excel

Offered By: Teacher's Tech via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Data Visualization Courses Pivot Tables Courses Key Performance Indicators (KPIs) Courses Pivot Charts Courses Data Models Courses Power Pivot Courses

Course Description

Overview

Dive into an intermediate-level Microsoft Excel tutorial focusing on Power Pivot, a powerful free add-in for advanced data analysis. Learn how to install Power Pivot, import data from multiple sources, create relationships between tables using Diagram View, and perform column calculations. Explore various methods for adding measures, build reports using Pivot Tables, incorporate Key Performance Indicators (KPIs), and create insightful Pivot Charts. Follow along with provided practice files to master techniques for combining multiple sheets into a single Pivot Table or Chart, enabling deeper insights and more efficient data analysis. Gain practical skills to enhance your Excel proficiency and unlock the full potential of Power Pivot for complex data modeling and visualization.

Syllabus

Introduction to Power Pivot
How to install Power Pivot in Excel
Ways to bring data into Power Pivot
How to create relationships in Power Pivot Diagram View
How to create column calculation in Power Pivot
Different ways to add Measure in Power Pivot more calculations
Build a report with a Pivot Table in Power Pivot
Add a KPI Key Performance Indicator to your Pivot Table
Create a Pivot Chart with your data model


Taught by

Teacher's Tech

Related Courses

Intro to Statistics
Stanford University via Udacity
Introduction to Data Science
University of Washington via Coursera
Passion Driven Statistics
Wesleyan University via Coursera
Information Visualization
Indiana University via Independent
DCO042 - Python For Informatics
University of Michigan via Independent