Excel
PivotTables in Depth
Heads up! This course may be archived and/or unavailable.
Many Excel users have a fear of PivotTables. This course provides a thorough introduction to this powerful and overlooked feature and, for more advanced students, shows how to use macros and the data model to extend PivotTables even further. Instructor Curt Frye demystifies PivotTables, using real-world examples that empower students to make the most of their time with the program and to analyze their data effectively. Learn how to evaluate and summarize data, sort and filter results, format your PivotTables with styles and conditional formatting, and visualize your analysis with PivotCharts.
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 Formatting PivotCharts
- 7. Printing PivotTables
- 8. Manipulating PivotTables
- 9. Enabling and Adding Tables to the Data Model
- Conclusion
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 3h 38m |
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 Business Intelligence Microsoft Excel Business Intelligence (BI) Pivot Tables |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Middle School English Language Development, AVID & AVID Excel Teacher $50k
English Language Development, AVID & AVID Excel Teacher $53k
Excel Reporting Developer $68k
Excel/Access DTS Developers $78k
Many different sales & marketing positions $80k
Many various sales positions Manager $81k
Many Positions $82k
Excel VBA Developer $82k
Excel/Access DTS Developer $83k
Tutor - Accounting/ Excel /ESL $87k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 3h 38m |
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 Business Intelligence Microsoft Excel Business Intelligence (BI) 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