Spreadsheets - Microsoft Excel

E-mail: cetech@mtroyal.ca
Information: 403.440.6929
Register: Start here
Location: Lincoln Park Campus, 4825 Mount Royal Gate SW

MS Excel, Level 1
In this IC3 preparation course, discover spreadsheets and create, edit, save and print in Excel. Enter information, freeze and split panes, and move within/between worksheets. Practise entering data, creating formulas, formatting, using references, cut/copy/paste and AutoFill. Creating/editing charts and using Excel as a database are also introduced. Skills covered are transferable to all versions of MS Excel. This course, along with MS Word Level 1 and MS PowerPoint Level 1, prepares you to write the IC3 Key Applications Assessment.
Course materials: approx. $28+GST at the BookStore. Optional Key Applications manual is also used in MS Word Level 1 and MS PowerPoint Level 1.
Note: We strongly recommend familiarity with Windows file management before registering in this course.

Subject code: XCSS 10001

12 Hours. Fee: $239

CRN 30430	2 classes	April 6-7	9 a.m.-4 p.m.	Tue., Wed.
CRN 50078	2 classes	May 25-26	9 a.m.-4 p.m.	Tue., Wed.
CRN 50116	2 classes	June 14-15	9 a.m.-4 p.m.	Mon., Tue.

MS Excel, Level 2
Explore a variety of Excel's built-in functions (mathematical, statistical, financial, logical, date and time, text, lookup and reference, information.) Saving worksheets as HTML, subtotals, customizing toolbars, custom formatting, modifying and enhancing charts, drawing objects and protecting worksheets are also covered. Skills are transferable to all versions of MS Excel.
Course materials: approx. $24+GST at the BookStore
Note: We strongly recommend completion of MS Excel, Level 1 or equivalent before registering in this course.

Subject code: XCSS 10003

12 Hours. Fee: $239

CRN 30937	2 classes	April 12-13	9 a.m.-4 p.m.	Mon., Tue
CRN 50080	2 classes	May 31-June 1	9 a.m.-4 p.m.	Mon., Tue.
CRN 50268	2 classes	June 21-22	9 a.m.-4 p.m.	Mon., Tue.

MS Excel, Level 3
Explore the creation of templates and sharing of workbooks. Link workbooks, create data maps, use database functions and create pivot tables. Analysis tools including goal seek, solver, scenarios and auditing a worksheet, as well as macros and importing/exporting data, are covered. Skills are transferable to all versions of MS Excel.
Course materials: approx. $22+GST at the BookStore
Note: We strongly recommend completion of MS Excel, Level 2 or equivalent before registering in this course.

Subject code: XCSS 10004

12 Hours. Fee: $265

CRN 30227	2 classes	March 20-21	9 a.m.-4 p.m.	Sat., Sun.
CRN 30938	2 classes	April 14-15	9 a.m.-4 p.m.	Wed, Thu.
CRN 50117	2 classes	June 28-29	9 a.m.-4 p.m.	Mon., Tue.