SYS-ED’s MS Excel training program ranges between
4 and 6 days in duration and will be
tailored to specific training needs and operational objectives:
software version, open source software and web browser.
A lesson plan based upon the standards of the New York State Department of Education will be provided as part of qualifying the subject matter, examples, exercises, and program duration. Educational consultancy topics, inclusive of
project specifications also can be incorporated into the program.
|
Module: |
MS Excel - Introduction |
|
Duration: |
1 day |
|
Major Topics: |
| 1. Exploring MS Excel |
2. Workbook concept
and skills |
3. Copying and moving
data |
| 4. Creating simple
formulas |
5.
Formatting cells |
6.
Formatting text |
| 7. Formatting numbers |
8.
Styles |
9.
Working with columns and rows |
| 10. Using page setup |
11. Printing worksheets |
|
|
|
Module: |
MS Excel - Intermediate |
|
Duration: |
1 day |
|
Major Topics: |
|
1. Customizing toolbar |
2.
Range names |
3. Large worksheets |
|
4. Working with multiple sheets |
5.
Managing worksheets |
6. Working with outlines |
|
7. Paste special |
8.
Multiple workbooks |
9. Styles, templates, and workspaces |
|
10. Graphic objects |
11.
Creating charts |
12. Editing charts |
| 13. Autofilter |
|
|
|
|
Module: |
MS Excel - Advanced |
|
Duration: |
1 day |
|
Major Topics: |
| 1. Advanced filters |
2.
Database functions |
3. Data series |
| 4. Lookup functions |
5.
Scenarios and goal seeking / what-if
analysis |
6. Data tables |
| 7.
Creating and revising pivot tables |
8.
Solving problems |
9.
Consolidating worksheets |
| 10.
Macros |
11. Recording macros |
12.
Editing macros |
| 13. Macro button creation |
|
|
|
|
Module: |
MS Excel: Database and Charts |
|
Duration: |
1 day |
|
Major Topics: |
| 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: VBA Programming |
|
Duration: |
2 days |
|
Major Topics: |
| 1.
Recorded macros |
2.
Recorder workshop |
3.
User-defined functions |
| 4.
VBA Editor procedures |
5.
Variables |
6. Variables |
| 7.
Excel objects |
8.
Programming techniques |
9.
Custom forms: creating |
| 10.
Programming custom forms |
11. Custom
menus |
12.
Automatic start-up |
|
Review Additional Content
Open source and alternative commercial software can be researched using the
course search engine.
Additional information can be reviewed from SYS-ED software specific websites.
Footnote 1:
SYS-ED’s core computer applications curriculum has been submitted to New York State Department of Education for review and licensure.
