excel-07-lookup

Overview:

This module is designed to equip learners with the skills needed to efficiently search and retrieve data from tables in Microsoft Excel using powerful lookup functions. These functions are essential for managing large datasets and performing data analysis tasks.

Target Audience:

This module is ideal for:

Beginners with little to no Excel experience
Professionals looking to refresh their basic Excel skills
Anyone wanting to improve their productivity with spreadsheets

By the end of this course, you'll be able to:

Understand the purpose and application of lookup functions in Excel.
Use VLOOKUP functions to search and retrieve data from tables.
Implement MATCH and INDEX functions for advanced data retrieval.
Troubleshoot common errors associated with lookup functions.

Topics include:

Use the VLOOKUP function to search for a specific value in table or range and return a corresponding value.
Use the new XLOOKUP function to search for a specific value in table or range and return a corresponding value.
Perform a vertical and horizontal lookup combining the INDEX and Match functions

All Microsoft Excel Modules

Automate Decisions with Logical Functions

Search and Retrieve Data from tables with Lookup Functions

Analyse and Visualise Date with Pivot Tables

Add Automation to Your Workbooks with Macros

Transform Your Data with Power Query

Use AI in Excel to Turbo Charge Your Excel Experience

First Steps in Microsoft Excel

Creating Basic Formulas

Manipulate Data Using Tables

Data Visualisation with Charts

Using Statistical Functions to Analyse Data

Back to Training Courses

Smiling professional man giviing okay gesture and holding a laptop

Contact Us

To find out more about our products and services or to discuss how we can help improve communications and collaboration using Microsoft 365 apps within your organisation, give us a call on the telephone number below or complete the contact form.

01274 024 353