Skip to Navigation.
Skip to Search.
Skip to Content.
Switch to Default Layout

Professional Development and Lifelong Learning

Background Image

MICROSOFT EXCEL

Instructors

Catherine Dilley: BGS, Indiana University; instructor, IU South Bend Extended Learning Services

Michele Kulp: MBA, Indiana Tech; corporate account manager, Thor Industries

Mastering Microsoft Excel Certificate

Become proficient with Microsoft Excel, the premier spreadsheet program, and gain further control over your data.

Required Courses:

  • Getting Started with Excel—Level 1
  • Moving Ahead with Excel—Level 2
  • Organizing and Analyzing Data Using Excel—Level 3
  • Controlling and Customizing Excel—Level 3
  • Organizing Computer Files
  • Final Project

Important Information:

  • Total CEUs required for certificate: 4.0
  • A one-time, non-refundable $25 registration fee is required
  • Call 574-520-4261 for more information.

Getting Started with Excel (Level 1)

Create, edit, format, and print worksheets. Create formulas and use functions. Move and copy cell data and formulas. Use AutoFill. Create basic charts.

Note: You may take a test to earn CEUs for Getting Started With Excel. Test fee required. Call 574-520-4261 for details.

Prerequisite: Computers 101 or prior experience

6 hours; 0.6 CEU
$182

MC-2X-4601E
Instructor: Catherine Dilley
Mon./Thurs., June 8 & 11; 5:30-8:30 p.m.
AI001E, Management Training Center

MC-3Y-4601A
Instructor: Catherine Dilley
Thurs., Aug. 13; 9 a.m.-4 p.m.
AI001E, Management Training Center

MC-4Y-4601A
Instructor: Michele Kulp
Tues./Thurs., Oct. 20 & 22; 6-9 p.m.
AI001E, Management Training Center [Register Now]

MC-4Y-4601B
Instructor: Catherine Dilley
2 Tues., Nov. 10 & 17; 5:30-8:30 p.m.
Elkhart Center A205 [Register Now]

Moving Ahead with Excel (Level 2)

Use “IF” and other functions. Add formatting, shading, fonts, borders, headers/footers, page numbers, and print titles. Insert, copy, and delete spreadsheet tabs. Link spreadsheets and workbooks.

Prerequisite: Getting Started with Excel or prior experience. Call 574-520-4261 to request permission to waive the prerequisite class.

Instructor: Catherine Dilley
6 hours; 0.6 CEU
$182

MC-2X-4602A
Wed., June 24; 9 a.m.-4 p.m.
AI001E, Administration Building

MC-4Y-4602A
Fri., Sept. 18; 9 a.m.-4 p.m.
AI001E, Management Training Center [Register Now]

MC-4Y-4602B
Wed., Nov. 18; 9 a.m.-4 p.m.
AI001E, Management Training Center [Register Now]

MC-4Y-4602C
Mon., Dec. 7; 9 a.m.-4 p.m.
Elkhart Center A205 [Register Now]

Controlling and Customizing Excel (Level 3)

Create toolbars and set Excel options. Validate and restrict cell entries. Protect worksheets. Create templates, range names, and macros. Find and replace data and formats. Create a shared workbook and track changes.

Instructor: Catherine Dilley
6 hours; 0.6 CEU
$182

MC-2X-4607A
Fri., July 24, 9 a.m.-4 p.m. NEW DATE/LOCATION
AI001E, Management Training Center

MC-4Y-4607A
Wed., Sept. 30; 9 a.m.-4 p.m.
AI001E, Management Training Center [Register Now]

MC-4Y-4607B
2 Wed., Dec. 2 & 9; 5:30-8:30 p.m.
AI001E, Management Training Center [Register Now]

Organizing and Analyzing Data Using Excel (Level 3)

Work with Excel as a database and add appropriate functions. Sort and select data. Use lookup functions. Implement scenarios and data tables. Create Pivot Tables and charts. Incorporate outlines and conditional formatting.

Prerequisite: Moving Ahead with Excel or equivalent experience. Call 574-520-4261 to request permission to waive prerequisite class.

Instructor: Catherine Dilley
6 hours; 0.6 CEU
$182

MC-2X-4608A
Fri., June 26; 9 a.m.-4 p.m.
Elkhart Center A205

MC-4Y-4608A
Thurs., Oct. 1; 9 a.m.-4 p.m.
AI001E, Management Training Center [Register Now]

MC-4Y-4608B
Thurs., Dec. 10; 9 a.m.-4 p.m.
AI001E, Management Training Center [Register Now]