HLOOKUPS | Analytified

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Excel Ninjas

Getting Started

Welcome to the Course!
Before You Start

Lesson 1: IF Statements

IF Statements (5:25)

Lesson 2: IFERROR Statements

IFERROR Statements (1:48)

Lesson 3: SUM and COUNT with Conditions

SUM and COUNT with Conditions (2:42)

Lesson 4: VLOOKUP

VLOOKUPS (6:37)

Lesson 5: HLOOKUP

HLOOKUPS (4:37)

Lesson 6: Pivot Tables

Pivot Tables (3:42)

Lesson 7: Using Subtotals and Filters

Using Subtotals and Filters (2:18)

Lesson 8: Conditional Formatting & Color Scales

Conditional Formatting & Color Scales (2:54)

Lesson 9: Removing Duplicates, Text to Columns, and Concatenate

Removing Duplicates, Text-to-Columns, and Concatenate (5:48)

Lesson 10: Using Data Validation Rules

Using Data Validation Rules (2:24)

Teach online with

HLOOKUPS

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock