Skip to main content

Advanced Reporting with Excel Analysis – Tutor Led Training

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.

Available dates below
Start times are variable - see course dates
£200 for Scomis customers, £259 for non-customers.
Full Day (2 x Half Day)
Course type
Remote tutor led course
Available Dates
11th June (1pm to 3.30pm) & 18th June (1pm - 3.30pm)

Rather than having to manually manipulate the data in Excel each time that the report is re-run with up-to-date information, you can link an Excel template containing all the required formulas, conditional formatting and/or pivot tables to the report definition within SIMS. In this way, when the SIMS report is run the data is exported to Excel then reformatted and analysed in a single process. Once defined, the SIMS report can be run by users without requiring Excel knowledge.

This course explores using SIMS reports to extract data and Excel to automatically analyse this data. It will cover the creation of reports in SIMS and explore some of Excel’s capabilities for data analysis including formulas, conditional formatting, macros and pivot tables.

Course Requirements
Some basic knowledge of SIMS, including the 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 would be advantageous but is not essential. Maximise the power of your SIMS reports, by using predefined Excel templates to analyse data more effectively.

Course Objectives
By the end of the course you will understand:

How to link a SIMS report to a custom Excel template
Excel formulas including COUNTIF / COUNTIFS, SUMIF / SUMIFS, IFERROR plus others
How to design more complex SIMS reports
Excel conditional formatting
Excel pivot tables
Excel macros