PENNINE EDUCATION LTD
  • Home
  • Documentation/Files
  • Testimonials
  • Training
  • Our Staff
  • Downloads
  • SIMS Next Gen
  • Contact
  • Home
  • Documentation/Files
  • Testimonials
  • Training
  • Our Staff
  • Downloads
  • SIMS Next Gen
  • Contact
Search

Advanced Reporting with Excel Analysis

Course overview
Explore the use of SIMS to extract and analyse data including how to automate reporting and analysis, enabling your school to generate the reports whenever necessary.

​Benefits of attending
To learn advanced reporting and analysis techniques, including automating the process.

What you will learn
• How to automate data analysis in SIMS reports using Excel across the SEN, attendance, behaviour and personnel areas.
• Excel formulas, pivot tables and macros.
• Analysing data using Excel.
• Designing more complex SIMS Reports.

Who is it for?
​
Personnel who wish to extend their ability to analyse data using SIMS and Excel.
You will need some basic knowledge and experience of SIMS, including the SEN, attendance, behaviour, personnel and reporting areas, and an understanding of Excel.
Also Consider:
Power BI and SIMS
Course details
Phase of education

Secondary

Delivery Type
Face to face

Areas of responsibility
Administrative Staff
Pastoral
Data Manager

Duration
1 Day

Categories
Core
Pennine Education Ltd 
Hollinwood Business Centre
Albert Street
Failsworth
Oldham
Ol8 3QL

Phone: 0161 509 2900
Email: [email protected]
Copyright © 2026
  • Home
  • Documentation/Files
  • Testimonials
  • Training
  • Our Staff
  • Downloads
  • SIMS Next Gen
  • Contact