Introduction to PivotTables in Excel

This is the agenda for Table of Contents
Table of Contents
 
Introduction

Welcome

 
PivotTables basics

• What We Will Cover
• PivotTables Basics
• PivotTable Compliant Data Sources
• Creating a Basic PivotTable
• Creating a Basic PivotTable - Part 2

 
Formatting PivotTables

• Formatting PivotTables
• Creating an Expense Report
• Formatting the Expense Report PivotTable
• Finalizing the Expense Report PivotTable

 
Excel tables

• Excel Tables
• Sales Report Analysis with PivotTables
• Modifying Source Data
• Formatting the Sales Report
• Completing the Sales Report Analysis

 
Slicing and dicing your data

• Intro to Slicing Data
• Slicing Data
• Data Slicer Tools
• Linking Slicers to Multiple PivotTables

 
Connecting to databases

• Connecting to Databases
• Importing Data Sources
• Using PivotTables to Refine Data
• Consolidating Your Data Table
• Formatting Large Data Sets
• Slicing Large Data Sets
• Refreshing and Drilling Down from Databases

 
Conclusion

• In Review
• Conclusion
• Final Quiz

Highlights

Update your knowledge and strengthen your network at this must-attend conference covering the most important issues and trends affecting audit committee members.

It’s probable that someone you know is deep in debt. If you are observant, you might see one of these seven signs.