LOCATION:One Education, Universal Square, Devonshire Street North, Manchester. M12 6JH,
Advanced Reporting with Excel Analysis- Secondary
This course explores the use of the reporting functionality to extract data and the use of Excel to analyse this data. We will explore some of the capabilities of Excel in data analysis and show how to automate this analysis. This course will demonstrate how to combine the reporting and the analysis into a repeatable automated process, enabling you to generate the reports whenever necessary
By the end of the course you will have an understanding of:
automating data analysis in SIMS reports using Excel Excel formulas analysing data using Excel designing more complex SIMS reports Excel pivot tables Excel macros.
Who's It For?
SIMS Exams Officers/Data Managers/Office Users