 |
|
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
|
|
Microsoft Excel Classes - Spring 2008
Excel
- Level 1
Excel - Level 2
Transition to Excel 2007
Organizing and Analyzing Data Using Excel
Controlling and Customizing Excel
Using Visual Basic with Excel
Back to Computer Class Listing
|
|
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, see Computers 101.
2.5 hours/.25 CEU.
$59 (includes materials and parking; no discount) |
|
|
1W-4811A: |
Wed., Feb. 13, 9 - 11 a.m.
Room: AI001E, CE Computer Lab |
|
|
1W-4811B:
|
Sorry, this class is no longer available.
Click here for summer/fall classes
Tues., May 6, 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. |
|
1W-4601A:
|
Friday, Feb. 22,
9 a.m. - 4
p.m. |
Click
here to Enroll Online |
|
ELKHART |
Site: IU South Bend Elkhart Center, A205 |
|
1W-4601B: |
Sorry, this class is no
longer available. See section C below
Mon. & Thurs., Mar. 24 & 27, 5:30-8:30 p.m. |
Click
here to Enroll Online |
|
|
Room: AI001E, CE Computer Lab |
|
1W-4601C: |
Wednesday, Apr. 30, 9 a.m. - 4
p.m. |
Click
here to Enroll Online |
|
|
Room: AI001E, CE Computer Lab |
|
|
Hours: 6 hours/.6 CEU
Instructors: Catherine Dilley, B.G.S., Indiana University;
personal computer manager and instructor, IU South Bend, Michelle
Kulp, B.S., Indiana University, president Kulp-Horvath, Inc.
accounting firm; and Gary Winey, B.S., Grace College; programmer,
Valmont Industries, Inc., experienced applications developer.
$175
(includes materials and parking)
To receive a 10% Early Bird Enrollment Discount, payment must be
received by 5 p.m. on January 28. |
|
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. |
|
1W-4602A:
|
Friday, Feb. 29, 9 a.m. - 4 p.m.
|
Click
here to Enroll Online |
|
ELKHART |
Site: IU South Bend Elkhart Center, A205 |
|
1W-4602B:
|
Sorry, this class is no longer
available. See section C below
Mon. & Thurs., Mar. 31 &
Apr. 3,
5:30 - 8:30 p.m. |
Click
here to Enroll Online |
|
|
Room: AI001E, CE Computer Lab |
|
1W-4602C:
|
Wednesday, May 7, 9 a.m. - 4
p.m.
Room: AI001E, CE Computer Lab |
Click
here to Enroll Online |
|
|
Hours: 6 hours/.6 CEU
Instructors: Catherine Dilley, Michelle Kulp and Gary
Winey, See Getting Started with Excel
$175
(includes materials and parking)
To receive a 10% Early Bird Enrollment Discount, payment must be
received by 5 p.m. on January 28. |
|
Level 3
Organizing and Analyzing Data Using
Excel
Use Excel features to allow you more efficient data
organization and analysis.
|
|
|
TOPICS:
• Place data into a database that you can sort
and select
• 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-4168 to request permission to skip
this class. |
|
1W-4608A:
ELKHART |
Friday, March 7, 9 a.m. - 4
p.m.,
Site: IU South Bend Elkhart Center, A205 |
Click
here to Enroll Online |
|
1W-4608B:
|
Wednesday, May 14, 9 a.m. - 4 p.m.
Room: AI001E, CE Computer Lab
6 hours/.6 CEU
Instructor: Dilley,
See Getting Started with Excel
$175 (includes materials and parking)
|
Click
here to Enroll Online |
|
|
To receive a 10% Early Bird Enrollment Discount, payment must be
received by 5 p.m. on January 28. |
|
Level 3
Controlling and Customizing
Excel
TOPICS:
•
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 work book and track
changes
Prerequisite:
Moving
Ahead with Excel
or equivalent
experience. Call 574-520-4168 to request permission to skip this class.
|
|
1W-4607A:
|
Wednesday, May 21, 9 a.m.
- 4 p.m,
6 hours/.6 CEU
Room: AI001E, CE Computer Lab.
Instructor: Dilley,
See Getting Started with Excel
$175 (includes materials and parking |
Click
here to Enroll Online |
|
|
To receive a 10% Early Bird Enrollment Discount, payment must be
received by 5 p.m. on January 28. |
|
Level 4
Using Visual Basic with
Excel
TOPICS
• Edit macros
• Work with objects, controls, properties,
methods, events, functions and procedures
• Create a user interface with input and message
boxes
• Use If statements to execute or discontinue
calculations
• Run calculations on a range of cells using VBA
looping statements
Prerequisite:
Any Level 3 Excel
class or equivalent experience. Call 574-520-4168 to request permission
to skip this class. |
|
1W-4607A:
|
Not currently scheduled
Call 574-520-4261 to put your
name on an interest list.
6 hours/.6 CEU,
Room: AI001E, CE Computer Lab.
Instructor: TBA
|
|