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.
- Determine when it is necessary to click Defer Layout Update in the fields area.
- Recall the easiest way to create a PivotTable from external data that cannot be imported directly as an Excel table.
- Explain the configuration that takes up the least width on the screen while keeping the Fields List area visible.
- Identify the mistake users often make when creating filters.
- Explore the function of slicers.
- Review the use of data bars with a PivotTable.
- Name the first step in viewing all the conditional rules applied to a PivotTable.
- Recognize the appropriate way to save a macro.
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