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

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