GP Accounts into Excel Course
GP Accounts into Excel Course

GP Accounts into Excel Course

Availability: Out of stock

£0.00

Selected price: £0.00

Features

Exporting IRIS GP Accounts Data for Manipulation and Analysis Overview

During this one day comprehensive course, you will be introduced to the reporting facilities within the IRIS GP Accounts software and how to export this data in to Microsoft Excel for further data analysis and manipulation. You will be provided with a laptop to use as this is an interactive classroom based course. The training is Continuing Personal or Professional Development (CPD) certified, guaranteeing the quality and helping your further your career.

You will gain knowledge on how to create professional and dynamic spread sheets, create both simple and complex formulas, manipulate and analyse their data in a range of formats including charts and graphs. Finally you will be taught how to present their data in a professional and eye-catching format. 

GPA Budgets and Reporting Exportation
Creating standard and custom reports within IRIS GP Accounts and exporting the data to Microsoft Excel

Formatting
Formatting Toolbar (2003) / Ribbon (2007) vs format cells
Conditional formatting

Formula
Creating basic and complex formula using the ‘golden rules’ and BODMAS
Duplicating formula
Understanding and creating ‘absolute’ cell references

Functions
Formula vs Functions
Creating basic and complex functions, including Sum, Average, Count, Counta, Countif and Sumif
Understanding and using the ‘IF’ statement function
Sorting and Filtering
Using quick and advanced sorting
Using auto filters

Worksheets
Renaming, adding, deleting, moving and copying Worksheets

Introduction to Charts
Creating charts using the chart wizard
Adding, removing and amending chart data
Formatting the chart

Page Set Up and Printing
Headers and Footers
Pages to Fit
Rows to Repeat

Hints and Tips
Throughout the course various “hints and tips” will be discussed to improve overall efficiency and competence within Excel.


Duration

Full day, 9.30am – 4.30pm

Dates and Locations

The course will run during May and June across the country. Contact us for the latest dates and locations.

Classroom prices

The course is only £315+VAT per delegate. This includes lunch, a useful course overview document and a certificate to take away plus the use of the laptop. Spaces are limited to eight delegates to ensure all candidates receive personal attention from the trainer.

Book your place today

As spaces are limited we urge you to book quickly to ensure you don’t miss out.
Please contact us today 0844 815 5660 or email sales@iris.co.uk

What do you think?

‘I just wanted to let you know that I attended the GP Accounts course yesterday, and have to say it was the best training course I’ve been on – Lisa Boyce know the package inside out, and I’ve never come away from a course with so many notes that are all relevant to what I do each day. Enjoyed it, and it was very worthwhile.’
Adele Meers, Montgomery House Surgery

within Microsoft Excel

Location: