Using Excel to Analyse Academic and Administration Data
22 November 2019 @ 9:30 am - 11:30 am| £75
The webinar is designed for users of the administration and academic modules responsible for data analysis. This includes members of the marketing, admissions and academic teams. It aims 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 live data for 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 is required.
- 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
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. Once your place has been confirmed, we will send you an invoice for payment.
Our webinars are hosted using Join Me and connection details will be shared with you one week prior to the event.