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

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard