Filename | Size |
| 1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/1. Intro To Level 1.mp4 | 12.3 MB |
| 1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/1. Intro To Level 1.vtt | 3.4 KB |
| 1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/2. Before We Start...Viewing The Lectures, And Following Along On A Single Screen.mp4 | 9.5 MB |
| 1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/2. Before We Start...Viewing The Lectures, And Following Along On A Single Screen.vtt | 4.4 KB |
| 10. Bonus Section Student Questions Answered!/1. Reverse Engineering A Sample Spreadsheet.mp4 | 53.9 MB |
| 10. Bonus Section Student Questions Answered!/1. Reverse Engineering A Sample Spreadsheet.vtt | 22.9 KB |
| 10. Bonus Section Student Questions Answered!/2. Casing And Text Functions.mp4 | 43.5 MB |
| 10. Bonus Section Student Questions Answered!/2. Casing And Text Functions.vtt | 7.9 KB |
| 10. Bonus Section Student Questions Answered!/2.1 Casing.xlsx.xlsx | 9.6 KB |
| 11. Excel Essentials Level 2 - IntermediateAdvanced/1. Intro To Level 2.mp4 | 8.9 MB |
| 11. Excel Essentials Level 2 - IntermediateAdvanced/1. Intro To Level 2.vtt | 2.4 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/1. Proof Of Concept.mp4 | 16.3 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/1. Proof Of Concept.vtt | 6 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/1.1 Time Sheet & Expenses Master.xlsx.xlsx | 152.8 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/10. Importing A Template From An Existing Excel File.mp4 | 13.1 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/10. Importing A Template From An Existing Excel File.vtt | 2.9 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/10.1 Expenses Form.xlsx.xlsx | 20.7 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/11. Converting Time To A Decimal.mp4 | 16.2 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/11. Converting Time To A Decimal.vtt | 6.9 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/12. A Little Bit Of Simple Data Entry.mp4 | 9.1 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/12. A Little Bit Of Simple Data Entry.vtt | 3.7 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/13. Simple Conditional Formatting For A Cleaner View.mp4 | 15.7 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/13. Simple Conditional Formatting For A Cleaner View.vtt | 5.6 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/14. Calculating Time Out Of House Using Travel Time.mp4 | 16.7 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/14. Calculating Time Out Of House Using Travel Time.vtt | 5.3 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/15. Simple Logical Testing And Nested Logical Testing.mp4 | 22.6 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/15. Simple Logical Testing And Nested Logical Testing.vtt | 10 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/16. Building Text Strings With A Formula.mp4 | 43.5 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/16. Building Text Strings With A Formula.vtt | 14.1 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/17. Before We Move On...Accessing The Developer Ribbon.mp4 | 4.8 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/17. Before We Move On...Accessing The Developer Ribbon.vtt | 1.1 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/18. A Tick Box Exercise (Of Sorts).mp4 | 28.2 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/18. A Tick Box Exercise (Of Sorts).vtt | 9.4 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/19. Auto-populating Check Boxes.mp4 | 34.2 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/19. Auto-populating Check Boxes.vtt | 14.2 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/2. Planning Ahead.mp4 | 4.7 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/2. Planning Ahead.vtt | 2.9 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/20. PRACTICE EXERCISE 1 - Time To Add A New Entry.mp4 | 6.3 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/20. PRACTICE EXERCISE 1 - Time To Add A New Entry.vtt | 2 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/21. Defining A Working Area, And Protecting Your Work.mp4 | 16.2 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/21. Defining A Working Area, And Protecting Your Work.vtt | 6 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/22. PRACTICE EXERCISE 2 - Set Up A Working Area, And Limit User Entry.mp4 | 3.8 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/22. PRACTICE EXERCISE 2 - Set Up A Working Area, And Limit User Entry.vtt | 1.5 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/3. Creating Our Data Entry Screen.mp4 | 9.5 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/3. Creating Our Data Entry Screen.vtt | 4.6 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/4. (Custom) Formatting Dates And Time.mp4 | 13.1 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/4. (Custom) Formatting Dates And Time.vtt | 7.1 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/5. Simple Calculations With Time.mp4 | 5 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/5. Simple Calculations With Time.vtt | 3.3 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/6. More (Useful) Calculations With Time.mp4 | 19.5 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/6. More (Useful) Calculations With Time.vtt | 9.9 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/7. It's About Time (And Dates!).mp4 | 16.4 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/7. It's About Time (And Dates!).vtt | 9 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/7.1 It's About Time.xlsx.xlsx | 10.3 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/8. Adding Time.mp4 | 8.9 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/8. Adding Time.vtt | 4.1 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/9. Creating A Template From An Image.mp4 | 34.7 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/9. Creating A Template From An Image.vtt | 14.3 KB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/9.1 Time Sheet Blank.jpg.jpg | 122.7 KB |
| 13. Project 2 - Building A Database With Excel/1. Simple VLOOKUPs.mp4 | 8.6 MB |
| 13. Project 2 - Building A Database With Excel/1. Simple VLOOKUPs.vtt | 5.4 KB |
| 13. Project 2 - Building A Database With Excel/1.1 Simple VLOOKUPS.xlsx.xlsx | 9.3 KB |
| 13. Project 2 - Building A Database With Excel/10. Data Arrays Don't Have To Start At A!.mp4 | 9.6 MB |
| 13. Project 2 - Building A Database With Excel/10. Data Arrays Don't Have To Start At A!.vtt | 3.3 KB |
| 13. Project 2 - Building A Database With Excel/11. Some Common Reasons VLook-Ups Fail.mp4 | 14 MB |
| 13. Project 2 - Building A Database With Excel/11. Some Common Reasons VLook-Ups Fail.vtt | 7.4 KB |
| 13. Project 2 - Building A Database With Excel/12. One Inherent Flaw In Vlook Up.mp4 | 3.6 MB |
| 13. Project 2 - Building A Database With Excel/12. One Inherent Flaw In Vlook Up.vtt | 1.3 KB |
| 13. Project 2 - Building A Database With Excel/13. POWER USER - A Breakdown Of Looking Up Backwards.mp4 | 13.2 MB |
| 13. Project 2 - Building A Database With Excel/13. POWER USER - A Breakdown Of Looking Up Backwards.vtt | 8.1 KB |
| 13. Project 2 - Building A Database With Excel/14. The Other Way Of Looking Up Backwards.mp4 | 14.2 MB |
| 13. Project 2 - Building A Database With Excel/14. The Other Way Of Looking Up Backwards.vtt | 7.7 KB |
| 13. Project 2 - Building A Database With Excel/15. Backwards Look-Ups In Action.mp4 | 11.5 MB |
| 13. Project 2 - Building A Database With Excel/15. Backwards Look-Ups In Action.vtt | 4.7 KB |
| 13. Project 2 - Building A Database With Excel/15.1 Looking Up Backwards.xlsx.xlsx | 10.4 KB |
| 13. Project 2 - Building A Database With Excel/16. POWER USER - Dealing With Inconsistencies In User Entry.mp4 | 28.2 MB |
| 13. Project 2 - Building A Database With Excel/16. POWER USER - Dealing With Inconsistencies In User Entry.vtt | 9.6 KB |
| 13. Project 2 - Building A Database With Excel/17. POWER USER - Fuzzy Vlook-Ups.mp4 | 10.4 MB |
| 13. Project 2 - Building A Database With Excel/17. POWER USER - Fuzzy Vlook-Ups.vtt | 4.1 KB |
| 13. Project 2 - Building A Database With Excel/17.1 Fuzzy VLook-Ups.xlsx.xlsx | 10.5 KB |
| 13. Project 2 - Building A Database With Excel/18. POWER USER - Vlook-Ups With Multiple Inputs.mp4 | 25.8 MB |
| 13. Project 2 - Building A Database With Excel/18. POWER USER - Vlook-Ups With Multiple Inputs.vtt | 10.9 KB |
| 13. Project 2 - Building A Database With Excel/18.1 Lookup Up From Multiple Inputs.xlsx.xlsx | 20.6 KB |
| 13. Project 2 - Building A Database With Excel/19. POWER USER - Looking Up Multiple Inputs Using An Array Formula.mp4 | 14.7 MB |
| 13. Project 2 - Building A Database With Excel/19. POWER USER - Looking Up Multiple Inputs Using An Array Formula.vtt | 5.6 KB |
| 13. Project 2 - Building A Database With Excel/2. Step 1 - Get Some Data In, And Split It.mp4 | 17.5 MB |
| 13. Project 2 - Building A Database With Excel/2. Step 1 - Get Some Data In, And Split It.vtt | 4.8 KB |
| 13. Project 2 - Building A Database With Excel/2.1 HR File.xlsx.xlsx | 24.3 KB |
| 13. Project 2 - Building A Database With Excel/2.2 HR Database Master.xlsx.xlsx | 61.4 KB |
| 13. Project 2 - Building A Database With Excel/20. VLOOKUPs Brother...HLOOKUP.mp4 | 12.3 MB |
| 13. Project 2 - Building A Database With Excel/20. VLOOKUPs Brother...HLOOKUP.vtt | 5.3 KB |
| 13. Project 2 - Building A Database With Excel/21. POWER USER - The Holy Grail - How To Return Multiple Values From A Single Look U.mp4 | 32.5 MB |
| 13. Project 2 - Building A Database With Excel/21. POWER USER - The Holy Grail - How To Return Multiple Values From A Single Look U.vtt | 15.6 KB |
| 13. Project 2 - Building A Database With Excel/21.1 Returning Multiple Results.xlsx.xlsx | 14 KB |
| 13. Project 2 - Building A Database With Excel/22. What To Look For When THAT Formula Didn't Work.mp4 | 10.2 MB |
| 13. Project 2 - Building A Database With Excel/22. What To Look For When THAT Formula Didn't Work.vtt | 4.5 KB |
| 13. Project 2 - Building A Database With Excel/23. The Fastest Way To Modify Your Column Numbers.mp4 | 16.1 MB |
| 13. Project 2 - Building A Database With Excel/23. The Fastest Way To Modify Your Column Numbers.vtt | 8.8 KB |
| 13. Project 2 - Building A Database With Excel/24. POWER USER - Vlook-Ups With Moving Columns.mp4 | 7.5 MB |