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 classes||Apr. 21-22||9 a.m.- 4 p.m.||Sat.,Sun.|