Excel: Mastering Pivot Table Dashboards and Reports

Focused View

Jordan Goldmeier

1:16:50

221 View

01 - Introduction

01 - Introduction to PivotTables.mp4

08:56

02 - 1. Working with PivotTables

01 - Creating your first PivotTable.mp4

08:08

02 - Counting with a PivotTable.mp4

01:55

03 - Averaging with a PivotTable.mp4

01:29

04 - Sum by quarter.mp4

01:40

05 - Running totals.mp4

03:08

06 - Month over month.mp4

03:22

03 - 2. PivotTable Tricks

01 - PivotTable tips.mp4

06:03

02 - Adding slicers.mp4

04:35

03 - Adding timelines.mp4

01:57

04 - PivotCharts.mp4

02:36

04 - 3. Excel Data Model

01 - What is a data model.mp4

08:49

02 - Creating a data model dashboard.mp4

24:12

Description

PivotTables are one of the most important features available in Microsoft Excel. They simplify data analysis, allowing you to create summaries and reports instantly, and they just got even better. The new Excel data model takes things a step further by letting you connect PivotTables to build out a miniature database. In this course, instructor Jordan Goldmeier shows you how to get up and running with PivotTable basics. Discover an approachable, foolproof way of thinking about PivotTables that allows you to build summaries across different column fields with ease from any dataset. Along the way, learn how to use PivotTable connections to create an interactive dashboard for replication and reuse.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Excel Dashboard

Pivot Tables

Power Pivot

Jordan Goldmeier

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.