Microsoft Excel
Managing Data & Pivot Table Course in Vancouver

Rapid Computer Training runs a scheduled Public Course: Microsoft Excel Data Management and Pivot Table. This course is based on Excel 2007 and 2010 versions. It is offered at 608-325 Howe St. in downtown Vancouver and also at client locations with our mobile lab.

This course is designed for participants who work with or going to work with analyzing, grouping, filtering and sorting large data in a spreadsheet (large number of rows). If you have a good working experience of Excel but find working with enormous data as a overwhelming task, this course is meant for you. Those who are new to Excel and wish to learn Excel, they should take our Excel Level-1 course first.

Quality training is delivered by Microsoft Certified Trainers and other qualified computer professionals. We use easy to follow, industry standard courseware for MS Office training.

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

Microsoft Excel 2007/2010
Managing Data and PivotTable
(Intermediate Level Course)

Course Fee- $325+HST/GST per participant
Course Manual- $30+HST/GST each
Course Duration- One Day (9:00AM to about 4:30PM)
Class Location- 608-325 Howe St, downtown Vancouver
Course Schedule- Please click here Course Schedule

Prerequisite:
Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required. Everyday work experience of Microsoft Excel or skills learnt in our Excel Level-1 course.

Course Outline:
  • Review of Excel Table Features
  • Modifying Table data, formats, removing duplicates
  • Inserting Total row and options
  • Sorting Table data using different methods
  • Filtering Table data using different methods
  • Using Advance Filtering methods
  • Creating single and multiple Subtotals with data outline
  • Using Excel Database summary functions
  • Inserting a PivotTable
  • Creating a PivotTable from an external data source
  • Categorizing PivotTable data
  • Customizing a PivotTable

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