Microsoft Office & 365 Apps
Excel - Plain and Simple Lookups
A one-hour live class on named ranges and simple lookups that make formulas easier to read and data easier to find.
1 hourIntermediate1 modules
About this course
A one-hour live class on named ranges and simple lookups that make formulas easier to read and data easier to find.
Curriculum
1 modules
- Make functions and formulas easier to read with named and data easier to access by defining and using range names.
- Find and return specific values in a dataset with the power of VLOOKUP. One of the most used tools in higher levels of excel
- Find values from differently structured datasets where VLOOKUP might not work.
- Use VLOOKUP and HLOOKUP functions with true to find an approximate match.
- Index and match - learn how to set up and use the powerful lookup function index and learn about the differences from VLOOKUP.
Who it's for
Excel users starting with lookups.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Microsoft Office & 365 Apps →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Intermediate
55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Advanced
55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →Intermediate
55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Intermediate
Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.