Course Descriptions

In this course, students will learn how to use Microsoft Excel to perform sales ratio studies. An overview of sales ratio studies is provided, but students should already be familiar with the steps of conducting a sales ratio study. This is a hands-on course. Most of the course time will be spent creating a sales ratio study from raw data using Excel. Students are required to bring their own laptop or tablet to class with the latest version of Excel.

Hours: 7.5 CE Hours
Category: Statistics

Recommended Prerequisites:

• Introduction to Excel (#002-780 or #002-781) or basic working knowledge of Microsoft Excel
• One or more of the following courses: º Fundamentals of Sales Ratio Analysis (#002-604 or #002-777)
  • Neighborhood Analysis (#002-210 or #002-211)
  • RETDs From Township to State (#002-206 or #002-207)
  • Intro to Sales Ratio Studies (PTAX 1-E)