Advanced filters | Hunting Training

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Excel 2007 Advanced: Master Advanced Excel skills in a few hours. Begin now!

Introduction

Welcome Excel 2007 Advanced (2:46)
What you need to know for this course (1:21)

Styles

Highlight cells rules part 1 (4:35)
Highlight cells rules part 2 (3:22)
Top and bottom rules (4:12)
Data bars (1:39)
Color scales (1:16)
Icon sets (1:46)
Creating new rules part 1 (3:40)
Creating new rules part 2 (4:29)

Working with data

Working with external data (5:46)
Advanced filters (4:22)
Data validation numbers part 1 (3:40)
Data validation numbers part 2 (6:11)
Data validation lists (2:42)
Data validation other (3:42)
Consolidate data (6:45)
What if analysis goal seek (3:58)
What if analysis scenario manager part 1 (3:14)
What if analysis scenario manager part 2 (5:19)
What if analysis data table (4:00)
Working with outlines group (6:05)
Working with outlines subtotal (3:22)

The famous IF function

What is the if function (2:26)
Working with numbers (4:07)
Working with text (2:22)
Multiple statements (5:28)

Vlookup function

What is a lookup function (1:30)
Rules when using vlookup (3:38)
Creating a vlookup formula (4:14)
Testing the vlookup results (3:07)
Handling vlookup errors (6:33)

Other common functions

Text function (2:06)
Len function (2:17)
Concatenate function (4:45)
Date function (1:30)

Pivot tables

About pivot tables (3:08)
Rules when creating pivot tables (2:01)
Creating a pivot table part 1 (5:15)
Creating a pivot table part 2 (3:55)
Updating data on a pivot table (2:12)
Checking results given by a pivot table (1:48)

Charts

Different chart types part 1 (3:40)
Different chart types part 2 (3:52)
Creating pivot charts (4:47)

Protecting your work

Why protect your workbook (1:53)
Preparing for protection (3:07)
Protecting a worksheet (4:14)
Protecting a workbook (6:02)
Unprotecting worksheets and workbooks (5:28)

Introducing macros

What is a macro (1:29)
Before recording a macro (3:12)
Recording a macro part 1 (4:53)
Recording a macro part 2 (4:49)
Editing a macro (5:41)

Bonus

Expanding the formula bar (1:48)
Summing up named ranges (3:09)

Conclusion

Goodbye Excel 2007 advanced (0:47)
Please rate this course

Teach online with

Advanced filters

Complete and Continue