Excel Advanced
Building a Mini Dashboard
Excel Advanced
0%
Completed
Shortcut Keys
Advanced Shortcut Keys
Video - 2:58 mins
Working with Multiple Workbooks
Tracing Precedents
Video - 2:31 mins
Tracing Dependants
Video - 00:1:19 mins
Watch Window
Video - 00:2:19 mins
Show Formulas
Video - 00:3:12 mins
Protecting Worksheets and Workbooks
Protecting Cells in a Worksheet
Video - 00:4:37 mins
Protecting the Workbook Structure
Video - 00:2:34 mins
Encryption with Passwords
Video - 00:2:53 mins
Conditional Formulas
Name Ranges
Video - 00:5:56 mins
Simple IF Function
Video - 00:5:44 mins
IF, AND
Video - 00:3:32 mins
IF, OR
Video - 00:3:30 mins
Nested Formulas
Video - 00:4:3 mins
CountIF and CountIFs
Video - 00:5:35 mins
SumIF and SumIFs
Video - 00:3:15 mins
Advanced Functions
Advanced VLookUp
Video - 00:4:17 mins
IF and IS Error Part 1
Video - 00:3:1 mins
IF and IS Error Part 2
Video - 00:4:7 mins
Advanced Index Match
Video - 00:2:40 mins
Dates Part 1
Video - 00:5:20 mins
Dates Part 2
Video - 00:3:44 mins
Replace and Substitute Part 1
Video - 00:3:24 mins
Replace and Substitute Part 2
Video - 00:4:51 mins
Text Based Functions
Left, Right and Mid Function
Video - 00:2:30 mins
Search Function
Video - 00:2:43 mins
Concatenate and Search
Video - 00:3:52 mins
Indirect Static
Video - 00:2:31 mins
Indirect Dynamic
Video - 00:4:35 mins
What IF Tools
Goal Seek
Video - 00:2:41 mins
Data Tables
Video - 00:1:59 mins
Scenarios
Video - 00:4:46 mins
Solver
Video - 00:4:25 mins
Excel Advanced Conclusion
Advanced Conclusion
Video - 00:1:40 mins
Bonus # 1 – Advanced Pivot Tables
Building a Mini Dashboard
Video - 00:24:00 mins
More
Announcements
Reviews
Course Info
Scroll to Top