Excel & Business Intelligence

31 Lessons

Mastering the Excel FIND Function: Find Text with Precision

31 Lessons

Getting to Know Excel's LEN Function

31 Lessons

Mastering Excel's REPLACE Function for String Manipulation

31 Lessons

Mastering the TRIM Function in Excel for Cleaner Data

27 Lessons

Mastering Excel's MID Function: Extracting Substrings from the Middle

27 Lessons

Mastering String Manipulation in Excel: The RIGHT Function

27 Lessons

Mastering String Manipulation in Excel using the LEFT Function

27 Lessons

Mastering Excel: CONCATENATE Function and Ampersand Operator

27 Lessons

Mastering Excel Text Functions: A Complete Guide

27 Lessons

Find Closest Match Using Excel's INDEX and MATCH Functions

27 Lessons

Mastering Left Lookups with Excel's INDEX and MATCH Functions

27 Lessons

Mastering Case-Sensitive Lookups in Excel with INDEX, MATCH, and EXACT Functions

27 Lessons

Unlocking Excel's Potential: Master INDEX and MATCH as a VLOOKUP Alternative

27 Lessons

Mastering the MATCH Function in Excel

27 Lessons

Unlocking the Power of the INDEX Function in Excel

27 Lessons

Overcome VLOOKUP and HLOOKUP Limitations with INDEX and MATCH in Excel

27 Lessons

Mastering HLOOKUP in Excel: A Comprehensive Guide

27 Lessons

Mastering Excel's VLOOKUP: A Comprehensive Guide