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

MongoDB for Developers
MongoDB University Data Wrangling with MongoDB
MongoDB via Udacity Intro to Point & Click App Development
Salesforce via Udacity SAP Business Suite powered by SAP HANA
SAP Learning Desarrollo de Aplicaciones Web: Conceptos Básicos
University of New Mexico via Coursera