Excel Data Analysis for Park and Recreation Professionals

Released March 2024! This course will introduce park and recreation professionals to the basics of how to use Microsoft Excel for data management and analysis. Participants will apply knowledge learned and gain hands-on experience with MS Excel by using a parks and recreation-specific case study with sample data.

After completing the training course, learners will have developed a deeper knowledge of the features of Microsoft Excel, including how to modify data within rows and columns, how to find missing or outlier data, how to write basic and more advanced formulas, how to analyze data in a table, how to create and understand pivot tables, how to use the "Analyze Data" feature, and how to conduct a more advanced analysis using the information shared in the course. 

Key:

Complete
Failed
Available
Locked
Excel Training Booklet
Open to download resource.
Open to download resource. Download this training booklet. It contains one-page overviews of each video and additional resources for further study.
You must register to access.
Video 1: Course and Case Study Overview
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video provides an overview of the Excel Data Analysis for P&R Professionals course and introduces the case study that will be used throughout.
You must register to access.
Video 2: Downloading and Opening a Dataset
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video reviews the process for accessing, viewing, and downloading data from an online survey platform (Google Forms) and how to open the data within Microsoft Excel.
You must register to access.
Export from Google Sheets - Excel Basics for P&R Professionals
Open to download resource.
Open to download resource. IMPORTANT: Download and open this spreadsheet before watching the next four videos. This spreadsheet will be helpful as you follow-along with the Excel Basics, Getting to Know Your Data, and Setting Data Up for Analysis, and Checking Data Quality videos.
You must register to access.
Video 3: Excel Basics
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video goes over the essential tools in the Excel toolbar and how a basic spreadsheet is organized.
You must register to access.
Video 4: Get to Know Your Data
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video emphasizes the connection between the data on the spreadsheet and the questions asked in the original survey. It also shows how to organize and sort data so it can be more easily viewed.
You must register to access.
Video 5: Setting Up Data for Analysis
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video details how to rename column headers, create new variables through delimiting, and how to format data in a unified way.
You must register to access.
Video 6: Checking Data Quality
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video describes the “Find and Replace” function, the “Go to Special” function, and how to identify outlier data.
You must register to access.
Cleaned for Analysis - Excel Basics for P&R Professionals
Open to download resource.
Open to download resource. IMPORTANT: Download and open this spreadsheet before watching the remaining videos. This spreadsheet contains worksheets you will need to complete the analysis exercises.
You must register to access.
Video 7: Structure of Formulas
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video shares the basics of formulas in Excel. It demonstrates the formula bar and how to use the “fx” button to identify functions.
You must register to access.
Video 8: Formulas Part 1
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. The video shows how to find the average, median and sum of the data by using formulas.
You must register to access.
Video 9: Formulas Part 2
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video covers how to use the COUNTIF and COUNTA functions. Together, those two functions can be used to calculate a percentage of cases where a certain criterion was met.
You must register to access.
Video 10: Format as Table, AutoSum, and Filtering
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video show how to format data as a table, add an AutoSum row, and filter data within a table.
You must register to access.
Video 11: Pivot Table Part 1
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video introduces pivot tables. Pivot tables display data in a user-friendly way so that the data can be rotated and viewed in different ways.
You must register to access.
Video 12: Pivot Tables Part 2
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video expands on pivot tables and details their more advanced features.
You must register to access.
Video 13: Analyze Data Feature
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video demonstrates the Analyze Data feature which patterns in the data that can be used to create intelligent, personalized suggestions.
You must register to access.
Video 14: Bonus - Net Promoter Score Analysis
Select the "View On-Demand Recording" button to begin.
Select the "View On-Demand Recording" button to begin. This video covers what the Net Promoter Score is and how it can be calculated using Excel.
You must register to access.
Feedback Survey - Excel Data Analysis for Park and Recreation Professional
Select the "Click Here to Complete Survey" button to begin.
Select the "Click Here to Complete Survey" button to begin.
You must register to access.