Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Microsoft Excel
Welcome to Advanced Excel 2016
Welcome to the Course
Why Excel and why modeling (2:13)
Proficient Excel formatting
Let's start from scratch and create a P&L sheet (7:14)
Cell styles allows you to be faster (6:33)
Pasting values, formulas, and formats with Paste Special (2:30)
Formatting Cells Part I - Working with data in Excel (4:47)
Formatting Cells Part II - Customize numbers the way you like (5:12)
Highlight key data with Excel Conditional Formatting (5:40)
Filter by color (1:43)
How to be 3.0x faster than average users
Use multiple screens simultaneously (3:41)
F1 to F12 - Using Excel's function keys (5:30)
How to select visible cells only (2:30)
Grouping Excel rows and columns - The correct way to do it! (4:49)
Working on multiple sheets at the same time (2:06)
Excel mechanics
Find & Replace - Our favourite Excel tool (3:51)
A great way to apply Find & Replace (3:56)
What Are Circular References in Excel (5:05)
Circular References - An example (2:22)
Trace precedents - Display the relationship between formulas and cells (4:50)
Not so simple Excel functions
What is a nested function (3:09)
Advanced Excel functions Index; Match; Index & Match (7:26)
Advanced Excel functions Index, Match, Match (4:59)
Advanced Excel functions Indirect; Vlookup & Indirect (5:52)
Advanced Excel functions Rows; Columns; Vlookup & Columns (5:21)
Advanced Excel functions Vlookup & Match (2:31)
Advanced Excel functions Choose; Vlookup & Choose (3:29)
Advanced Excel functions Offset; Offset & Match (7:11)
Date functions (5:39)
Excel tips & tricks
Excel tips & tricks Part 1 (6:01)
Excel tips & tricks Part 2 (5:46)
Excel tips & tricks Part 3 (6:35)
Excel tips & tricks Part 4 (5:55)
Trace precedents - Display the relationship between formulas and cells
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock