LOCATION:Universal Square. Devonshire Street North, Manchester M12 6JH
SIMS 7 – Advanced Reporting with Excel Analysis - 10 - 11 July 2020
What you will learn
• How to link a SIMS 7 report to a custom Excel template
• Excel formulas including Count-If / Count-Ifs, Sum If / Sum Ifs, IFERROR and others
• Designing more complex SIMS 7 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 7 and Excel