Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Excel Basics
·
Module 2
Advanced Functions and Data Retrieval
Time and Workday Calculations with DATEDIF and NETWORKDAYS
Calculate time intervals and working days using DATEDIF and NETWORKDAYS.
VLOOKUP: Retrieving Data and Understanding Limitations
Use VLOOKUP to retrieve data from a vertical table and identify its limitations.
3
Advanced Lookups with INDEX & MATCH
Perform lookups using INDEX and MATCH as a flexible alternative to VLOOKUP.
4
XLOOKUP: Modern Two-Way Lookups
Use XLOOKUP for modern and robust two-way data lookups.
Approximate Match for Range-Based Lookups
Apply approximate match lookups for range-based classifications.
6
Error Handling with IFERROR and IFNA
Handle formula errors gracefully using IFERROR and IFNA functions.
7
Named Ranges for Enhanced Formulas
Create and manage named ranges to improve formula readability and maintenance.
Previous module
Excel Formula Fundamentals
Next module
Data Preparation and Cleaning