Excel: Mastering Pivot Table Dashboards and Reports

Offered By: LinkedIn Learning

Tags

Data Analysis Courses Data Visualization Courses Microsoft Excel Courses Data Modeling Courses Slicers Courses PivotTables Courses PivotCharts Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Discover an approachable, foolproof way of thinking about and using PivotTables in Microsoft Excel.

Syllabus

Introduction

Introduction to PivotTables

1. Working with PivotTables

Creating your first PivotTable
Counting with a PivotTable
Averaging with a PivotTable
Sum by quarter
Running totals
Month over month

2. PivotTable Tricks

PivotTable tips
Adding slicers
Adding timelines
PivotCharts

3. Excel Data Model

What is a data model?
Creating a data model dashboard

Taught by

Jordan Goldmeier

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