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

0800 170 1724

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
Pastoral
Administrative Staff
Course code
AREA-2-05
Duration
2 Days
Categories
Core

Upcoming scheduled courses

  1. Date
    Venue

    Bedford

    Book now

  2. Date
    Venue

    Chelmsford

    Book now

  3. Date
    Venue

    Northampton

    Book now

  4. Date
    Venue

    Wembley

    Book now

  5. Date
    Venue

    Reading

    Book now

  6. Date
    Venue

    Pontefract

    Book now