Course Content Excel Advanced Resources Excel – Advanced – Course Info 00:00 Excel Advanced Resources 00:00 Section 1 – Excel – Advanced 1 – Excel Advanced Introduction 01:39 2 – Advanced Shortcut Keys 02:57 Section 2 – Working with Multiple Workbooks 3 – Tracing Precedents 02:30 4 – Tracing Dependants 01:18 5 – Watch Window 02:18 6 – Show Formulas 03:11 Section 3 – Protecting Worksheets and Workbooks 7 – Protecting Cells in a Worksheet 04:36 8 – Protecting the Workbook Structure 02:33 9 – Encryption with Passwords 02:52 Section 4 – Conditional Formulas 10 – Name Ranges 05:55 11 – Simple IF Function 05:43 12 – IF, AND 03:31 13 – IF, OR 03:29 14 – Nested Formulas 04:02 15 – CountIF and CountIFs 05:34 16 – SumIF and SumIFs 03:14 Section 5 – Advanced Functions 17 – Advanced VLookUp 04:16 18 – IF and IS Error – Part 1 03:00 19 – IF and IS Error – Part 2 04:06 20 – Advanced Index Match 02:39 21 – Dates – Part 1 05:19 22 – Dates – Part 2 03:43 23 – Replace and Substitute – Part 1 03:23 24 – Replace and Substitute – Part 2 04:50 Section 6 – Text Based Functions 25 – Left, Right and Mid Function 02:29 26 – Search Function 02:43 27 – Concatenate and Search 03:52 28 – Indirect – Static 02:31 29 – Indirect – Dynamic 04:35 Section 7 – What IF Tools 30 – Goal Seek 02:41 31 – Data Tables 01:59 32 – Scenarios 04:46 33 – Solver 04:25 Section 8 – Excel Advanced – Conclusion 34 – Excel Advanced – Conclusion 01:39 Section 9 – Bonus # 1 – Advanced Pivot Tables 35 – Building a Mini Dashboard 23:59