ONLINE Practical Data Analytics
Date: January 14th & 15th 10am – 3pm
Members $250 / Non-members $325
Presented by Jeff Kunkel, M.S-Strategic Planning Consultant, JLK Strategies
ONLINE VIA ZOOM
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 computer with Microsoft Excel installed in order to practice the techniques taught during the training. This class is limited to 20 participants.