Reporting - Excel Analysis - Complete
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.
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 StaffPastoralData Manager
- Course code
- AREA-2-05
- Duration
- Multiple Sessions
- Categories
- Core