Skip to Main Content
WAB Faculty & Staff

HS EdTech: Excel

Tech Tools, tips, how-tos and resources for High School.

Making the Most of Microsoft... Excel.

learn.wab.edu/edtech/office/excel

Excel can do a lot of the heavy work of data processing, presentation & analysis. 

With some simple strategies and good organisation, you can make the most of this powerful tool. 

Tutorials are arranged by level below. If you need support/workshops, ask your EdTech coach. 

Excel Online Tutorials from the Microsoft Training Center

Excel Help Center: https://support.office.com/en-us/excel 

A stopwatch symbol 
Quick start		 Pointer and hand symbols 
Intro to Excel		 A table with columns 
Rows & columns		 An Excel cell symbol 
Cells		 Formatted letter symbols 
Formatting
A calculator symbol 
Formulas & functions		 A table symbol 
Tables		 A chart symbol 
Charts		 An Excel PivotTable symbol 
PivotTables		 Three dots with two lines showing sharing from one to the other two 
Share & co-author
An Excel document with an arrow shape 
Take a tour
Download template >		 An Excel document shape with fx for functions 
Formula tutorial
Download template >		 An Excel document with pivot arrows 
Make your first PivotTable
Download template >		 PivotTables symbol with a plus sign 
Get more out of PivotTables
Download template >		  

 

Tutorials from other sources

Beginner's Guide to Excel for Mac

Intermediate Guide to Excel for Mac

 

Try This...

Using some data you have for class or a project: 

  • Determine the best format for presenting the data. What type of graph do you need? Why? 
  • Determine what calculcations (processing) are needed to be able to make that graph. 
  • Have a go! 

Resources for IB Sciences on MrT's Site

Excel Courses Online

Tiger Tube Tutorials

Making Tables In Excel

Creating & Formatting Simple Graphs in Excel