Excel 2016: Pivot Tables in Depth – Curt Frye
Excel 2016: Pivot Tables in Depth
By: Curt Frye
Level: Intermediate
Duration: 3h 42m
Released: Jan 13, 2016
Description:
Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.
Topics include:
- Formatting data for use in a PivotTable
- Creating a new PivotTable
- Connecting to data sources
- Consolidating data from multiple data sources
- Creating calculated fields
- Summarizing field data
- Sorting and filtering PivotTables
- Working with Excel slicers
- Formatting PivotTables with styles and formats
- Applying conditional formats
- Creating PivotCharts
- Printing PivotTables
- Running macros
- Creating a PivotTable using the data model
Contents:
- Introduction
- 1. Creating and Pivoting PivotTables
- 2. Summarizing PivotTable Data
- 3. Sorting and Filtering PivotTable Data
- 4. Formatting PivotTables
- 5. Applying Conditional Formats to PivotTables
- 6. Creating and Manipulating PivotCharts
- 7. Printing PivotTables
- 8. Manipulating PivotTables
- 9. Creating PivotTables Using the Data Model
- Conclusion
Author:
Curt Frye is a freelance writer and consultant who specializes in Microsoft Excel. He is the author of more than 40 books and online training courses, including Microsoft Excel 2010 Step by Step (Microsoft Press), the Excel 2007 Pocket Guide (O’Reilly Media), and over a dozen courses for lynda.com. Curt is also a valued speaker who delivers keynote addresses on Excel as a business intelligence analysis tool and his Improspectives ™ approach to business communication.
Access Download Excel 2016: Pivot Tables in Depth – Curt Frye right now!
Delivery Method:
After your purchase, you’ll get access to the downloads page. Here, you can download all the files associated with your order.
Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from Vinlearn.
