Search

MICROSOFT EXCEL

Instructors

  • Rachelle Chamberlin :: BS, Western Governors University; Multiple computer industry certifications including MS Office 2007 & 2010; experienced MS Office and computer fundamentals teacher
  • L. Bea Daggy :: AS, Computer Information Technology, Ivy Tech State College, Over ten years experience in computer field, experienced computer instructor

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

Instructor :: L. Bea Daggy
6 hours :: 0.6 CEU
$129


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 :: L. Bea Daggy
6 hours :: 0.6 CEU
$129


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 :: L. Bea Daggy
6 hours :: 0.6 CEU
$129

MC-4D-4607A  
2 Thurs. :: Dec. 4 & 11 :: 5:30-8:30 p.m.
South Bend     [online registration]


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 :: L. Bea Daggy
6 hours :: 0.6 CEU
$129