Sorry, you need to enable JavaScript to visit this website.

Data Analysis and Problem Solving with Excel

August 3 - 12, 2020 (blended online)

At-a-Glance

Format On-campus
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.

Certification

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

Schedule
Upcoming Dates Registration
July 3 - 12, 2020 Open
Pricing and Registration

Individual Registration: $895

Discounts (only one discount per person):

  • Members of MedTech or GRQC: $806 (10%)
  • RIT Alumni and Employees: $716 (20%)
  • Full-Time College Students (all institutions): $716 (20% discount).  Contact Susan Chapman at cqas@rit.edu 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%)

Please register by clicking on the appropriate program below. You may also register by contacting Susan Chapman at 585-475-6990 or cqas@rit.edu.

Accommodations: Rooms may be reserved at the Radisson Hotel adjacent to the RIT campus. Information on how to make a reservation will be emailed to you.

August 3 - 12, 2020 (blended online)

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 cqas@rit.edu with any questions.

Frequently Asked Questions

If I register for the on-campus workshop, can I switch to the online version or complete the remaining part of the workshop online?

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.

What does the term “instructor-led” mean?

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.

I prefer “live” over online classes but I would like access to online materials.  Will I have access to these materials even if I register for the live class?

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.

What if I don’t have time to submit the required exercise before 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. 

Can I get a refund if I am unable to meet the requirements in the allotted time?

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