

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 30192 | 2 classes | Feb. 11-12 | 9 a.m.-4 p.m. | Sat., Sun. |
| CRN 30157 | 2 classes | Feb. 21-22 | 9 a.m.-4 p.m. | Tue., Wed. |
| CRN 30330 | 2 classes | March 14-15 | 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 30159 | 2 classes | March 1-2 | 9 a.m.-4 p.m. | Thu., Fri. |
| CRN 30193 | 2 classes | March 3-4 | 9 a.m.-4 p.m. | Sat., Sun. |
| CRN 30541 | 2 classes | March 26-27 | 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. |
Back to Top