Advanced Searches and Reports

Become an expert in Vision's Searches and Reports

Make your Vision reporting quicker and easier by taking data out of Vision. This new hands-on course shows you how Vision data can be analysed in Excel using several Excel functions.

This course will be hands on with the delegate having access to a computer or sharing with another staff member.

Who Should Attend?

This course is suitable for those who are tasked to audit and search Vision data. Delegates should already have attended the Vision Searches Parts 1 & 2 as there will be no coverage of searching in Vision apart from extracting the data for use in Excel; no prior knowledge of Excel is required but would be useful.

Pre-requisite

Delegates should have a confident understanding of running Vision searches; anybody who does not have such prior understanding is likely to gain little benefit from this course as Vision searching per se is not covered in this course.

Aims

The aim of this course is to explore the potential of exporting data.

Objectives

By the end of the course the delegates will be able to understand the possibilities and potential of exporting data.

Course Content

The need for analysis and audit of clinical data is an ever increasing requirement from practices. Whilst much of this additional audit requirement can be satisfied with the current search functions in Vision, using applications like Microsoft Excel and Access can provide quick and customisable analysis. This course is designed to show participants some of the functionality of Microsoft Excel which will help practices to achieve efficient and useful reports from their Vision data. It will provide a greater understanding of exporting Vision searches into Microsoft Excel and how best to interpret the imported data:

• Export a search using both DBF and Tab Separated formats
• Explain the difference between both types of Export 
• Set up a workstation ready to import data into Excel 
• Import DBF data using Microsoft Query
• Import data using Tab Separated files
• Move / Copy spreadsheets into a single workbook
• Provide a basic understanding of Microsoft Excel
• Understand and use the VLOOKUP formula
• Know how to Format Cells
• Use Microsoft Excel Filters
• Make use of Pivot Tables
• Create Charts
• Create and run a Macro in Excel

Course Details

This full-day hands-on course runs from 10:00am until 16:00pm. INPS will provide Vision workstations with a maximum of 2 delegates per workstation.

Courses are scheduled throughout the UK, please see the booking form to find your nearest venue.

You might also be interested in...

• Ask the Trainer, a new half-day seminar where you can get answers to all of your Vision-related questions
• Build your own bespoke on-site training package with a Vision Consultancy scheme
• Keep your Vision system in optimum condition with the new Vision Housekeeping seminar
• Gain confidence in Vision reporting with the Intermediate Searches and Reports hands-on course

Terms and conditions for training services.