Booking options
£13.99
£13.99
Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X
On-Demand course
1 hour
All levels
VLOOKUP: Excel Formula Mastery Within 60 minutes, VLOOKUP! provides a thorough tutorial for learning how to use one of Excel's most potent features. The first part of the course introduces Excel VLOOKUP and shows how to use it to create dynamic menus. This ability is necessary for effective Excel data management and retrieval. In the second lesson, participants will learn about wildcard searches and how to use Excel VLOOKUP to handle a variety of data sets with ease. This improves your capacity to deal with different data formats and patterns.
In subsequent modules, learners explore advanced applications of Excel VLOOKUP, such as executing leftward searches and engaging in two-way lookups. These techniques provide a deeper understanding of data manipulation and analysis. Module 05 focuses on comparing lists using Excel VLOOKUP, a critical skill for data validation and reconciliation tasks. The final module imparts valuable tips and tricks, refining your Excel VLOOKUP expertise and ensuring an edge in data handling.
Module 01: Menu Example with Excel Vlookup | |||
▶ | Menu Example with Excel Vlookup | 🕐 00:08:00 | |
Module 02: Wildcard Search with Excel Vlookup | |||
▶ | Wildcard Search with Excel Vlookup | 🕐 00:09:00 | |
Module 03: Looking to the Left with Excel Vlookup | |||
▶ | Looking to the Left with Excel Vlookup | 🕐 00:17:00 | |
Module 04: 2-Way Lookup | |||
▶ | 2-Way Lookup | 🕐 00:14:00 | |
Module 05: Comparing Lists with Excel Vlookup | |||
▶ | Comparing Lists with Excel Vlookup | 🕐 00:03:00 | |
Module 06: Microsoft Excel Vlookup Tips and Tricks | |||
▶ | Microsoft Excel Vlookup Tips and Tricks | 🕐 00:14:00 |
Skill Up presents a rigorous online education experience, helping you obtain industry-relevant skills certified by the world’s...