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. |Welcome to Excel Easy
Learn the basics of Excel to help you enter all sorts of data and perform financial, mathematical or statistical calculations. |Top 10 Ways to Clean Your Data
Walk through the basics of organizing and cleaning your data, including these popular functions and more. |- Fill data automatically in worksheet cells |
- Create and format tables |
- Resize a table by adding or removing rows and columns |
- Use calculated columns in an Excel table |
- Create a macro |
- Filter for unique values or remove duplicate values |
- Find or replace text and numbers on a worksheet |
- Convert numbers stored as text to numbers |
- Merge cells or split merged cells |
- Look up values in a list of data |