Number Crunching with Excel Pivot Tables

Register Now →

Course Details

Pivot tables are the perfect solution when summarizing and analyzing large amounts of data. You can access a whole new information set in just a few clicks. Pivot tables extract meaning from that endless jumble of numbers on your screen allowing you to group your data differently, drawing helpful conclusions more quickly. If you work with large amounts of data in Excel, you need to know Pivot Tables to work more efficiently.  

Prerequisites: This course requires that you are familiar with Excel. You should have successfully completed Excel I and II or used the software for over six months.

Program Level: Advanced

Contents:

• PivotTable Fundamentals
• Creating a Basic Pivot Table
• Introduce Slicers and other New Pivot Table Tools
• Customize the Pivot Table View
• Layout Changes
• Changing Summary Calculations
• Using Running Totals, % Of, and Rank Options
• Grouping, Sorting, and Filtering Pivot Tables
• Calculations within Pivot Tables
• Calculated Fields and Calculated items
• Using Pivot Charts
• Advanced Pivot Table Tips & Techniques
• Solutions to Common Pivot Table Problems

Note: This course will be taught using the windows operating system environment

Ready to Advance Your Career?

Join professionals across the Carolinas who trust Catapult for professional development.

Register Now →