Microsoft Excel
PivotTable Reports

Half-Day Rapid Training in Vancouver

Rapid Computer Training runs this course as a scheduled public course. This course is based on Excel 2019/ 2016/ 2013/2010 versions. It is offered at 325 Howe St. in downtown Vancouver and also at client locations with our mobile lab.

The PivotTable tool in Excel is widely used for creating complex reports from a large Excel data set. It is easy to use but has several hidden functionalities. It is capable of producing a variety of summaries useful for business decision making. This course will teach you several powerful features of PivotTable via hands-on exercises.

Quality training is delivered by Microsoft Certified Trainers and other qualified computer professionals. The entire course is hands-on with Excel exercises. Participants get the Excel work files designed for this course.

For on-site group training, we bring our mobile computer lab to your office. Please visit our On-site Training Page for more details.

Course Fee: $250+GST/HST per participant
Course Material: $35+GST/HST each
Course Duration: Half Day (2:00PM to 5:30PM)
Course Pace/Style: Medium to fast; hands-on, intensive
Class Location: 325 Howe St, Suite 608, Dntn Vancouver
Course Schedule: Please click here Course Schedule

Prerequisite:
Skills learned in our Excel Level-1 & Level-2 courses or equivalent everyday work experience of using MS Excel. Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.

Course Outline:
  • What is a PivotTable Report?
  • Preparing Data for a PivotTable Report
  • Creating My First PivotTable Report
  • Formatting Values & Fields
  • Drilling Down to View Details
  • Filtering to View a Specific Summary
  • Using Slicers to Apply the Filters
  • Pivoting Fields for Different Emphasis
  • Summarizing Values by Different Functions
  • Using a Field Multiple Times
  • Refreshing the PivotTable Report
  • Grouping Text, Numeric & Dates
  • Working with Dates & Timeline
  • Displaying Single & Multiple Subtotals
  • Working with a Calculated Field
  • Working with a Calculated Item
  • Calculating % of Column & Parent Total
  • Ranking Largest to Smallest
  • Calculating Running Totals
  • Calculations with GETPIVOTDATA Function
  • Calculated Fields and Excel Functions
  • Converting a PivotTable to Regular Excel Data
  • Working with a PivotChart
  • Formatting a PivotTable Report
  • Showing Report Filter Pages

Courses can be customized to suit your training needs. Please send us a detailed email. We would be happy to provide you with the most cost effective solution.

Checkout More Course Outlines


Rapid Computer Training, Inc.
Email: info@rapidtraining.ca
2005, Rapid Computer Training, Inc.

Training      For             All