Training Course

Advanced Reporting with Excel Analysis- Secondary 13 June 2019

This course explores the use of the reporting functionality to extract data and the use of Excel to analyse this data (Secondary schools).

Contact us or call 0844 967 1111

Cost: £189.00 +VAT (Or free to ICT SLA customers using promo code)

LOCATION:

One Education, Universal Square, Devonshire Street North, Manchester. M12 6JH,

Go back

Advanced Reporting with Excel Analysis- Secondary

Course Content

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

Course Objectives

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

Age

Secondary


Booking Details

Training courses

Training courses & Conferences

Filter by:
Training Course

SIMS School Standard Reporting 11 June 2019

An introduction to the report designing process in SIMS with the objective to extract useful information from the pupil database in a variety of formats. This course will give you a clear understanding of how reports are produced in SIMS.

Training Course

SIMS – Alternative to Pupil Tracker (SPTO) AM

Capita's school improvement expert, Stephen Long, will be discussing the draft Ofsted Education Inspection Framework and its implications for schools.

Training Course

SIMS - Alternative to pupil tracker (SPTO) PM

Capita's school improvement expert, Stephen Long, will be discussing the draft Ofsted Education Inspection Framework and its implications for schools.

Training Course

FMS6 Advanced User Training- 13 June 2019

Staying on top of your finances can be a complex task for busy schools. With One Education FMS6 advanced user training you can get to grips with your day to day financial management. This training provides you with a comprehensive step-by-step guide through the financial management areas of the FMS6 systems supported by experienced professionals.

Feeling a little unsure? Try our FMS6 User training to get you started or as a refresher.

Training Course

Advanced Reporting with Excel Analysis- Secondary 13 June 2019

This course explores the use of the reporting functionality to extract data and the use of Excel to analyse this data (Secondary schools).

Training Course

Safeguarding Training for Designated Safeguarding Leads 14 June 2019

This essential training for all designated safeguarding leads will refresh your knowledge of how to recognise and respond to concerns and disclosures of abuse.

Training Course

Pupil Premium & SIMS 18 June 2019

Explore the process of importing data from Key to Success website and maintaining Pupil Premium data in SIMS.

Training Course

School Finance Summer Event 19 June 2019

The school finance termly update meeting for Summer. Free to SLA customers.