Reporting - Excel Analysis - Complete

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.

NOTE: We have recently updated our course names to better support our customers in finding the course they need, the course content has not changed only the name has been updated. This course was previously titled Advanced Reporting with Excel Analysis.

Need help?

Let us help you find the right course

simstraining@sims-mis.com

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.

Also Consider:
Reporting - Power BI for Analysis

Learning Pathway: #Reporting #Independent

Course details

Phase of education
  • Secondary
Delivery Type
Remote
Areas of responsibility
Administrative Staff
Pastoral
Data Manager
Course code
AREA-2-05
Duration
Multiple Sessions
Categories
Core

Upcoming scheduled courses

  1. Date
    Venue

    Remote

    Book now

  2. Date
    Venue

    Remote

    Book now