This advanced level course covers Pivot Tables and data analysis features such as Scenario ManagerConsolidate. We also cover Macros and Customizing Excel.
Participants will learn how to:
Assessment Methods: Lab exercise completed after each module to reinforce the topics covered in the module. Q&A throughout the course. Course evaluation completed after the course.
Delivery Method: Classroom
Course Duration: Full day
Training Hours: 6 hours
Total Cost of Program: $285/per person plus GST
Course Capacity: Maximum 16 participants
Instructor Bio: John Chandler
John Chandler specializes in delivering Microsoft Office computer training courses in Vancouver and throughout B.C.
He is a seasoned software instructor with broad-based business skills developed during more than five years as a management consultant. He has over 26 years’ experience teaching adults how to use computers. He is comfortable working with people at all levels in an organization, including senior management, and has demonstrated skills working with users at all levels of computer literacy.
John is a results-oriented team player with excellent interpersonal and presentation skills, and proven abilities teaching all levels of computer software from introductory to advanced.
He holds the Certified Management Consultant designation and is a current member of the Canadian Association of Management Consultants. The CMC designation is granted to individuals who have demonstrated their knowledge of management, and their capacity to consult, according to international standards of practice and ethics. It is earned through a combination of university education, experience, peer review, study & examination.
John is a member of the Vancouver Executives Association and is the President of the association this year.
This introductory level course will provide participants with a solid foundation in the basics of using Microsoft Excel.
Excel Level 1
This intermediate level course covers useful Excel features such as Named Ranges, Functions and Sort & Filter.
Excel Level 2
This advanced level course covers Pivot Tables and data analysis features such as Scenario Manager...
Excel Level 3
His teaching style is engaging.
"John Chandler is very knowledgeable in Excel. His teaching style is engaging and he makes it very easy to follow and understand. I’d recommend his training to anyone looking to brush up on their Excel knowledge."