Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
EXCEL CLEANING & LOGIC
Master data cleaning techniques, Flash Fill, Text-to-Columns, and powerful lookup functions like VLOOKUP and XLOOKUP.
Module Content
Data Cleaning
Using Flash Fill and Text-to-Columns to fix messy data.
Text Functions & Data Quality
Learn essential text cleaning functions (TRIM, PROPER, UPPER, LOWER) and data deduplication (Remove Duplicates).
QUIZ: Data Cleaning
Lookup Functions
Mastering VLOOKUP and the modern XLOOKUP.
QUIZ: Lookup functions
Logical & Math Functions
Master IF, SUMIF, COUNTIF, SUM, and AVERAGE — the essential formula toolkit every data analyst uses daily.
GUIDE: Logical & Math Functions (IF, COUNTIF, AVERAGEIF)
Comprehensive guide covering syntax, logic, and real-world examples for IF, COUNTIF, COUNTIFS, AVERAGEIF, and conditional formulas.
SUBMISSION: Module 2
Download the provided sample dataset and complete the following in Excel: 1) Clean the data using Flash Fill and Text-to-Columns (fix inconsistent formatting, split combined fields). 2) Use VLOOKUP or XLOOKUP to merge data from a reference table. 3) Add a column using IF and nested IF logic to categorize records. Submit your completed .xlsx file.