Advanced Reporting with Excel Analysis

View Dates

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.

Need help?

Let us help you find the right course

Benefits of attending

To learn time saving, advanced reporting in SIMS using sub reports and filters and analysis techniques using a combination of SIMS and Excel, including automating the process for formula calculations, conditional formatting and pivot tables using macros.

What you will learn

• how to link a SIMS report to a custom Excel template
• Excel formulas including Count-If / Count-Ifs, Sum If / Sum Ifs, IFERROR and others
• designing more complex SIMS reports
• Excel conditional formatting
• Excel pivot tables
• Excel macros.

Who is it for?

Staff who wish to extend their ability to analyse data using SIMS and Excel. Some basic knowledge of SIMS, including the Assessment, Attendance and Behaviour Management areas is required to get the best from this course. Experience creating SIMS reports would also be beneficial. Some understanding of formulas and functions in Excel 2007 or later would be advantageous but is not essential. This course has a key focus on assessment and does not follow on from the Advanced Reporting with Excel Analysis – Pastoral course.

Course details

Phase of education
  • Secondary
Delivery Type
Face to face
Areas of responsibility
Administrative Staff
Course code
Multiple Sessions

Upcoming scheduled courses

  1. Date


    Book now

  2. Date


    Book now

  3. Date


    Book now

  4. Date


    Book now