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.
Course code: CMPT 1132
Credits: 0.0
Tuition: $0*
Length: 7.0 hours
Course outline:
view
https://www.vcc.ca/vccphp/courseoutline?subject=CMPT&number=1132
Prerequisites
Excel Level 2 (CMPT 1131), or equivalent knowledge/experience in using Excel.
0
Additional Information
- 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 do I apply for this course?
This course is offered as part of a VCC program only.
* Fees are approximate and subject to change. Students are required to pay any applicable fee increases. Fees listed are for domestic students. For international programs, visit VCC International.
† 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.
Facebook
Twitter
Instagram
YouTube
Flickr
RSS
More accounts