Lynda - Excel: PivotTables in Depth

Lynda - Excel: PivotTables in Depth

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.

https://www.lynda.com/Excel-tutorials/Excel-PivotTables-Depth/761925-2.html

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

Table of Contents

Would you like to be a Author?