Menu

Training Calendar

Advanced Excel for Students' Records Administrators

  • Location: Cass Business School
  • Duration: 1 day
  • Software: Excel
  • Level: Introductory
  • Delivered By: Sandro Leidi; James Gallagher
  • Topic: Policy analysis, Statistics
Advanced Excel for Students' Records Administrators

COURSE DATES: 20th February 2018

Do you have to replicate faculty descriptors at the school level, or department descriptors at the student level?
Do you have to aggregate module results at the student level?
Do you have to compute average marks per student for taught modules only?

This one-day training event provides delegates with hands-on experience of analysing student records efficiently by confidently using Excel as a relational database

Who Should Attend?

Administrators in Educational establishments dealing with student records data; those involved in linking tables of students data at different levels and anyone involved in producing returns to the HESA will likely benefit from this course.
Participants are assumed to be able to use Excel formulae, obtain summary figures (counts, totals, percentages) using Excel, and be familiar with the storage of data in lists to enable the use of filters and Pivot Tables.

How You Will Benefit

By the end of the course you will be familiar with basic methods for fast, efficient and dynamic data crunching.

Click here to view the full course agenda

Course Agenda

What Will We Cover?

  • Advantages of named columns, named ranges and named tables
  • Creating one-to-many links with the VLOOKUP function
  • Creating many-to-one links 1: the SUMPRODUCT function for counting and summing
  • Creating many-to-one links 2: the use of ARRAY functions to obtain any summary
  • Supercharging array functions with conditional operations
  • Working with dates.

Software

Practical work will be done in: Excel.

Note: For practical work, participants must bring their own laptop with a fully licensed version of the software.

Terms & Conditions

  • Student registrations: Attendees must provide proof of full time student status at the time of booking to qualify for student registration rate (valid student ID card or authorised letter of enrolment).
  • Additional discounts are available for multiple registrations.
  • Cost includes course materials that will be posted to you prior to the start of the course.
  • Delegates are provided with temporary licences for the software(s) used in the course and will be instructed to download and install the software prior to the start of the course.
  • Payment of course fees required prior to the course start date.
  • Registration closes 5-calendar days prior to the start of the course.

    • 100% fee returned for cancellations made over 28-calendar days prior to start of the course.
    • 50% fee returned for cancellations made 14-calendar days prior to the start of the course.
    • No fee returned for cancellations made less than 14-calendar days prior to the start of the course.
  •  CommercialAcademicStudent
    1 day Course 20th February 2018 (20/02/2018 - 20/02/2018)

All prices exclude VAT or local taxes where applicable.

* Required Fields

£0
- +
Post your comment

Timberlake Consultants