Data Analysis and Problem Solving with Excel


Format On-campus or online
Cost $895
Duration 3 days
Availability Summer, on-demand
Prerequisites None
CEU's or PDH's 2.0 CEU's

Data is everywhere, but how should you organize it, visualize it, and utilize it to solve problems and make data-driven decisions?  This hands-on workshop will show you how to use Microsoft® Excel for making sense of data. You will enhance your data analysis skills and learn how to interpret Excel output. All basic statistical techniques are explained as well as how to design spreadsheets that allow you to see the consequences of your statistical analyses and get immediate feedback. The workshop will also demonstrate how to plan your data collection process so that meaningful information can be extracted with the minimum cost and effort, and how you can produce reports with defendable statistical analyses.

1) On-campus option

The on-campus workshop is offered over a 3-day period.  Each topic is reinforced through discussion, case studies, and exercises.  Exercises are conducted in our computer lab using Microsoft® Excel.  Outside of class, participants are welcome to join online discussions with the instructor and other students.

2) “Blended online” option

The online instructor-led workshop covers the same material as the 3-day on-campus program but is available over a 10-day period through our online Learning Management System, providing flexibility to your schedule.  Learning materials include pre-recorded lectures, case studies, and exercises.  We keep you actively engaged through online discussions with the instructor and other students.

Course Topics

  • Data collection process
  • Types of data
  • Graphical methods
  • Summary statistics
  • Sampling distributions
  • Survey sampling and design
  • Hypothesis testing
  • Confidence intervals
  • Analysis of variance
  • Correlation and regression
  • Time-dependent data

Who Should Attend

Individuals with a basic knowledge of Microsoft® Excel, who would like to learn more about Excel’s powerful capabilities for data collection, manipulation, problem-solving, and decision making.


A “certificate of completion” from RIT’s Center for Quality and Applied Statistics is issued upon completing the program including all assigned exercises.


Contact us at or 585-475-6990 for future dates.

Pricing and Registration

Individual Registration: $895

Discounts (only one discount per person):

  • Members of MedTech or GRQC: $806 (10%)
  • RIT Alumni, Employees, and Immediate Family Members: $716 (20%)
  • Full-Time College Students (all institutions): $716 (20% discount).  Contact or 585-475-6990 for a coupon code.

Group Registration (no other discounts apply):

  • 2 people: $806 per person (10%).  RIT Alumni and Employees - please register as 2 individuals
  • 3+ people: $716 per person (20%)

Cancellation Policy

Refunds will be issued for cancellations received and confirmed at least 10 business days prior to the program date. No refunds will be issued for cancellations received after that date. Please email with any questions.

Frequently Asked Questions

Yes. If you are unable to come to campus on any of the workshop days, you may instead access the materials online and complete the workshop.  Online discussions are available to all participants whether they are on-campus or online.

Our online courses and workshops are virtually identical in content to our “live” on-campus courses, but they are conducted online and are flexible to your personal schedule.  Unlike self-paced online training, we keep you actively engaged with our instructors and other program participants.  Instead of in-class discussions, you will participate in online discussions.

Yes.  Our online course environment is available to our on-campus students, who are also welcome to participate in online discussions for the duration of the online workshop.  If you aren’t comfortable with online learning, register for the on-campus version but feel free to check-out the online materials.  All registrants are provide pdf’s of course materials which remain available after the workshop ends.

If you do not complete the required material and exercises, you will not receive a “certificate of completion” from RIT.  The workshop includes about 24 hours or class material along with exercises using Microsoft® Excel, and online participants are given 10 days to meet all requirements, so be sure to budget your time accordingly.

No.  Participants are offered the flexibility of completing the workshop on-campus or online.