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 Atomic Learning link:

  • First contact your school’s teacher librarian for your school’s User ID and password to use the tutorials, or AEA employees can contact their media center.
  • On Atomic Learning Website:
    • Enter password
    • Enter Excel in the search box -or- use the Advanced Filters: All Applications and scroll down and choose Excel

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

Individual Excel Template

Class Group Excel Template

Grade School Excel Template

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.