Level curriculum

Level 3: Lookups and Data Cleanup

Use XLOOKUP and VLOOKUP plus text and date functions to work with real data.

1 course
60 modules
240 lessons

Courses in this level

1 of 1 course

Level 3Excel Lookup Functions & Data Cleaning

Master Microsoft Excel 365 & 2024 Lookup Functions and Data Cleaning: VLOOKUP, XLOOKUP, INDEX+MATCH, Dynamic Arrays (FILTER, UNIQUE, SORT), Text Sanitization, Power Query ETL, and Enterprise Reconciliations.

₹599

60 modules240 lessons

Show 60 modules

Module 1: Lookup Functions ka Introduction4 lessons

Module 2: Lookup Data ki Preparation

4 lessons

Module 3: VLOOKUP Basics4 lessons

Module 4: VLOOKUP Advanced4 lessons

Module 5: HLOOKUP4 lessons

Module 6: LOOKUP Function4 lessons

Module 7: MATCH Function4 lessons

Module 8: INDEX Function4 lessons

Module 9: INDEX + MATCH4 lessons

Module 10: Lookup Troubleshooting4 lessons

Module 11: XLOOKUP Fundamentals4 lessons

Module 12: XLOOKUP Advanced4 lessons

Module 13: XLOOKUP with Multiple Columns4 lessons

Module 14: Two-Way Lookup4 lessons

Module 15: Multiple Criteria Lookup4 lessons

Module 16: XMATCH Function4 lessons

Module 17: FILTER Function4 lessons

Module 18: UNIQUE and SORT with Lookups4 lessons

Module 19: Approximate and Range Lookups4 lessons

Module 20: Lookup Formula Error Handling4 lessons

Module 21: Wildcard and Partial Text Lookup4 lessons

Module 22: Case-Sensitive Lookup4 lessons

Module 23: First Match, Last Match and Duplicate Keys4 lessons

Module 24: Lookup Across Multiple Sheets4 lessons

Module 25: Lookup Across Workbooks4 lessons

Module 26: Dynamic Lookup Reports4 lessons

Module 27: Lookup + SUMIFS and COUNTIFS4 lessons

Module 28: Lookup + Date and Time4 lessons

Module 29: Lookup Performance Optimization4 lessons

Module 30: Professional Lookup Project4 lessons

Module 31: Data Cleaning ka Introduction4 lessons

Module 32: Data Profiling and Audit4 lessons

Module 33: TRIM, CLEAN and Whitespace Removal4 lessons

Module 34: Text Standardization4 lessons

Module 35: FIND, SEARCH, LEFT, RIGHT, MID4 lessons

Module 36: TEXTSPLIT, TEXTBEFORE and TEXTAFTER4 lessons

Module 37: SUBSTITUTE and REPLACE4 lessons

Module 38: Flash Fill and Text to Columns4 lessons

Module 39: Find and Replace4 lessons

Module 40: Remove Duplicates and Unique Records4 lessons

Module 41: Blank and Missing Values4 lessons

Module 42: Numbers Stored as Text4 lessons

Module 43: Date and Time Cleaning4 lessons

Module 44: Data Type and Format Standardization4 lessons

Module 45: Data Validation and Rule Checks4 lessons

Module 46: Outlier and Anomaly Detection4 lessons

Module 47: Inconsistent Categories and Mapping Tables4 lessons

Module 48: Reconciliation and Data Integrity4 lessons

Module 49: Power Query for Data Cleaning4 lessons

Module 50: Advanced Power Query Cleaning4 lessons

Module 51: Sales Data Cleaning Project4 lessons

Module 52: Employee Master Data Project4 lessons

Module 53: Product and Inventory Project4 lessons

Module 54: Customer Data Cleaning4 lessons

Module 55: Finance and Expense Data4 lessons

Module 56: Multi-File Data Cleaning4 lessons

Module 57: Automated Lookup and Cleanup Template4 lessons

Module 58: End-to-End Business Project4 lessons

Module 59: Testing, Troubleshooting and Documentation4 lessons

Module 60: Final Assessment and Capstone4 lessons

Clear all filters

Excel Lookup Functions & Data Cleaning: Complete Basic to Advanced (Hinglish)

Open course