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 Toolbar (2003) / Ribbon (2007) vs format cells
Creating basic and complex formula using the ‘golden rules’ and BODMAS
Understanding and creating ‘absolute’ cell references
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
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.
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.
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 email@example.com
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