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
Goodbye Excel 2007 advanced
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock