LOCATION:One Education, Universal Square, Devonshire Street North, Manchester, M12 6JH
SIMS Extended Reporting with Excel Analysis - 10 November & 11 November 2020
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.
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