MS Excel

MS Excel Certificate of Completion

Discover what the Microsoft electronic spreadsheet program Excel can do for you!  Explore the variety of Excel's built in functions including mathematical, statistical, financial date & time, text, logical, and look up functions.

  • Practice entering data, creating formulas, formatting, using references, cut/copy/paste and AutoFill
  •  Advanced application to the Excel program
  •  Prepare to rejoin the workforce by stating your proficiency in MS Excel
  • Complete the 3 required courses (36 hours)
  • You may take individual courses without earning the certificate
  • Can be completed within 1 semester up to a maximum of 2 years

MS Excel, Level 1

Discover the basics of an electronic spreadsheet. Learn correct terminology, mouse and keyboard movements and be introduced to the MS Excel environment. Learn how to enter data and apply formatting through a variety of methods. Perform calculations by creating formulas and using simple functions.
Recommended: Windows file management skills

Subject code: XCSS 10001 12 Hours. Fee: $279 Choose 1 of the CRNs below
CRN 30055
2 classes Feb. 12 - 13 9 a.m. - 4 p.m. Mon., Tues.
CRN 30056
2 classes March 3 - 4 9 a.m. - 4 p.m. Sat., Sun.

MS Excel, Level 2

Explore a variety of Excel’s built-in specialized functions beyond a Level 1 class learn multiple ways of using a spreadsheet as a database (list) to organize, sort and filter data. Learn how to use database functions and learn how to create pivot tables, pivot charts, slicers, and timelines.
Recommended: MS Excel, Level 1 or equivalent
Course materials: Approx $45 at the BookStore

Subject code: XCSS 10003 12 Hours. Fee: $279 Choose 1 of the CRNs below
CRN 30057
2 classes Feb. 26 - 27 9 a.m. - 4 p.m. Mon., Tue.
CRN 30058
2 classes March 10-11 9 a.m. - 4 p.m. Sat., Sun.

MS Excel, Level 3

Excel Level 3 covers the creation of chart templates and sharing of workbooks. In addition, learn how to link workbooks. Learn how to customize charts, save them as templates and use Sparklines. Analysis tools including goal seek, solver, scenarios and auditing a worksheet as well as macros and lookup functions. 
Recommended: MS Excel Level 2 or equivalent

Subject code: XCSS 10004 12 Hours. Fee: $279  
CRN 30070
2 classesApr. 21-229 a.m.- 4 p.m.Sat.,Sun.

 

Contact us

For information about this program:
cebusiness@mtroyal.ca
403.440.6861 or 1.888.392.3655
4825 Mount Royal Gate SW, Calgary AB T3E 6K6

Customize this program for your organization through our Corporate Training department.

CE Logo - Facebook    CE Logo - Twitter   CE Logo - LinkedIn   CE Logo - Wordpress Blog    CE Logo - YouTube   CE Icon - Email