Many of the Workforce Development classes will continue online throughout the COVID-19 pandemic response (highlighted below). Other classes, best taught in person, will be suspended. See below to view the status of each individual class.


Prerequisite: A solid foundation in Microsoft Excel.

The CCM ‘Certificate in Data Analytics’ offered through Workforce Development provides participants with data acumen in the areas of data manipulation, visualization and interpretation. To obtain your certificate, you must take all of the following courses. Classes may be taken in any order, but the recommended sequence is:

  • Introduction to R Programming and Data Science
  • Business Analytics with Excel
  • Visual Basic Applications in Excel
  • Tableau I
  • Tableau II


The CCM ‘Certificate in Data Visualization’ provides participants with an understanding of a visualization tool which presents large amounts of complex data in an easy to understand format. Visual context such as charts and graphs make it easy to identify correlations, patterns, trends or areas needing improvement.

By taking all four courses, individuals will be prepared to take the Tableau Desktop Specialist certification exam. To obtain your Data Visualization certificate, you must take all of the following courses:

  • Tableau I
  • Tableau II
  • Tableau III
  • Tableau IV


PREREQUISITE: Working knowledge of personal computers.   

This ten-hour course introduces students to R, a free, open source, statistical software program used to analyze large data sets. Students will complete projects analyzing large data sets related to environmental and business issues. The course will cover exploratory data analysis techniques, visualization methods, modeling and ideas in reproducible research. R’s widespread popularity in today’s data driven business world makes R a must-know data analysis tool in almost every field of business: finance, bio science, supply chain, sports, retail, marketing, social media, manufacturing and even journalism. High school statistics teachers will benefit from this course as well, by incorporating technology, an element of the common core curriculum. At the completion of this introductory class, students will be able to produce their own R-based report in their own business or school environment. Enrollment is limited to 20. CPC-603

INSTRUCTOR: Kelly Fitzpatrick, MA

5 Sessions: 10 hours, CEU 1.0

Time: TBD

Cost: $499


Prerequisite: Proficient/Intermediate knowledge of MS Excel.

The Business Analytics course is designed to teach students how data science is applied in business.  Students will utilize the Analysis ToolPak built into Excel to explore concepts in correlation, regression analysis and hypothesis testing. Students will learn the theory behind these statistical methods as they master the practical application.  Students will explore multivariate analysis and how correlation can help them understand portfolio diversification and design. ‘What If’ analysis will be covered utilizing the Solver and Go Seek features of Excel. CPC-629.

Instructor: Kelly Fitzpatrick

28879. 1 session: 6 hours, CEU 0.6

Time: 6:30-7:30 p.m., April 28, 30, May 7, 9 plus a 30-minute project for each class.

Location: online

Cost: $299


PREREQUISITE: Proficient knowledge of MS Excel.

You will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with learning how to record macros and the basics of VB programming. The course will teach you to read, write and debug VB code. You will also learn how to pass lists and floating variables though VB. The course will teach you to use conditional statements, create input and message boxes. At the end of this course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. CPC-624

INSTRUCTOR: Kelly Fitzpatrick, MA

1 Session: 6 hours, CEU 0.6
Time: TBD

Cost: $299


Tableau has advanced capability to analyze large data sets easily. Tableau allows users to analyze data using multiple dimensions and creates tables and visualizations ready for the board room. Start your journey to the CCM Data Visualization Certificate with Tableau I and take all four classes. Following the CCM courses, if you are interested in demonstrating your mastery of Tableau, there are multiple levels of certification available through Tableau. Search

Instructor: Kelly Fitzpatrick, MA

Textbook included with all classes.

TABLEAU I – this online class is open for registration

The first session in CCM’s four-part series introduces Tableau. Learn basic Tableau fundamentals, as well as connecting and preparing data, exploring data and managing, sorting and grouping data.  CPC-625

4 sessions: 6 hours, CEU 0.6

Time: 6:30-8:00 p.m., Tues and Thurs, March 31-April 9

Cost: $499

TABLEAU II – this online class is open for registration

This course picks up where Tableau I leaves off, and includes saving and sharing, filtering data, custom visualizations and creating maps, dashboards and stories. CPC-626

28874. 4 sessions: 6 hours, CEU 0.6

Time: 6:30-8:00 p.m., Tues and Thurs, April 14-23

Cost: $499

TABLEAU III – this online course is open for registration

Students will move beyond fundamentals to perform advanced data visualization. Blend data to visualize relationships, join data, access data in pdfs and refine your visualizations with sets and parameters. CPC-627

28875. 4 sessions: 6 hours, CEU 0.6

Time: 6:30-8:00 p.m., Tues and Thurs, May 12-21

Cost: $499

TABLEAU IV – open for registration

Complete the CCM Tableau series and earn your Data Visualization Certificate as you conclude with manipulating data with calculations, visualizing data with advanced calculations, performing statistical analysis and forecasting, and learning to enrich visualizations, dashboards and maps. CPC-628

28876. 1 Session: 6 hours, CEU 0.6

Time: 9:30 a.m.-4:30 p.m., Tues, June 9

Location: Cohen Hall, CH 156, TBD

Cost: $499