Microsoft Excel Data Analysis with Pivot Tables
Time & Location
Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses
About the Course
Microsoft® Excel’s advanced Pivot features will create Pivot Tables and Charts. Pivot Tables and Pivot Charts are tools you can use to analyze and summarize raw data.
COURSE CONTENT
PREPARING DATA AND CREATING PIVOT TABLES
• Prepare Data
• Create a Pivot Table from a Local Data Source
• Create a Pivot Table from Multiple Local Data Sources
• Create a Pivot Table from an External Data Source
ANALYZING DATA USING PIVOT TABLES
• Summarize Pivot Table Data
• Organize Pivot Table Data
• Filter Pivot Table Data
• Format a Pivot Table
• Refresh and Change Pivot Table Data
WORKING WITH PIVOT CHARTS
• Create a Pivot Chart
• Manipulate Pivot Chart Data
• Format a Pivot Chart
Register
Price
Quantity
Total
- 4 or more Course Participants$299+$38.87 HST$299+$38.87 HST0$0
- 2 - 3 Course Participants$399+$51.87 HST$399+$51.87 HST0$0
- Course Calendar Date Pricing$299+$38.87 HST$299+$38.87 HST0$0
- 1 on 1 Training$499+$64.87 HST$499+$64.87 HST0$0
Total$0