CMPT 1131: Excel Level 2
Effective date
September 2020
School
Continuing Studies
Description
Learn how to enhance worksheets with charts for visual appeal. In this course, you will create and explore charts, shapes, and sparklines. You will also learn to analyze and organize data, create and modify tables, and manage data-sets using built-in table functions.
You will learn through live demonstrations while interacting with a subject matter expert.
Year of study
General Interest
Prerequisites
Excel Level 1 (CMPT 1129), or equivalent knowledge/experience in using Excel.
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Create & modify charts
- Draw, move, resize and format shapes
- Insert and edit images using WordArt, clip art, pictures, and SmartArts
- Sort data and use the AutoFilter feature to find specific data
- Create, modify and delete range names, hyperlinks and comments
- Import and export data with other programs
- Customize chart elements
- Create and modify a table
- Use dynamic charts
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 7
Total Hours: 7
Grading System
Satisfactory/Unsatisfactory
Passing grade
'S' based on minimum 80% attendance
Course topics
- Charts
Sparklines
Trendlines
Graphics
Sort, Filter Data
Workbook sharing
Tables
Notes:
- Course contents and descriptions, offerings and schedules are subject to change without notice.
- Students are required to follow all College policies including ones that govern their educational experience at VCC. Policies are available on the VCC website at:
https://www.vcc.ca/about/governance--policies/policies/.
- To find out if there are existing transfer agreements for this course, visit the BC Transfer Guide at https://www.bctransferguide.ca.