PivotTables are the most powerful feature of Excel, yet few users use them in their day-to-day activities. For some, PivotTables are too intimidating; for others, PivotTables are a foreign concept. With a little information, guidance, and demonstration from the instructor, you will be ready to begin using PivotTables to accomplish routine analysis and reporting. This webinar will begin with basic PivotTables and progress to advanced PivotTable topics.
Major Topics
- Drag-and-drop pivoting, group and ungrouping, and drilling down to underlying details
- Creating PivotTables from multiple ranges
- Linking PivotTables to external database and financial accounting systems
Learning Objectives
Upon completing this course, you should be able to:
- Identify and define the six main elements of a PivotTable report
- Create PivotTables that summarize large volumes of data
- Describe how to import the data from an accounting system and prepare the data to be used in the PivotTable
- Create PivotTables from Multiple Consolidation Ranges
How to Register for this Webinar:
- If you do not yet have a CITT account, click here to create an account. If you already have an account, you'll need to be logged in. If you aren't already logged in, please use the "Sign In" fields to the right. If you've forgotten your login information, you can click here to retrieve your username or reset your password here.
- Once you're logged in, click on the green Register Myself button
- Click the green Proceed to Checkout button
If you need any help registering, please contact Marysa at mmackinnon@citt.ca.