Teacher Resource Kit - Microsoft Excel

Hi… welcome to this Teacher Resource Kit for Microsoft Excel. It has been designed to introduce any audience to Microsoft Excel from zero knowledge. The core teaching resources are 4 PowerPoint presentations for you to amend as you see fit and adapt for your class. Allocate time for students to try the various elements demonstrated.

There are 4 Word documents that accompany each PowerPoint to use as handouts if appropriate, and 2 practice spreadsheets with their accompanying solutions for the last 2 presentations.

Also included are a set of 4 practice tasks along with instructions and solutions… A ‘Really Useful Functions’ set of tasks, again with instructions and solutions to some common formulas such as VLOOKUP, CONCATENATE, DAYS and MAXIF and others.

Finally there is a ‘Fun Spreadsheets’ set which can be used for extension work as students will have to work out how they were put together and create their own versions. Instructions and 4 challenges are included (Company Order Form, Chess, BattleShips and a Random Card Picker).



Save for later
  • Delivery-Guide.docx
  • Excel---Delivery-Contents.docx
  • Excel-Core-(Part-1).pptx
  • Excel-Core-(Part-2).pptx
  • Excel-Intermediate-(Part-3).pptx
  • Excel-Intermediate-(Part-4).pptx
  • Excel-Tutorial-1-(The-Interface).docx
  • Excel-Tutorial-2-(Exploing-Cells).docx
  • Excel-Tutorial-3-(Manipulating-Data---Charts).docx
  • Excel-Tutorial-3-Sample-Data-Complete.xlsx
  • Excel-Tutorial-3-Sample-Data.xlsx
  • Excel-Tutorial-4-(Formulas---Functions).docx
  • Excel-Tutorial-4-Practice-Data-(Complete).xlsx
  • Excel-Tutorial-4-Practice-Data.xlsx
  • fun_spreadsheets_battleships.xlsx
  • fun_spreadsheets_big_t_company.xlsx
  • fun_spreadsheets_card_picker.xlsx
  • fun_spreadsheets_chess.xlsx
  • fun_spreadsheets_instructions.docx
  • practice_tasks_instructions.docx
  • practice_tasks_Task-1-Complete.xlsx
  • practice_tasks_Task-1.xlsx
  • practice_tasks_Task-2-Complete.xlsx
  • practice_tasks_Task-2.xlsx
  • practice_tasks_Task-3-Complete.xlsx
  • practice_tasks_Task-3.xlsx
  • practice_tasks_Task-4-Complete.xlsx
  • practice_tasks_Task-4.xlsx
  • really_useful_functions_complete.xlsx
  • really_useful_functions_instructions.docx
  • really_useful_functions_tasks.xlsx

About this resource


Created: Feb 26, 2020

Updated: Apr 7, 2020

docx, 23 KB


docx, 24 KB


pptx, 152 KB


Report a problem

Categories & Grades

Tes Paid Licence

How can I re-use this?