Categories: Tutorials » Office Productivity
Excel: PivotTables in Depth
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 3h 50m | 725 MB
Instructor: Curt Frye
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 3h 50m | 725 MB
Instructor: Curt Frye
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.
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.
Related Posts
Information
Members of Guests cannot leave comments.