Training & Information Program (TIP)
Mastering Your Preferred Source Service Application
Date: Thursday, 03/28/2019
Time: 10:00 am - 2:00 pm
Region: Western New York
Location: The ARC Erie County, 30 Wilson Road, Williamsville, NY 14221
Event Status: Registration Closed
Presenter:
NYSID Staff
Additional Presenters:
Presented by NYSID Staff and Staff from MicroKnowledge LLC a technology based training company.
Who Should Attend:
NYSID Member Agency and Corporate Partner staff responsible for submitting all required forms and documentation to NYSID for service contract applications
Session Objective:
This session will be presented in conjunction with MicroKnowledge Training and Consulting. An overview will be provided of both the OGS Preferred Source Service Contract approval process (with emphasis on OGS Form 3), and Microsoft Excel.
Application overview:
Review of forms required for submission with a Focus on “NYS OGS Form 3 – Service Cost Summary”
- Reviewing formulas
- Applying edits/formatting
- Inserting/deleting rows and columns
- Staffing plans
- Wages
- Fringe Benefits
- Required documentation for other costs –insurance, equipment, supplies, etc.
- Backup information required for a successful submission
- Acceptable market information
Excel Overview
- Quick Access Toolbar
- The Ribbon
- Mini-toolbar
- Creating worksheets
- Saving/opening/closing
- Creating formulas
- Working with functions; Sum, Average, Max, Min AutoSum