Curriculum
Learn to use Microsoft Excel like a Pro – Advanced Level
Excel Advanced
0/2
Working with Multiple Workbooks
0/4
-
03.Tracing PrecedentsThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
02:31 -
04. Tracing DependantsSorry, this lesson is currently locked. You need to complete "03.Tracing Precedents" before accessing it.
01:18
-
05. Watch WindowSorry, this lesson is currently locked. You need to complete "03.Tracing Precedents" before accessing it.
02:19
-
06. Show FormulaSorry, this lesson is currently locked. You need to complete "03.Tracing Precedents" before accessing it.
03:11
Protecting Worksheets and Workbooks
0/3
-
07. Protecting Cells in WorksheetsThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
04:37
-
08. Protecting the Workbook StructureSorry, this lesson is currently locked. You need to complete "07. Protecting Cells in Worksheets" before accessing it.
02:34
-
09. Encryption with PasswordsSorry, this lesson is currently locked. You need to complete "07. Protecting Cells in Worksheets" before accessing it.
02:52
Conditional Formulas
0/7
-
10. Name RangesThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
05:56
-
11. Simple IF FunctionSorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
05:44
-
12. IF, ANDSorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
03:31
-
13. IF, ORSorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
03:30
-
14. Nested FormulaSorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
04:03
-
15. CountIF and CountIF'sSorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
05:34
-
16. SumIF and SumIF'sSorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
03:15
Advanced Function
0/8
-
17. Advanced VLookUpThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
04:16
-
18. IF and IS Error part. 1Sorry, this lesson is currently locked. You need to complete "17. Advanced VLookUp" before accessing it.
03:10
-
19. IF and IS Error part.2Sorry, this lesson is currently locked. You need to complete "17. Advanced VLookUp" before accessing it.
04:07
-
20. Advanced Index MatchSorry, this lesson is currently locked. You need to complete "17. Advanced VLookUp" before accessing it.
02:39
-
21. Dates part. 1Sorry, this lesson is currently locked. You need to complete "17. Advanced VLookUp" before accessing it.
05:20
-
22. Dates part. 2Sorry, this lesson is currently locked. You need to complete "17. Advanced VLookUp" before accessing it.
03:34
-
23. Replace and Substitute part. 1This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
03:23
-
24. Replace and Substitute part. 2This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
04:51
Text and Based Functions
0/5
-
25. Left, Right and Mid FunctionThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
02:30
-
26. Search FunctionThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
02:43
-
27. Concatenate and SearchThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
03:52
-
28. Indirect - StaticThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
02:31
-
29. Indirect- DynamicThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
04:36
What IF Tools
0/4
-
30. Goal SeekThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
02:41
-
31. Data TablesThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
01:59
-
32. ScenariosThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
04:47
-
33. SolverThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
04:25
Video lesson
