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.

4X-4601E:

ELKHART

Hours: 6 hours/.6 CEU

Instructor: Catherine Dilley, B.G.S., Indiana University; personal computer manager and instructor, IU South Bend.

$175  (includes materials and parking)

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.
 

4X-4602E:
ELKHART

$175  (includes materials and parking)

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.

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

Level 3
Controlling and Customizing Excel

4X-4607A