270,604 recent views

## 19%

started a new career after completing these courses

## 23%

got a tangible career benefit from this course

## 12%

got a pay increase or promotion

#### 100% online

Start instantly and learn at your own schedule.

#### Approx. 25 hours to complete

Suggested: 6 weeks of study, 2-4 hours/week...

#### English

Subtitles: English, Vietnamese, Arabic

### Skills you will gain

Lookup TableMicrosoft Excel VbaData ValidationMicrosoft Excel Macro

## 19%

started a new career after completing these courses

## 23%

got a tangible career benefit from this course

## 12%

got a pay increase or promotion

#### 100% online

Start instantly and learn at your own schedule.

#### Approx. 25 hours to complete

Suggested: 6 weeks of study, 2-4 hours/week...

#### English

Subtitles: English, Vietnamese, Arabic

## Syllabus - What you will learn from this course

Content Rating96%(7,226 ratings)
Week
1

## Week 1

4 hours to complete

## Data Validation

4 hours to complete
8 videos (Total 42 min), 6 readings, 7 quizzes
8 videos
Week 1 Discussion4m
Practice Video: Data Validation6m
Practice Video: Creating Drop-down Lists6m
Practice Video: Using Formulas in Data Validation7m
Practice Video: Working with Data Validation7m
Week 1 Wrap-Up2m
Welcome10m
Course goals and weekly learning objectives10m
Read me before you start: Versions and regions10m
Keyboard Shortcuts, Excel Terminology, and Ninja Tips20m
7 practice exercises
Data Validation14m
Creating Drop-down Lists8m
Using Formulas in Data Validation6m
Working with Data Validation6m
Week 1 Practice Challenge30m
Week 1 Final Assignment30m
Week
2

## Week 2

3 hours to complete

## Conditional Logic

3 hours to complete
8 videos (Total 39 min), 2 readings, 7 quizzes
8 videos
Week 2 Discussion4m
Practice Video: Logical Functions I: IF7m
Practice Video: Logical Functions II: AND, OR5m
Practice Video: Combining Logical Functions I: IF, AND, OR5m
Practice Video: Combining Logical Functions II: Nested IFs5m
Practice Video: Handling Errors: IFERROR, IFNA6m
Week 2 Wrap-Up1m
Keyboard Shortcuts, Excel Terminology, and Ninja Tips20m
7 practice exercises
Logical Functions I: IF8m
Logical Functions II: AND, OR8m
Combining Logical Functions I: IF, AND, OR6m
Combining Logical Functions II: Nested IFs8m
Handling Errors: IFERROR, IFNA4m
Week 2 Practice Challenge30m
Week 2 Final Assignment30m
Week
3

## Week 3

3 hours to complete

## Automating Lookups

3 hours to complete
8 videos (Total 39 min), 2 readings, 7 quizzes
8 videos
Week 3 Discussion4m
Practice Video: Introduction to Lookups: CHOOSE3m
Practice Video: Approximate Matches: Range VLOOKUP5m
Practice Video: Exact Matches: Exact Match VLOOKUP6m
Practice Video: Finding a Position: MATCH7m
Practice Video: Dynamic Lookups: INDEX, MATCH7m
Week 3 Wrap-Up1m
Keyboard Shortcuts, Excel Terminology, and Ninja Tips20m
7 practice exercises
Introduction to Lookups: CHOOSE8m
Approximate Matches: Range VLOOKUP8m
Exact Matches: Exact Match VLOOKUP8m
Finding a Position: MATCH8m
Dynamic Lookups: INDEX, MATCH6m
Week 3 Practice Challenge30m
Week 3 Final Assignment30m
Week
4

## Week 4

3 hours to complete

## Formula Auditing and Protection

3 hours to complete
8 videos (Total 48 min), 2 readings, 7 quizzes
8 videos
Week 4 Discussion3m
Practice Video: Error Checking9m
Practice Video: Formula Calculation Options6m
Practice Video: Trace Precedents and Dependents5m
Practice Video: Evaluate Formula, Watch Window8m
Practice Video: Protecting Workbooks and Worksheets9m
Week 4 Wrap-Up1m
Keyboard Shortcuts, Excel Terminology, and Ninja Tips20m
7 practice exercises
Error Checking8m
Formula Calculation Options8m
Tracing Precedents and Dependents10m
Evaluate Formula, Watch Window6m
Protecting Workbooks and Worksheets6m
Week 4 Practice Challenge30m
Week 4 Final Assignment36m