Menu

Using Excel to Analyse Academic and Administration Data

22/11/2019 - Webinar

Available Sessions
Online 09.30-11.30 United Kingdom

Event Summary

The webinar is designed to familiarise users with the Microsoft Query tool to extract information from the Administration and Academic modules. It will include hints and tips that will enable users to create and maintain linked Excel spreadsheets enabling users to refresh the data for live up to date analysis.

Overview

We understand the importance and pressure placed on schools to analyse admissions, academic and marketing data in many formats. In addition to all the standard reports that are available to the user we are aware of schools’ requirements to streamline both internal and external reporting. We will also cover the use of Pivot tables and Pivot Charts in Excel, no previous experience in these areas of Excel are required however.

Agenda

  • Data security overview
  • Setting up ODBC data links in Excel
  • Creating new Microsoft Queries
  • Refining your data searches using criteria filters, sorting and parameters
  • Using multiple tables defining links between tables
  • Using pivot tables and charts

Who the webinar is aimed at

Users of the administration and academic modules responsible for data analysis. This includes members of the marketing, admissions and academic teams.

Prerequisites

A basic understanding of the Admin and Academic modules plus a working knowledge of Excel is a benefit but not essential.

Booking

The fee for this webinar is £75 plus VAT per delegate. Please complete the booking form below.

Required *

Book Online

Please submit a separate form for each delegate

Using Excel to Analyse Academic and Administration Data
Webinar
22/11/2019
I have read and accept the terms and conditions*
Get in touch!

We're here to help, get in touch to find out more

Click here or call +44 (0)1458 833 344

WCBS BESA

Cookie Policy

Cookies help us to deliver our service. By using our service, you agree to our use of cookies.

Learn More

Close