Excel is possibly the most commonly used system for data management within the field of education. It is fairly user friendly and has many different uses. Excel allows professionals to keep track of grades, track progress from interventions, and create graphs as a visual representation of a student’s progress. If you are unfamiliar with Excel, there are numerous resources available to help you understand how to use Excel. Online resources are available and some public libraries offer classes teaching basic Excel skills.
Iowa AEA online tutorials
More help for Excel can be found on Iowa AEA Online’s Learn360 link:
- First contact your school’s teacher librarian for your school’s username and password to use the tutorials, or AEA employees can contact their media center.
- On Learn360 website:
- Enter username & password
- Enter Excel in the search box
This search will uncover many valuable tutorials on how to use the various features of Excel on both a Mac and a PC and your version of Excel.
Samples of Excel templates
Excel tips
| Name | Description |
|---|---|
| VLOOKUP Function (PC) | A step by step tutorial with screenshots on how to use the VLOOKUP (or vertical lookup) function in Excel with a PC. |
| VLOOKUP Function (Mac) | A step by step tutorial with screenshots on how to use the VLOOKUP (or vertical lookup) function in Excel with a Mac. |