6,182
Jobs Provided
4,498,565
Hours Worked
68
In Wages Paid
NYSID TIP Training

Training & Information Program (TIP)


‹ Back to Schedule

Mastering Your Preferred Source Service Application

Tue
3/12
2019

Date: Tuesday, 03/12/2019
Time: 8:30 am -12:30 pm

Region: Central New York
Location: Human Technologies, 2260 Dwyer Avenue, Utica, NY 13501

Event Status: Open

Register Now ›

Presenter:

NYSID Staff

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