Date(s): Thursday, July 23, 2020, 10:00am - 01:00pm

Presenter: Jeff Kunkel

Member Pricing: $200

Non-Member Pricing: $300

Registration Deadline: 2020-07-20

In this hands-on training, you will learn how to use Microsoft Excel to gather, analyze and report on key performance metrics for your organization. You will be guided through every step of the process, including:

* Learning how to create user friendly data entry forms in Excel that ensure that the data you get is the data you need
* Aggregating the data in a structured manner to ensure its ready for analysis
* Selecting and performing analyses for each set of data that will provide your organization with the information it needs
* Reporting on your analysis in a concise and effective manner
* Numerous quality of life "tricks and tips" to help you work more efficiently and create more visually appealing spreadsheets

In addition, this training will cover essential statistical concepts, such as central tendency, standard deviation and control limits, which are crucial tools for interpreting and reporting on data that you’ve gathered.

A basic knowledge of Microsoft Excel is necessary to gain the full benefit of this course, including navigating Excel the use of common functions such as SUM(), AVERAGE(), etc. This training will not require the use macros or scripting languages. Each participant will need to have a notebook computer with Microsoft Excel installed in order to practice the techniques taught during the training.


Presenter
Jeff Kunkel, M.S.
Strategic Planning Consultant, JLK Strategies