Microsoft Excel
LOOKUP Functions and
PivotTable Reports

Hands-on Intensive Course
Offered in Vancouver

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

Lookup Functions in Excel such as VLOOKUP, INDEX and MATCH are very powerful. They save you enormous time, labour and provide a great deal of accuracy and automation. Many office workers find these functions a bit tricky to use. This course is designed for persons who would like to get a good grip on these functions. A variety of examples and hands-on exercises will make you understand these functions easily.

The other half of the course covers PivotTables widely used for creating complex reports from Excel data set. The PivotTable tool is easy to use but has several hidden functionalities. This course will show 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: $350+HST/GST per participant
Course Material: $35+HST/GST
Course Duration: One Day (9:00AM to about 5:00PM)
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:
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:
  • VLOOKUP- definition & general considerations
  • When to use the Exact and Approximate Match options
  • VLOOKUP with a Range Name
  • Doing VLOOKUP from a different worksheet
  • Doing VLOOKUP from a different workbook
  • Doing VLOOKUP with wild card characters and "&"
  • Doing VLOOKUP with a nested MAX function
  • Doing VLOOKUP with multiple criteria
  • Doing 2-dimensional VLOOKUP with MATCH
  • Using VLOOKUP to compare data
  • INDEX- definition & general considerations
  • MATCH- definition & general considerations
  • INDEX and MATCH combo
  • Building a PivotTable
  • How to create a PivotTable based on external data
  • How to categorize PivotTable Data
  • How to customize a PivotTable
  • Analyzing data using PivotTables
  • Creating custom calculations in a PivotTable
  • Restructuring a PivotTable
  • Presenting PivotTable data visually
  • Formatting a PivotTable
  • Presenting a PivotTable in a PivotChart

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