Excel 2016
Pivot Tables in Depth
Improve Your Microsoft Excel Skills,
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.
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
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 3h 42m |
| Starts | On Demand (Start anytime) |
| Cost | $29/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Curt Frye |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | Data Science Business |
| Tags | Data Analysis Business Excel Spreadsheets Microsoft Excel Pivot Tables |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
BUILD Leadership Development Program-Corporate Compensation Analyst $72k
Design-Build Design Coordinator $73k
Project Manager - Design Build Team $77k
Server Build Coordinator $82k
Technology Applications Engineer - Product Build Contractor $84k
IT Build Coordinator $86k
Team Build Center Technician Lead $92k
Project Manager/Build Manager $99k
Senior Server Design & Build Engineer $126k
Senior Build and Release Engineer Manager $146k
Senior Software Build/Release Engineer $190k
Vice Assistant President Build Engineer $210k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 3h 42m |
| Starts | On Demand (Start anytime) |
| Cost | $29/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Curt Frye |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | Data Science Business |
| Tags | Data Analysis Business Excel Spreadsheets Microsoft Excel Pivot Tables |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
