Module 1: Lookup Functions ka Introduction
Module 2: Lookup Data ki Preparation
Module 4: VLOOKUP Advanced
Module 6: LOOKUP Function
Module 10: Lookup Troubleshooting
Module 11: XLOOKUP Fundamentals
Module 12: XLOOKUP Advanced
Module 13: XLOOKUP with Multiple Columns
Module 14: Two-Way Lookup
Module 15: Multiple Criteria Lookup
Module 16: XMATCH Function
Module 17: FILTER Function
Module 18: UNIQUE and SORT with Lookups
Module 19: Approximate and Range Lookups
Module 20: Lookup Formula Error Handling
Module 21: Wildcard and Partial Text Lookup
Module 22: Case-Sensitive Lookup
Module 23: First Match, Last Match and Duplicate Keys
Module 24: Lookup Across Multiple Sheets
Module 25: Lookup Across Workbooks
Module 26: Dynamic Lookup Reports
Module 27: Lookup + SUMIFS and COUNTIFS
Module 28: Lookup + Date and Time
Module 29: Lookup Performance Optimization
Module 30: Professional Lookup Project
Module 31: Data Cleaning ka Introduction
Module 32: Data Profiling and Audit
Module 33: TRIM, CLEAN and Whitespace Removal
Module 34: Text Standardization
Module 35: FIND, SEARCH, LEFT, RIGHT, MID
Module 36: TEXTSPLIT, TEXTBEFORE and TEXTAFTER
Module 37: SUBSTITUTE and REPLACE
Module 38: Flash Fill and Text to Columns
Module 39: Find and Replace
Module 40: Remove Duplicates and Unique Records
Module 41: Blank and Missing Values
Module 42: Numbers Stored as Text
Module 43: Date and Time Cleaning
Module 44: Data Type and Format Standardization
Module 45: Data Validation and Rule Checks
Module 46: Outlier and Anomaly Detection
Module 47: Inconsistent Categories and Mapping Tables
Module 48: Reconciliation and Data Integrity
Module 49: Power Query for Data Cleaning
Module 50: Advanced Power Query Cleaning
Module 51: Sales Data Cleaning Project
Module 52: Employee Master Data Project
Module 53: Product and Inventory Project
Module 54: Customer Data Cleaning
Module 55: Finance and Expense Data
Module 56: Multi-File Data Cleaning
Module 57: Automated Lookup and Cleanup Template
Module 58: End-to-End Business Project
Module 59: Testing, Troubleshooting and Documentation
Module 60: Final Assessment and Capstone
