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.
This course is designed for office users who work with or likely to work with extensive data stored in Excel. The course will give you tools to maintain a list data base,
massage and manipulate it to obtain desirable results. Get a good handle on advanced
sorting and filtering of data by taking this course. You should have a good working experience of Excel. Those who are totally new to Excel should take our Excel Level-1
or Level-2 course first.
Quality training is delivered by Microsoft Certified Trainers and other qualified computer professionals. The entire course is hands-on. Participants
receive custom designed exercise files and a printed course manual for practice
We can also deliver this course at your office with our mobile computer lab. 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
Skills learned in our Excel Level-1 or Level-2 course or equivalent everyday work experience of using MS Excel.
Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.
Excel as a List Database: Important considerations
Using Data Validation for accurate data
Using GO TO command effectively
Cleaning your database: TRIM & CLEAN
Fixing numbers stored as text
How to create and manage an Excel Table
Excel Tables: Structured References for formulas
Multi-Column Sort (vertical & horizontal)
Creating a Custom List
Using Custom Sort when a normal sort won't
Sorting by a partial value in a column
How to use the Advanced Filter with complex
Advanced Conditional Formatting for filtering
Using Excel Database Functions with complex
Working with nested SUBTOTALs
Working with visible cells only
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.
© 2005, Rapid Computer Training, Inc.