Course Content
-
Advanced Shortcut Keys
02:58
-
Tracing Precedents
02:31
-
Tracing Dependants
01:19
-
Watch Window
02:19
-
Show Formulas
03:12
-
Protecting Cells in a Worksheet
04:37
-
Protecting the Workbook Structure
02:34
-
Encryption with Passwords
02:53
-
Name Ranges
05:56
-
Simple IF Function
05:44
-
IF, AND
03:32
-
IF, OR
03:30
-
Nested Formulas
04:03
-
CountIF and CountIFs
05:35
-
SumIF and SumIFs
03:15
-
Advanced VLookUp
04:17
-
IF and IS Error Part 1
03:01
-
IF and IS Error Part 2
04:07
-
Advanced Index Match
02:40
-
Dates Part 1
05:20
-
Dates Part 2
03:44
-
Replace and Substitute Part 1
03:24
-
Replace and Substitute Part 2
04:51
-
Left, Right and Mid Function
02:30
-
Search Function
02:43
-
Concatenate and Search
03:52
-
Indirect Static
02:31
-
Indirect Dynamic
04:35
-
Goal Seek
02:41
-
Data Tables
01:59
-
Scenarios
04:46
-
Solver
04:25
-
Advanced Conclusion
01:40
-
Building a Mini Dashboard
24:00
