- Level:
- Duration: 03h 50m
- Release date: 2021-11-17
- Author: Curt Frye
- Provider: LinkedIn
Excel: PivotTables in Depth
Many Excel users arenât sure how to use PivotTables. 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. Curt steps you through how to sort and filter PivotTable data, format your PivotTable and, and apply conditional formats. Plus, he goes over 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.
- Introduction01m 34s
- Apply the power of Excel PivotTables00m 32s
- What you should know before starting00m 41s
- The changing Excel interface00m 21s
- 1. Creating and Pivoting PivotTables38m 13s
- Introduction to PivotTables03m 31s
- Format data for use in a PivotTable03m 02s
- Create a PivotTable03m
- Pivot a PivotTable05m 09s
- Configure a PivotTable04m 27s
- Connect to an external data source02m 57s
- Consolidate data from multiple sources05m 07s
- Manage PivotTables06m 52s
- Define a default PivotTable layout04m 08s
- 2. Summarizing PivotTable Data25m 33s
- Manage subtotals and grand totals03m 28s
- Change the data field summary operation03m 59s
- Summarize more than one data field02m 40s
- Manage dates in a PivotTable04m 33s
- Create a calculated field04m 19s
- Use PivotTable data in a formula04m 05s
- Drill down to the underlying data02m 29s
- 3. Sorting and Filtering PivotTable Data43m 57s
- Sort PivotTable data03m 54s
- Create a custom sort order04m 47s
- Filter a PivotTable field by selection03m 59s
- Filter a PivotTable by rule03m 57s
- Filter a PivotTable using a search filter03m 23s
- Filter a PivotTable using slicers05m 16s
- Format slicers06m 19s
- Filter a PivotTable with report filter fields04m 01s
- Clear and reapply PivotTable filters03m 49s
- Filter a PivotTable using a Timeline04m 32s
- 4. Formatting PivotTables18m 25s
- Apply a PivotTable style04m 06s
- Create a PivotTable style05m 48s
- Change the PivotTable layout05m 18s
- Change the data field number format03m 13s
- 5. Applying Conditional Formats to PivotTables34m 06s
- Highlight cells by applying a rule03m 59s
- Highlight the top or bottom values in a PivotTable05m 06s
- Format cells using data bars05m 37s
- Format cells using color scales03m 47s
- Format cells using icon sets06m 01s
- Edit a conditional formatting rule03m 26s
- Control how multiple rules are applied03m 18s
- Delete a conditional formatting rule02m 52s
- 6. Creating and Formatting PivotCharts22m 54s
- Create a PivotChart04m 02s
- Pivot a PivotChart02m 02s
- Filter a PivotChart03m 26s
- Format a PivotChart03m 38s
- Change a PivotChartâs layout02m 51s
- Change a PivotChartâs chart type02m 53s
- Add a trendline to a PivotChart04m 02s
- 7. Printing PivotTables12m 48s
- Print a PivotTable02m 36s
- Set PivotTable print options04m 23s
- Print each item on its own page04m 32s
- Print a PivotChart01m 17s
- 8. Manipulating PivotTables14m 21s
- Record and review an Excel macro03m 57s
- Run an Excel macro05m 26s
- Create a simple PivotTable presentation kit02m 40s
- Change PivotTables using keyboard shortcuts02m 18s
- 9. Enabling and Adding Tables to the Data Model17m 46s
- Create relationships between tables03m 59s
- Create a PivotTable using the data model03m 18s
- Edit table relationships02m 53s
- Deactivate and delete table relationships04m 01s
- Define sets using the Data Model03m 35s
- Conclusion01m 09s
- Additional resources01m 09s
- Financial Modeling: Build a Complete DCF Valuation Model
- Build an Image Classifier with Microsoft Azure Cognitive Service
- Learning LinkedIn
- Personas: The Ultimate Beginner's Guide to User Experience
- The Complete App Design Course - UX, UI and Design Thinking
- Profile Your Data with Power BI
- Putting PowerShell to Work
- Learn Game Logo Art Design in Photoshop With UI buttons
- Leading from Anywhere (Blinkist Summary)
- Data Strategy = Business Strategy: Executive Briefing
- Ember.js: The Documentary
- GraphQL: The Documentary
- AWS Certified Solutions Architect - Professional (SAP-C01) Cert Prep: 1 Design for Organizational Complexity
- CCSP Cert Prep: 4 Cloud Application Security
- What Business Leaders Need to Know about Web3 (+ Metaverse)
- Building No-Code Apps with AppSheet: Implementation
- Automation Anywhere: The Big Picture
- Protective Technology with Apache Kafka
- Coding for Visual Learners: Learning JavaScript from Scratch
- StringBuilder Internals