PRINT VERSION

Spreadsheets - Microsoft Excel

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

If the course description suggests that you have a solid understanding of Windows file management, try this Self Assessment of file management skills.

MS Excel, Level 1
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.
Course materials: approx. $37+GST at the BookStore.
Note: We strongly recommend a solid understanding of Windows file management before registering in this course.

Subject code: XCSS 10001

12 Hours. Fee: $239

CRN 30330	2 classes	March 14-15	9 a.m.-4 p.m.	Wed., Thu.
CRN 50068	2 classes	May 22-23	9 a.m.-4 p.m.	Tue., Wed.
CRN 50101	2 classes	June 13-14	9 a.m.-4 p.m.	Wed., Thu.

MS Excel, Level 2
Explore a variety of Excel’s built-in statistical and other functions. Creating, editing, and printing charts and graphics and also using a spreadsheet as a database to organize, sort and filter data are covered. In addition, use Sparklines, templates, tables and custom cell formats to visually present your data. Skills are transferable to most versions of MS Excel.
Course materials: approx. $37+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 30541	2 classes	March 26-27	9 a.m.-4 p.m.	Mon., Tue.
CRN 50070	2 classes	May 31-June 1	9 a.m.-4 p.m.	Thu., Fri.
CRN 50191	2 classes	June 25-26	9 a.m.-4 p.m.	Mon., Tue.

MS Excel, Level 3
Explore the creation of templates and sharing of workbooks including linking and pivot tables. Analysis tools including Goal Seek, Solver, Scenarios and auditing a worksheet, as well as macros and filtering data, are covered. Skills are transferable to all versions of MS Excel.
Course materials: approx. $69+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 30184	2 classes	March 28-29	9 a.m.-4 p.m.	Wed., Thu.
CRN 50102	2 classes	June 27-28	9 a.m.-4 p.m.	Wed., Thu.