Learners on this half-day Microsoft Excel – Lookup and Reference Functions course will learn about some of the most common tasks in Excel, looking up specific information within data sets. Lookup and Reference functions including Vlookup are used to perform these tasks and you can learn the fundamentals without having to be away from the office for a full day.
The course assumes you have a working knowledge of Excel fundamentals, however, people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.
Participants should have a good understanding of the fundamentals of Microsoft Excel. Ideally you will have completed our Microsoft Excel Introduction training course, or have some prior experience using simple Excel Spreadsheets, including entering and editing data, creating formulas and IF Functions, along with some basic formatting.
There are no upcoming courses at this time.
However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.
Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants.
*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.