Microsoft Excel - Introduction
|
| Course Outline |
Register |
| Cost: |
$225 |
| Duration: |
1 Day |
| Time: |
8:30 AM to 4:30 PM |
| Continuing Ed Units |
.7 |
| Prerequisite: |
Basic computer skills |
| Summary: |
|
| Topics include entering
and editing data, creating and editing formulas and functions, using AutoSum,
using Insert Function, cut,
copy, paste, using AutoFill, formatting cells for value, date, text,
alignment, borders, shading, setting print areas, using
headers, footers, page setup, and creating charts and graphs. |
 |
2010
|
|
| Tuesday |
1/5 |
| Thursday |
2/4 |
| Wednesday |
3/3 |
| Thursday |
4/1 |
| Wednesday |
5/5 |
| Tuesday |
6/1 |
| Wednesday |
7/7 |
| Thursday |
8/5 |
| Wednesday |
9/1 |
| Friday |
10/1 |
| Tuesday |
11/2 |
| Wednesday |
12/1 |
|
Microsoft Excel - Intermediate
|
|
Course Outline |
Register |
| Cost: |
$225 |
| Duration: |
1 Day |
| Time: |
8:30 AM to 4:30 PM |
| Continuing Ed Units |
.7 |
| Prerequisite: |
Microsoft Excel Introduction |
| Summary: |
|
| Topics include creating
custom templates, using styles, linking formulas, using AutoFill,
using 3-D references, using absolute references, using named ranges,
filtering, sorting, hyperlinks, and using graphic objects in sheets. |
|
|
2009
|
|
| Friday |
12/7 |
|
|
2010
|
|
| Friday |
1/15 |
| Thursday |
2/11 |
| Thursday |
3/11 |
| Wednesday |
4/14 |
| Friday |
5/14 |
| Monday |
6/7 |
| Thursday |
7/8 |
| Tuesday |
8/10 |
| Friday |
9/17 |
| Thursday |
10/7 |
| Monday |
11/15 |
| Friday |
12/10 |
|
Microsoft Excel - Advanced
|
|
Course Outline |
Register |
| Cost: |
$450 |
| Duration: |
2 Days |
| Time: |
8:30 AM to 4:30 PM |
| Continuing Ed Units |
1.4 |
| Prerequisite: |
Microsoft Excel Intermediate |
| Summary: |
|
| Topics include advanced
functions, recording macros, linking workbooks, linking to other
Office applications, data validation, data analysis using queries,
Pivot tables, conditional formatting, comments, change tracking,
sharing and merging workbooks, creating custom user forms and
auditing tools. |
|
|
2010
|
|
| Thursday-Friday |
1/28-1/29 |
| Thursday-Friday |
2/25-2/26 |
| Monday-Tuesday |
3/15-3/16 |
| Wednesday-Thursday |
4/21-4/22 |
| Monday-Tuesday |
5/17-5/18 |
| Monday-Tuesday |
6/14-6/15 |
| Monday-Tuesday |
7/19-7/20 |
| Thursday-Friday |
9/23-9/24 |
| Tuesday-Wednesday |
10/19-10/20 |
| Monday-Tuesday |
11/22-11/23 |
| Monday-Tuesday |
12/13-12/14 |
|
|
|
|
Course Outline |
Register |
| Cost: |
$225 |
| Duration: |
1 Day |
| Time: |
8:30 AM to 4:30 PM |
| Prerequisite: |
Microsoft Excel Introduction |
| Summary: |
|
| This class targets
beginning to intermediate Excel users seeking real-world examples of
how they can use Excel’s powerful built-in functions. |
|
|
2010
|
|
| Friday |
1/8 |
| Monday |
2/22 |
| Friday |
3/19 |
| Tuesday |
4/27 |
| Monday |
6/14 |
| Friday |
7/16 |
| Monday |
8/9 |
| Monday |
9/20 |
| Tuesday |
10/19 |
| Friday |
12/10 |
|
|
