->

 

Excel: PivotTables in Depth

MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch | Duration: 3h 38m

Genre: eLearning | Exercise Files | Language: English | Size: 522 mb


 

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.

 

Note: This course was recorded in Office 365. However, anyone using Excel 2019, Excel 2016, and even prior editions of Excel should be able to follow along with the course contents.

Topics include:

Creating a PivotTable

Pivoting a PivotTable

Summarizing PivotTable data with formulas and calculated fields

Sorting and filtering PivotTable data

Formatting PivotTables with styles and layouts

Applying conditional formatting such as highlighting

Creating PivotCharts

 

 

Excel: PivotTables in Depth

 


 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.


 Solid   |  

Information
Members of Guests cannot leave comments.




rss