Menu

ODBC passFINANCE Webinar

11/03/2019 - Webinar

Available Sessions
Online 13.30-15.30 United Kingdom

Event Summary

This webinar is designed to familiarise users with Microsoft Query to extract information from the finance modules in the passFINANCE database. It will include hints and tips that will enable users to create and maintain spreadsheets linked to passFINANCE, allowing them to analyse data from one accounting period to another and refresh the data for live up to date information.

Overview

We understand the importance and pressure placed on finance departments to analyse data in a variety of formats with ease over many accounting periods. In addition to all the standard reports that are available in passFINANCE we are aware of schools’ requirements to streamline both internal and external reporting. The course has been designed to concentrate on the passFINANCE modules with exercises from the Nominal, Billing, Purchase, Payroll modules although ODBC (Open Database Connectivity) can be used to extract data from any area of passFINANCE. This webinar will act as a refresher course for some and a learning experience for others.

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

Experienced users of passFINANCE modules responsible for financial reporting.

Prerequisites

A basic understanding of the passFINANCE modules and a working knowledge of Microsoft Excel.

Booking

The fee for this workshop is £75 plus VAT per delegate, please complete the booking form below.

Required *

Book Online

Please submit a separate form for each delegate

ODBC passFINANCE Webinar
Webinar
11/03/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