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

Excel Skills for Business: Intermediate I
Macquarie University via Coursera Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Access 2016: Building Dashboards for Excel
LinkedIn Learning Excel 2016: Setting Up a Database
LinkedIn Learning Excel PivotTables: Mastering PivotTables and PivotCharts
LinkedIn Learning