Mastering Your Preferred Source Service Application

Event Status: Registration Closed

---

Presenter:

NYSID Staff

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