Using Excel to Analyse Academic and Administration Data
22/11/2019 - Webinar
Online 09.30-11.30 United Kingdom
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.
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.
- 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.
The fee for this webinar is £75 plus VAT per delegate. Please complete the booking form below.