MS Excel Training Program

MS Excel Training Program

MS Excel Training Program

Computer Applications Training Sitemap


MS Excel Training Program Advanced search
Technology Driven IT Training Web-based Training Services Why SYS-ED for Web-based Training
Definition of Service Delivery Medium Contact You

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, can be incorporated into the program.

MS Excel Training Program

Base Program Duration
Technology Updates
MS Office Web, Office 365, and MS Office
MS Internet Explorer
MS SharePoint
 
Trends in the Market
Web Browsers and Mobile Devices -
Emerging Development Platforms

MS Excel Training Program

Teaching Models

MS Excel Training Program

Why SYS-ED

MS Excel - Introduction 1 day
MS Excel - Intermediate 1 day
MS Excel - Advanced 1 day
MS Excel: Database and Charts 1 day

Base Program Duration

4 days
Optional Courses
MS Excel: Macros and VBA Programming 2 days
Alternative FOSS Open Source Software  
OpenOffice or StarOffice 7 days

Google Apps, Google Chrome, and Google Searching

4 days

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: Macros and 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

http://www.pcapplicationstrainingbysysed.us/commquests.htm

Footnote 1:
SYS-EDís core computer applications curriculum has been submitted to New York State Department of Education for review and licensure.