• Home
  • Toolkit for Understanding Spreadsheets

Toolkit for Understanding Spreadsheets

Understanding how to effectively use spreadsheets is useful to improve data analysis, manage projects and performance, and enable users to identify trends and organize and sort data into meaningful categories. Below are resources to help environmental health professionals successfully use data.   

Excel Video Training  

Watch training videos to understand the purpose and efficiency of using spreadsheets for data collection. | Microsoft 

Welcome to Excel Easy 

Learn the basics of Excel to help you enter all sorts of data and perform financial, mathematical or statistical calculations. | Excel Easy

Top 10 Ways to Clean Your Data  

Walk through the basics of organizing and cleaning your data, including these popular functions and more. | Microsoft
  • Fill data automatically in worksheet cells | Microsoft
  • Create and format tables | Microsoft
  • Resize a table by adding or removing rows and columns | Microsoft
  • Use calculated columns in an Excel table | Microsoft
  • Create a macro | Microsoft
  • Filter for unique values or remove duplicate values | Microsoft
  • Find or replace text and numbers on a worksheet | Microsoft
  • Convert numbers stored as text to numbers | Microsoft
  • Merge cells or split merged cells | Microsoft
  • Look up values in a list of data | Microsoft

Create a Chart from Start to Finish 

Visualize your data in a way that creates maximum impact. | Microsoft

Understand and Use Cell References 

Learn to calculate the values in cells. | Microsoft

Analyze Data in Excel 

Understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. | Microsoft

Import Data from the Web 

Take your data transformation skills to the next level. | Microsoft