Microsoft Excel Lookup and Reference Functions
Lookup and Reference Functions
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.
Course Skill Level
10 Students (max)
½ Day Training Course
Upcoming Public Courses
Working with Range Names
- Naming Ranges
- Navigating with Range Names
- Using Range Names in Formulas
- Modifying Range Names
- Using the Choose Function
- Using Lookup Functions
Index and Match Functions
- Using Index
- Using Match
- Using Index and Match Together
Learn Today Face to Face Online with Keystroke Learning
Learn with Keystroke Learning
Our training approach is professional yet friendly, motivating participants to learn quickly and easily.
When you complete our training course, you will be ready to apply your new skills right away.