One basic skill that is becoming increasingly important for
all workers to know is spreadsheet functions.

- Skill Pathways for Your Future, Indiana Career Guide 2007 

Transition to Excel 2007
Having trouble finding your familiar commands in the new Excel 2007? We can help in this hands-on class. Understand the new Ribbon Bar and command buttons. Put back the toolbar buttons you love. See the changes in Excel features such as formula writing, pivot tables, lists and charts.

Note: Class designed for experienced Excel users. New users see Getting Started with Excel.
Instructor: Catherine Dilley, B.G.S., Indiana University; personal computer manager and instructor, IU South Bend
2.5 hours/.25 CEU.
$59 (includes materials and parking; no discount)

1W-4811B:
ELKHART

Sorry, this class is no longer available.
See Section 4811C on 6/5
Tuesday, May 6, 9 - 11 a.m.
Room: AI001E, CE Computer Lab

2W-4811C:
ELKHART

Sorry, this class is no longer available.
Thursday, June 5, 9 - 11 a.m.
Room: AI001E, CE Computer Lab

3X-4811D:

Sorry, this class is no longer available.
Tuesday, August 5, 9 - 11 a.m.
Room: AI001E, CE Computer Lab

4X-4811E:
ELKHART

Friday October 3, 9 - 11 a.m.
Site: IU South Bend Elkhart Center, A205

Level 1
Getting Started With Excel

Gain fast access to numeric data and periodic reports through this hands-on workshop. Learn the concepts and commands needed for Excel spreadsheets

TOPICS:
• Open, create, format, save, print and close worksheets
• Create formulas and use Excel’s built-in worksheet functions
• Use the toolbar, dialog boxes and shortcut menus
• Move and copy cell data and formulas
• Use AutoFill to create or copy cell data
• Create basic charts

Prerequisite: Computers 101 or prior experience.
Notes: You may take a test to earn CEUs for Getting Started With Excel. Test fee required. Call 574-520-4261 for details.

2W-4601A:

ELKHART

3X-4601B:

Click here to Enroll Online

3X-4601C:

Click here to Enroll Online

4X-4601D:

4X-4601E:

ELKHART

Hours: 6 hours/.6 CEU

Instructors: Catherine Dilley, B.G.S., Indiana University; personal computer manager and instructor, IU South Bend ; and Gary Winey, B.S., Grace College; programmer, Valmont Industries, Inc., experienced applications developer.

$175  (includes materials and parking)

Early Bird Special: Enroll by May 15 to receive a 10% discount on classes that begin June, July and August
Enroll by August 15 to receive a 10% discount on classes that begin September through December
Classes marked "no discount" do not apply.

Level 2
Moving Ahead With Excel

Build on your Excel skills by learning, hands-on, ways to format your spreadsheets and work with your spreadsheet data.

TOPICS:
• Use "If" and other functions
• Customize charts
• Enhance your reports through formatting, shading, fonts and borders
• Incorporate headers/footers, page numbers and print titles
• Insert, copy and delete spread- sheet tabs
• Link spreadsheets and workbooks

Prerequisite: Getting Started with Excel - Level 1 or prior experience. Call 574-520-4261 to request permission to skip this class.

Tuesday,  June 17,  9 a.m. - 4 p.m.

Site: IU South Bend Elkhart Center, A205

Sorry this class no longer available.  Please see 4602C on 8/21
Tues. & Thurs., July 15 & 17, 5:30 - 8:30 p.m.

Room: AI001E, CE Computer Lab

3X-4602C:

4X-4602D:

4X-4602E:
ELKHART

Instructors: Catherine Dilley and Gary Winey, See Getting Started with Excel

$175  (includes materials and parking)

Early Bird Special: Enroll by May 15 to receive a 10% discount on classes that begin June, July and August
Enroll by August 15 to receive a 10% discount on classes that begin September through December
Classes marked "no discount" do not apply.

Level 3
Organizing and Analyzing Data Using Excel

Use Excel features to allow you more efficient data organization and analysis.

TOPICS:

•  Use Lookup and Reference functions (look up values in lists)
•  Implement scenarios to design a model and find target values with Solver
•  Create Pivot Tables and charts to consolidate and rearrange data for analysis
•  Add Summary, Subtotal, SumIF and CountIF functions
•  Incorporate outlines and conditional formatting

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

1W-4608B:

3X-4608C:

Sorry, this section no longer available.  Please see October section below.
Thursday, August 28, 9 a.m. - 4 p.m.,
Room: AI001E, CE Computer Lab

4X-4608D: ELKHART

Friday, October 31, 9 a.m. - 4 p.m.

Room: AI001E, CE Computer Lab

6 hours/.6 CEU

Instructor: Dilley, See Transition to Excel 2007

Click here to Enroll Online

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

$175 (includes materials and parking

Fall Class