Back to Course

AI Enhanced Content Creation (Three Spires)

0% Complete
0/0 Steps
  1. Learning Objectives
  2. Introduction
  3. Microsoft Modules
    AI in Microsoft
  4. Microsoft Word + Copilot
  5. Microsoft Excel + Copilot
  6. Outlook and Teams + Copilot
  7. Google Modules
    Google AI
  8. Google Docs + Gemini
  9. Google Sheets + Gemini
  10. Google Slides + Gemini
  11. Gmail + Gemini
  12. Google NotebookLM
  13. Activities
  14. Canva
    Canva AI
  15. Canva Code + AI
  16. Sustainability
  17. Additional Resources
AI Enhanced Content Creation (Three Spires) Microsoft Excel + Copilot
Section 5 of 17
In Progress

Microsoft Excel + Copilot

19th December 2025

Excel with Copilot transforms data management into an intuitive process. Instead of manually analysing spreadsheets, staff can ask Copilot to identify trends in attendance, behaviour or assessment data and explain them in plain English. Copilot can also create dashboards and charts for leadership reports or governor meetings, turning raw data into visual insights. Cleaning messy data becomes effortless, as Copilot removes duplicates, fills gaps and organises columns automatically. Repetitive calculations, such as forecasting attendance or calculating averages, can be automated with a single prompt. This means data managers and leaders can spend less time crunching numbers and more time acting on insights. 

Examples: 

  • What are the key trends in Year 10 attendance over the last term? 
  • Create a dashboard showing progress by subject for Year 11. 
  • Explain why Year 9 behaviour incidents increased in November. 
  • Clean this spreadsheet and sort by intervention type. 
  • Calculate average attendance by year group and forecast next term. 

Activities:

Select one of the activities below which is most relevant to your job role.

Activity for Leader:

Generate a Data Dashboard for Governors 

  • Open Excel and activate Copilot. 
  • Prompt Copilot: Create a dashboard showing attendance trends by year group for the last term and forecast next term’s attendance. 
  • Then ask Copilot to: “Summarise the key insights in plain English for a governor report.”

Activity for Teacher:

Analyse Class Assessment Data 

  • Open Excel and activate Copilot. 
  • Prompt Copilot: “Summarise the assessment results for my Year 9 class and identify students who may need extra support.” 
  • Then ask Copilot to: “Create a chart showing progress by topic and suggest three intervention strategies based on the data.” 

Activity for Admin:

Track Intervention Impact 

  • Open Excel and activate Copilot. 
  • Prompt Copilot: “Create a table showing all SEND interventions this term and calculate the average improvement for each intervention type.” 
  • Then ask Copilot to: “Generate a dashboard that highlights which interventions had the greatest impact.”