Black Friday 2024: 50 Ways to Save on Online Learning

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel: Mastering Pivot Table Dashboards and Reports

via LinkedIn Learning

Go to class Write review

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Grab it
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

Reviews

4.6 rating at LinkedIn Learning based on 913 ratings

Start your review of Excel: Mastering Pivot Table Dashboards and Reports

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.