Author
Curt Frye
Released
10/31/2018Note: This course was recorded in Office 365. However, anyone using Excel 2019, Excel 2016, and even prior editions of Excel should be able to follow along with the course contents.
- Creating a PivotTable
- Pivoting a PivotTable
- Summarizing PivotTable data with formulas and calculated fields
- Sorting and filtering PivotTable data
- Formatting PivotTables with styles and layouts
- Applying conditional formatting such as highlighting
- Creating PivotCharts
Skill Level Intermediate
Duration
Views
- [Curt] Excel PivotTables are a powerful tool for evaluating data within your business or organization. Mastering the skills you need to manage PivotTables effectively will let you work quickly and make great decisions. In this course I'll use real-world examples to demonstrat how you can apply the incredible power of Excel PivotTables to your data. Join me at LinkedIn Learning for an introduction to the essential skills that will let you unlock the power and flexibility that comes with Excel PivotTables for Office 365.
-
Introduction
-
1. Creating and Pivoting PivotTables
-
Introducing PivotTables3m 43s
-
Create a PivotTable3m 46s
-
Pivot a PivotTable3m 44s
-
Configure a PivotTable5m 9s
-
Manage PivotTables5m 48s
-
-
2. Summarizing PivotTable Data
-
Manage dates in a PivotTable2m 49s
-
Create a calculated field4m 33s
-
3. Sorting and Filtering PivotTable Data
-
Sort PivotTable data2m 21s
-
Create a custom sort order5m 36s
-
Filter a PivotTable by rule4m 37s
-
Format slicers4m 48s
-
-
4. Formatting PivotTables
-
Apply a PivotTable style3m 28s
-
Change the PivotTable layout3m 29s
-
-
5. Applying Conditional Formats to PivotTables
-
Format cells using data bars5m 11s
-
Format cells using icon sets5m 54s
-
6. Creating and Formatting PivotCharts
-
Create a PivotChart2m 26s
-
Pivot a PivotChart2m 14s
-
Filter a PivotChart2m 16s
-
Format a PivotChart3m 38s
-
-
7. Printing PivotTables
-
Print a PivotTable1m 57s
-
Set PivotTable print options4m 46s
-
Print a PivotChart2m 9s
-
-
8. Manipulating PivotTables
-
Run an Excel macro6m 23s
-
9. Enabling and Adding Tables to the Data Model
-
Edit table relationships2m 25s
-
Conclusion
-
Further information1m 6s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Work in depth with PivotTables