Primary tabs

Registration Closed

 This hybrid training introduces participants to key Excel features that can be used to analyze WIOA-related data found in SMARTT and Cognos.


This professional development activity/course is designed for:

  • Intermediate and advanced users of SMARTT who have completed both the SMARTT New User course and the Intro to Cognos course

Have you ever wished that all the information in SMARTT and Cognos was in a more usable report or in a format where you could extract just the data you wanted, in the way you needed it? Excel is a great tool for accomplishing these tasks, but many users lack the knowledge and skills to do them easily and effectively. This training will show you some Excel features that will greatly facilitate this process.

This hybrid training consists of two parts:

  • Part 1 is an online asynchronous course done at your own pace. It covers basic skills needed to use Microsoft Excel for manipulating data exported from SMARTT. Inserting columns, sorting, using formulas, and creating tables will all be covered.

  • Part 2 is a live webinar or a face-to-face training that will focus on specific types of SMARTT and Cognos data, including NRS cohorts, assessment data, and education functioning levels (EFLs).

Learning Objectives: 

Upon completion of this professional development activity/course, you will be able to:

  • Locate and export WIOA-relevant data from SMARTT and Cognos into Excel
  • Use formulas, functions, and tables to extrapolate the data you need
  • Use Excel tools such as fills, sorting, filtering, conditional formatting, text-to-columns, and more
  • Chart and print your worksheets

 SMARTT New User

04/14/2017 - 1:00pm
End Date: 
04/14/2017 - 4:00pm
Picknelly Adult & Family Education Center, Holyoke-GTC Room 104/105
206 Maple St.
Holyoke, MA 01040
PD Center: 
Topic Area: 
SMARTT and Cognos
PDP Eligible: