Excel: PivotTables in Depth

Focused View

Curt Frye

3:50:46

0 View

[1] Introduction

[1] Apply the power of Excel PivotTables.mp4

00:32

[2] What you should know before starting.mp4

00:41

[3] The changing Excel interface.mp4

00:21

[2] 1. Creating and Pivoting PivotTables

[1] Introduction to PivotTables.mp4

03:31

[2] Format data for use in a PivotTable.mp4

03:02

[3] Create a PivotTable.mp4

03:00

[4] Pivot a PivotTable.mp4

05:09

[5] Configure a PivotTable.mp4

04:27

[6] Connect to an external data source.mp4

02:57

[7] Consolidate data from multiple sources.mp4

05:07

[8] Manage PivotTables.mp4

06:52

[9] Define a default PivotTable layout.mp4

04:08

[3] 2. Summarizing PivotTable Data

[1] Manage subtotals and grand totals.mp4

03:28

[2] Change the data field summary operation.mp4

03:59

[3] Summarize more than one data field.mp4

02:40

[4] Manage dates in a PivotTable.mp4

04:33

[5] Create a calculated field.mp4

04:19

[6] Use PivotTable data in a formula.mp4

04:05

[7] Drill down to the underlying data.mp4

02:29

[4] 3. Sorting and Filtering PivotTable Data

[1] Sort PivotTable data.mp4

03:54

[2] Create a custom sort order.mp4

04:47

[3] Filter a PivotTable field by selection.mp4

03:59

[4] Filter a PivotTable by rule.mp4

03:57

[5] Filter a PivotTable using a search filter.mp4

03:23

[6] Filter a PivotTable using slicers.mp4

05:16

[7] Format slicers.mp4

06:19

[8] Filter a PivotTable with report filter fields.mp4

04:01

[9] Clear and reapply PivotTable filters.mp4

03:49

[10] Filter a PivotTable using a Timeline.mp4

04:32

[5] 4. Formatting PivotTables

[1] Apply a PivotTable style.mp4

04:06

[2] Create a PivotTable style.mp4

05:48

[3] Change the PivotTable layout.mp4

05:18

[4] Change the data field number format.mp4

03:13

[6] 5. Applying Conditional Formats to PivotTables

[1] Highlight cells by applying a rule.mp4

03:59

[2] Highlight the top or bottom values in a PivotTable.mp4

05:06

[3] Format cells using data bars.mp4

05:37

[4] Format cells using color scales.mp4

03:47

[5] Format cells using icon sets.mp4

06:01

[6] Edit a conditional formatting rule.mp4

03:26

[7] Control how multiple rules are applied.mp4

03:18

[8] Delete a conditional formatting rule.mp4

02:52

[7] 6. Creating and Formatting PivotCharts

[1] Create a PivotChart.mp4

04:02

[2] Pivot a PivotChart.mp4

02:02

[3] Filter a PivotChart.mp4

03:26

[4] Format a PivotChart.mp4

03:38

[5] Change a PivotCharts layout.mp4

02:51

[6] Change a PivotCharts chart type.mp4

02:53

[7] Add a trendline to a PivotChart.mp4

04:02

[8] 7. Printing PivotTables

[1] Print a PivotTable.mp4

02:36

[2] Set PivotTable print options.mp4

04:23

[3] Print each item on its own page.mp4

04:32

[4] Print a PivotChart.mp4

01:17

[9] 8. Manipulating PivotTables

[1] Record and review an Excel macro.mp4

03:57

[2] Run an Excel macro.mp4

05:26

[3] Create a simple PivotTable presentation kit.mp4

02:40

[4] Change PivotTables using keyboard shortcuts.mp4

02:18

[10] 9. Enabling and Adding Tables to the Data Model

[1] Create relationships between tables.mp4

03:59

[2] Create a PivotTable using the data model.mp4

03:18

[3] Edit table relationships.mp4

02:53

[4] Deactivate and delete table relationships.mp4

04:01

[5] Define sets using the Data Model.mp4

03:35

[11] Conclusion

[1] Additional resources.mp4

01:09

Description

PivotTables are one of the most powerful features in Excel, yet many users are barely scratching the surface of what they can do. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. He demonstrates ways to summarize your data, add calculated fields, filter your results, and format your layout to make it more readable. Learn how to sort and filter PivotTable data, format your PivotTable, and apply conditional formats. Curt also explains how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.

Note: This course was recorded in Microsoft 365. However, anyone using a recent standalone version of Excel (Excel 2021, 2019, or 2016) should be able to follow along with the course contents.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Pivot Tables

Curt Frye

Instructor's Courses

I'm president and founder of Technology and Society, Incorporated, an Oregon "C" Corporation that encompasses my work as a course developer, writer, and speaker. I offer programs on effective teamwork, personal development, and business storytelling. BA (political science) and MBA.

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.