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.
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.
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