Microsoft Excel Training
Available Classes
- Excel 2007 Level I Get Started
- Excel 2007 Level II Expand Your Skills
- Excel 2007 Advanced - Analysis, Validate and Audit Functions
- Excel 2010 Level I Get Started
- Excel 2010 Level II Expand Your Skills
- Excel 2010 Essentials
- Excel 2010 Pivot Tables
- Excel 2010 - Get A Good Grasp
- Excel 2010 Special Courses
Excel 2007 Get Started
Excel 2007 need not intimidate you! Begin here to learn the most widely used functions
in this popular spreadsheet software. Soon you’ll soon be creating and populating worksheets, working with formulas, analyzing numeric information, and enhancing formatting.
Certificate awarded upon completion.
Prerequisite: Introduction to Computer class or familiar with computer.
Bring USB drive to class.
Classes offered through:
Utica Schools Community Education
To register call 586 797-6900
Tuesday
June 19 to July 17, 2012 (No class July 3)
Ford High School
9:00 a.m.
to 12:00 (noon)
Registration: $139
Book fee: $35 payable by check to CAR Training at first class
Wednesday
June 20 to July 18, 2012 (No class July 4)
Eisenhower
6:30 to 9:30 p.m.
Registration: $139
Book fee: $35 payable by check to CAR Training at first class
Thursday
June 21 to July 12, 2012
Walsh
6:15 to 9:15 p.m.
Registration: $139
Book fee: $35 payable by check to CAR Training at first class
Excel 2007 Level II Expand Your Skills
Expand your Excel 2007 skills for career or personal needs. This Level II course covers linking, grouping and editing data, as well as accessing and manipulating multiple worksheets.
- Produce a database that easily tracks your information
- Use the filter and sort commands to find and organize data
- Create original charts
Prerequisite: Excel Basic Level I class or familiar with using Excel
Class offered through:
Utica Schools Community Education
To register call 586 797-6900
Thursday
April 12 to May 3, 2012
Stevenson High
6:30-9:30 p.m.
Registration: $129
Textbook fee: $35 payable by check to CAR Training at first class
Wednesday
July 25 to August 15, 2012
Eisenhower
6:30-9:30 p.m.
Registration: $139
Textbook fee: $25 payable by check to CAR Training at first class
Clarkston Community Schools
To register call: 248 623-4326
Wednesday
March 7 to March 28, 2012
Clarkston High School - Room A346
6:30-9:30 p.m.
Registration: $99 + $35 Textbook fee
Excel 2007 Advanced - Analysis, Validate & Audit Functions
Excel 2007 has so much to offer the advanced user. Build on your existing skills to make the software an integral part of your business-tracking tactics.
- Create pivot tables and macros
- Use the data analysis ToolPak
- Work with financial functions
- Find out how the V LOOKUP, IF, COUNTIFS, and SUMIF functions assist you
- Apply auditing functions to trace erros and evaluate formulas
- Create conditional formattimg rules
Bring USB drive to class.
Prerequisite: Very familiar with using Excel.
Class offered through:
Utica Schools Community Education
To register call 586 797-6900
Thursday
May 17 to June 7, 2012
Stevenson High
6:30-9:30 p.m.
Registration: $129
Book fee: $35 payable by check to CAR Training at first class
Monday
June 25 to July 30, 2012 (No class July 2)
Ford High
5:30-9:30 p.m.
Registration: $129
Book fee: $35 payable by check to CAR Training at first class
Clarkston Community Schools
To register call: 248 623-4326
Wednesday
April 11 to May 2, 2012
Clarkston High School - Room A346
6:30-9:30 p.m.
Registration: $99 + $35 Textbook fee
Excel 2010 — Get Started
The 2010 version of Excel is designed to be user-friendly. Start here to learn the
software’s most widely used functions. You’ll practice creating spreadsheets,
working with formulas, and analyzing numeric information. You’ll also discover
the many functions that save time – like AutoCorrect, AutoCalculate and
automatic formatting. Great tips help you track finances, people, and inventory.
Bring USB flash drive to class.
Certificate awarded upon completion.
Prerequisite: Introduction to Computer class or familiar with a computer.
Utica Schools Community Education
To register call 586 797-6900
West Bloomfield Schools Adult Career Development Program
To register call 248 539-2390
Wednesday
March 21 to April 18, 2012 (No class April 4)
West Bloomfield Adult Education
6:15-9:15 p.m.
Registration: $99 + $5 processing fee
Book fee: $35 payable by check to CAR Training at first class
L'Anse Creuse Community Education
To register call 586 783-6330
Wednesday
March 14 to April 18, 2012
MS South - Room 123
6:30 to 9:30 p.m.
Registration: $109
Book fee: $35 payable by check to CAR Training at first class
Excel 2010 - Essentials
Excel 2010 is an ideal resource for work or home. In this beginner’s class, you’ll become acquainted with
the software and its many functions. As your skills grow, you’ll create worksheets, populate cells with
data, produce charts and work with large and multipage spreadsheets. Then you’ll make your work
even easier by using templates!
Prerequisite: Familiar with computers. Bring USB drive to class.
Certificate awarded.
L'Anse Creuse Community Education
To register call 586 783-6330
Wednesday
April 25 to June 6, 2012
MS South - Room 124
6:30 to 9:30 p.m.
Registration: $179
Books (2) fee: $70 payable by check to CAR Training at first class
Oxford Parks & Recreation
To register call 248 628-1720
Wednesday
April 18 to May 30, 2012
Middle School
6:30-9:00 p.m.
Registration: $149
Books (2) fee: $58 payable by check to Car Training at first class
Excel 2010 Pivot Tables & Macros - Special Course
West Bloomfield Career Programs
To register call 248 539-2390
Excel 2010 Pivot Tables are an exciting new way to summarize, analyze and sort your data.
This class will show you how to create, arrange, and edit Pivot Tables. You’ll become
comfortable using AutoFilter and Slicers, making macros and using shortcut keys and custom
buttons.
Prerequisite: Excel Level 1 or similar experience.
Tuesday
May 8 to May 29, 2012
West Bloomfield Adult Ed
9:00-11:45 a.m.
Registration: $180
Textbook: $25
check payable to Car Training at first class
Monday
May 14 to June 11, 2012 (No class May 28)
West Bloomfield Adult Ed
6:15-9:00 p.m.
Registration: $180
Textbook: $25 check payable to Car Training at first class
Excel 2010 - Get A Good Grasp
Excel 2010 is designed to help you meet the demands of your job. Compile, sort, edit and analyze data
the easy way – with intuitive spreadsheets, tabs and formulas. This course will show you how
uncomplicated Excel can be. You’ll find the steps, tips and shortcuts for basic and advanced functions.
In no time you’ll be comfortable with insert-cell reference, absolute cell reference, point mode and more.
Prerequisite: Familiar with computers.
Certificate awarded.
Oxford Parks & Rec
To register call 248 628-1720
Wednesday
April 18 to May 30, 2012
Middle School
6:30-9:00 p.m.
Registration: $149
Textbook: $70
check payable to Car Training at first class
Excel 2010 Level I - Special Course
Enhance your skill on Excel 2010 and discover plenty of timesaving techniques with this
special course. You’ll practice the same tasks you’d use at your job: building worksheets,
formatting numbers, populating cells, integrating formulas. and Discover how to build
and navigate worksheets. Format numbers, formulas and cells. Then see how AutoFill,
AutoSum, AutoComplete save you time.
Certificate awarded.
Classes offered through:
West Bloomfield Schools Adult Career Development Program
To register call 248 539-2390
Thursday
April 26 to May 17, 2012
West Bloomfield Adult Education
9:00-11:45 a.m.
Registration: $180
Book fee: $25 payable by check to CAR Training at first class
Wednesday
May 2 to May 23, 2012
West Bloomfield Adult Education
6:15-9:00 p.m.
Registration: $180
Book fee: $25 payable by check to CAR Training at first class.
Prerequisite: Computer experience.
Excel 2010 Level II- Special Course
If your job demands a higher level of spreadsheet skill, Excel 2010 delivers! This course gives
you the know-how to work with flexible views, headers and footers, 3D cell references and other
advanced functions. Use Lookup, IF, SUMIF and syntax functions, handle tracking and auditing
tools, learn naming rules for cells and much more.
Prerequisite: Excel Level I or similar experience.
Certificate awarded.
Classes offered through:
West Bloomfield Schools Adult Career Development Program
To register call 248 539-2390
Thursday
May 31 to June 21, 2012
West Bloomfield Adult Education
9:00-11:45 a.m.
Registration: $180
Book fee: $25 payable by check to CAR Training at first class
Wednesday
June 6 to June 27, 2012
West Bloomfield Adult Education
6:15-9:00 p.m.
Registration: $180
Book fee: $25 payable by check to CAR Training at first class.
Prerequisite: Excel Level I or similiar experience.