 |
 |
MS Excel Training Program |
Home |
SYS-ED’s MS Excel training program
ranges between 2 and 6 days in duration and can be
tailored to specific training needs and operational objectives.
|
Module: |
MS Excel: Introduction |
|
Duration: |
1 day |
|
Audience: |
User and business professional |
|
Prerequisites: |
MS Windows |
|
Objectives: |
| 1. Getting started |
2. Workbook concept |
3. Basic data entry |
| 4. Creating formulas |
5. Navigation |
6. Selection techniques |
| 7. Formatting cells |
8.
Advanced formatting |
9. Working with columns/rows |
| 10. Copying, moving data |
11. Aggregate functions |
12. Page setup |
| 13. Printing worksheets |
|
|
|
|
Module: |
MS Excel: Intermediate |
|
Duration: |
1 day |
|
Audience: |
User and business professional |
|
Prerequisites: |
MS Excel:
Introduction |
|
Objectives: |
| 1. Large worksheets |
2. Working with multiple sheets |
3. Managing worksheets |
| 4. Working with outlines |
5. Paste special |
6. Range names |
| 7. Multiple workbooks |
8.
Creating charts |
9. Editing charts |
| 10. Sorting data |
11.
Working with the data form |
12. Filtering records |
|
|
Module: |
MS Excel: Advanced |
|
Duration: |
1 day |
|
Audience: |
User and business professional |
|
Prerequisites: |
MS Excel: Intermediate |
|
Objectives: |
| 1. Advanced filters |
2.
Database functions |
3. Data series |
| 4. Lookup functions |
5.
Scenarios and goal seeking /what-if
analysis |
6. Data tables |
| 7. Solving problems |
8. Consolidating worksheets |
9. Creating/revising pivot tables |
| 10. Macros |
11.Recording macros |
12.Macro button creation |
|
|
Module: |
MS Excel: Database and Charts |
|
Duration: |
1 day |
|
Audience: |
User and business professional |
|
Prerequisites: |
MS Excel: Advanced |
|
Objectives: |
| 1. Database concept |
2.
Rules for labeling columns |
3.
Data forms |
| 4. Summarizing data |
5. Autofilter |
6. Advanced filter |
| 7. Named ranges |
8. Names in formulas |
9. Subtotaling |
| 10. Database functions |
11. Chart types |
12. Chart creation |
| 13. Editing charts |
|
|
|
|
Module: |
MS Excel: Macros and VBA Programming |
|
Duration: |
2 days |
|
Audience: |
Business professional and programmers |
|
Prerequisites: |
MS Excel: Advanced |
|
Objectives: |
| 1. Visual Basic program structure |
2.
Functions |
3. Facilities for developing Excel
applications |
| 4. Calling procedures |
5. Statements |
6. Variables |
| 7. Arguments |
8. Data types/multiple variables |
9. Arguments and function procedure |
| 10. Assigning an object to a variable |
11. Variant specific data types |
12. Property procedures |
|
Additional information can be reviewed from
SYS-ED technology exchange websites. They have been designed to
compile, organize, and present operational categorizations of
interrelated information technology.
Footnote 1:
SYS-ED’s core computer applications curriculum has been submitted to New
York State Department of Education for review and licensure.
