Home»2022»December»15»Linkedin Excel Pivot Tables Part 1 Mastering PivotTables and PivotCharts
08:44:35
Linkedin Excel Pivot Tables Part 1 Mastering PivotTables and PivotCharts
Included Exercise Files
Skill Level : Intermediate
Duration : 4h 7m
Language : English
Released : 12/3/2018
Size : 634,63 Mb
While the power and time-saving value of PivotTables appeals to anyone who analyzes data in Excel, many users are too intimidated by the feature to add it to their workflow. In this course—the first installment in a two-part series—instructor Chris Dutton breaks down how to use PivotTables, as well as how to add PivotCharts to the mix to summarize your data visually. Throughout the course, Chris shares practical tips and demonstrations that help you grasp how these tools are used in the real world, as well as how PivotTable values are actually calculated and displayed. Learn how to prepare your raw data for analysis; leverage formatting, sorting, filtering, and grouping options; display values in multiple ways; create PivotCharts; and much more.
Topics include:
Establishing a layer convention and property filters
Structuring your source data
How PivotTables actually work
Number formatting and conditional formatting
Sorting and grouping options
Troubleshooting incorrect sorting
Value summarization and value calculation modes
Inserting calculated items
Visualizing data with PivotCharts
Designing interactive dashboards
