Unit 1: Excel Basics and Formula Syntax
Unit 2: Basic Functions: Math, Stats, and Counting
Unit 3: Conditional Logic with IF Statements
Unit 4: Cell Referencing Techniques
Unit 5: Data Lookups with VLOOKUP and HLOOKUP
Excel Formulas: From Fundamentals to Advanced Techniques
Master Excel formulas from basic arithmetic to advanced array techniques, unlocking powerful data analysis and automation capabilities.
Unit 1: Extracting Text with LEFT, RIGHT, MID
Unit 2: Finding Text with FIND and SEARCH
Unit 3: Replacing Text with SUBSTITUTE and REPLACE
Unit 4: Combining Text with CONCATENATE and TEXTJOIN
Unit 5: Cleaning Data: Removing Unwanted Characters
Unit 1: Advanced Lookups with INDEX and MATCH
Unit 2: Creating Dynamic Ranges with OFFSET
Unit 3: Complex Conditional Logic
Unit 4: Analyzing Dates and Times
Unit 5: Troubleshooting Formula Errors
Unit 1: Understanding Array Formulas
Unit 2: Array Formulas for Data Manipulation
Unit 3: Financial Modeling with Excel Formulas