| 33. Student Questions Answered/17. Vlookups (Or Any Application.WorksheetFunction) Over Ranges.mp4 | 136.2 MB |
| 33. Student Questions Answered/5. Saving Multiple Sheets To A Single Workbook In A Specific Folder.mp4 | 80.94 MB |
| 18. Student Questions Answered!/11. Data Validation With Dependent Drop downs (Dynamic Named Range Workaround).mp4 | 77.6 MB |
| 26. Workbook Events You Don't Have To Run Code To Have Code Run!/14. WorkSheet Events - BONUS - 4 New Things To Try.mp4 | 77.36 MB |
| 33. Student Questions Answered/13. File Picker, And Report Generator With Intelligent Filing.mp4 | 58.5 MB |
| 18. Student Questions Answered!/12. Using 2 Labels As A Lookup From Drop-downs.mp4 | 55.64 MB |
| 10. Bonus Section Student Questions Answered!/1. Reverse Engineering A Sample Spreadsheet.mp4 | 53.91 MB |
| 3. Start Here - All The Basics/2. The Anatomy Of A Workbook Where Everything Is, And What It Does!.mp4 | 49.57 MB |
| 33. Student Questions Answered/12. Sequential PDF Creation With Pictures.mp4 | 49 MB |
| 14. Project 3 - Named Ranges/7. 3035 - POWER USER - Dynamic Charts.mp4 | 48.61 MB |
| 33. Student Questions Answered/18. Adding A Date Stamp If A Change Has Been Made.mp4 | 47.41 MB |
| 32. Importing Specific Data From Multiple Files/5. The Data Grabber(er).mp4 | 45.96 MB |
| 33. Student Questions Answered/9. Extracting Unique Tables to Unique Sheets From A Big Data Set.mp4 | 44.87 MB |
| 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/39. Arrays - Using An Array As A Data Source For A VLookup.mp4 | 43.59 MB |
| 10. Bonus Section Student Questions Answered!/2. Casing And Text Functions.mp4 | 43.49 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/16. Building Text Strings With A Formula.mp4 | 43.46 MB |
| 14. Project 3 - Named Ranges/8. 3040 - Horizontal Dynamic Named Ranges For Charts.mp4 | 42.61 MB |
| 18. Student Questions Answered!/4. What Is The CHOOSE Function Really Used For.mp4 | 40.53 MB |
| 19. Excel Essentials Level 3 - VBA Programming/1. Why Should I Learn How To Code.mp4 | 39.65 MB |
| 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/9. Adding Pivot Tables (And Another Chart).mp4 | 38.69 MB |
| 18. Student Questions Answered!/2. Calls Text Data 2 - This Time Using Text!.mp4 | 38.65 MB |
| 33. Student Questions Answered/7. Extracting Specific Data From A Big File, To A Bunch Of Little Ones.mp4 | 38.11 MB |
| 18. Student Questions Answered!/10. Data Validation With Dependent Drop-downs.mp4 | 37.38 MB |
| 18. Student Questions Answered!/6. Dynamic Charting From A Drop Down.mp4 | 37.34 MB |
| 21. Introducing Your Personal Built In Translator...the Macro Recorder/5. With And End With.mp4 | 37.06 MB |
| 21. Introducing Your Personal Built In Translator...the Macro Recorder/10. Why You Can't Get By With Just Recording Macros.mp4 | 35.85 MB |
| 21. Introducing Your Personal Built In Translator...the Macro Recorder/1. Introducing The Visual Basic Editor, & Recording Our First Macro.mp4 | 35.36 MB |
| 8. Bonus Section - The Keyboard Shortcuts/2. Bonus 2 Keyboard Shortcuts.mp4 | 35.35 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/9. Creating A Template From An Image.mp4 | 34.71 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/19. Auto-populating Check Boxes.mp4 | 34.15 MB |
| 33. Student Questions Answered/16. Gantt Charts...With A Little More Sophistication!.mp4 | 33.18 MB |
| 33. Student Questions Answered/10. Protecting Specific Cells and Data Validation.mp4 | 32.56 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.mp4 | 32.47 MB |
| 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/8. Adding A Chart As A Picture.mp4 | 31.25 MB |
| 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/5. Adding A Slide With A Logo And Text.mp4 | 30.2 MB |
| 33. Student Questions Answered/4. Saving An Individual Sheet To A Specific Folder.mp4 | 29.72 MB |
| 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/5. Gantt Charts Using The Built In Charting Tools.mp4 | 29.58 MB |
| 29. Bonus Section eMail Automation...Why WRITE emails!/3. Deconstructing How We Capture All The Data.mp4 | 29.57 MB |
| 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/3. Multiple Logical Tests At Once Using AND.mp4 | 29.5 MB |
| 33. Student Questions Answered/15. Finding Updated Values In One Workbook, And Adding Them To Another Workbook.mp4 | 29.37 MB |
| 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/18. A Tick Box Exercise (Of Sorts).mp4 | 28.22 MB |
| 13. Project 2 - Building A Database With Excel/16. POWER USER - Dealing With Inconsistencies In User Entry.mp4 | 28.16 MB |
| 13. Project 2 - Building A Database With Excel/25. Putting It All Together.mp4 | 28.06 MB |
| 24. Automating All Your Reports!/14. Adding The Commentary - Building Strings Dynamically At Runtime.mp4 | 28 MB |
| 17. Bonus Section - Just For Fun/1. How I Created Randomly Generated License Plate Numbers!.mp4 | 27.77 MB |
| 21. Introducing Your Personal Built In Translator...the Macro Recorder/6. Streamlining You Code, Or, Get Rid Of What You Don't Need.mp4 | 26.94 MB |
| 33. Student Questions Answered/14. Help! My File Has Got HUGE!.mp4 | 26.28 MB |
| 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/38. Arrays - Extracting Useful Data Based On User Input.mp4 | 26.05 MB |
| 21. Introducing Your Personal Built In Translator...the Macro Recorder/4. Stepping Out. Well, In Actually! - Debugging Made Easy ).mp4 | 25.83 MB |
| 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/13. Looping With While...Wend.mp4 | 25.81 MB |