Learn to use advanced features of Excel when working with different types of reports and data. You will explore increasing data entry efficiency with productivity tools, collaborating with others, using what-if scenarios, data validation rules, goal seeking, data groups, sub-totaling, solver tool, creating PivotTables, PivotCharts, and basic macros.
You will learn through live demonstrations while interacting with a subject matter expert.
Prerequisites
Excel Level 2 (CMPT 1131), or equivalent knowledge/experience in using Excel.
Missing prerequisites?
Learn more about VCC's academic upgrading or English as a Second Language (ESL) courses, or discover which university transfer options are right for you.
What you will learn
- Charts, Sparklines, Trendlines
Advanced Functions - Math and Trigonometric, Logical, Financial, Date and Time, Text
Data Types
Workbook Protection
What-If Analysis
Goal Seek
Solver
Scenarios
PivotTables
Data Slicer
Macros
Form Controls
Data Validation
Advanced Excel Options
How to register
This course is offered as part of a VCC program only.
Course schedules
Select your program to see the available course schedules.
Contact us
If you have any question, please email at advising@vcc.ca.
† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.