Excel: Power Pivot for Beginners

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Data Analysis Courses KPIs (Key Performance Indicators) Courses Data Models Courses Power Pivot Courses PivotTables Courses PivotCharts Courses

Course Description

Overview

Get a short, beginner-friendly introduction to the robust Power Pivot feature in Microsoft Excel for Windows.

Syllabus

Introduction

Doing more in Excel with Power Pivot

1. Understanding Power Pivot

Become familiar with the Power Pivot interface

2. Building a Basic Data Model

Get started by connecting with source data
Create and manage data relationships
Enhance your data by adding calculations
Generate insights on the fly by creating measures

3. Presenting Your Data

Analyze results using PivotTables
Wow stakeholders with KPIs
Illustrate results using PivotCharts

Conclusion

Where to learn more about Power Pivot

Taught by

Joshua Rischin

Related Courses

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX