The Ultimate Excel Programmer Course

1. 11. Userforms - the best thing. EVER/14. BONUS - Search Name and ID.mp4 194.37 MB
2. 11. Userforms - the best thing. EVER/4. New Employee Data Entry Form!.mp4 142.73 MB
3. 11. Userforms - the best thing. EVER/8. Avoid Duplicate Employee ID and other Fun Automation Tricks.mp4 121.67 MB
4. 11. Userforms - the best thing. EVER/13. BONUS - Combobox by Last Name Instead of EmpID.mp4 119.59 MB
5. 1. The Range Object/1. Intro and Course Workbooks download.mp4 76.08 MB
6. 5. Toolbars and Menus/4. View Menu2 - Watch Window, Locals Window and Immediate Window.mp4 64.52 MB
7. 11. Userforms - the best thing. EVER/16. Userform Report with Filters - Part 2.mp4 61.14 MB
8. 6. Super Important Tools and Excel Logic/5. BONUS! - Dynamic Sorting!.mp4 57.57 MB
9. 7. Loops and Report Writing Basics/9. Printable Report Part 2 - Getting Items On Report Sheet.mp4 54.44 MB
10. 6. Super Important Tools and Excel Logic/20. Message Box with Yes and No Buttons.mp4 47.95 MB
11. 5. Toolbars and Menus/2. Edit Menu walkthrough.mp4 44.73 MB
12. 5. Toolbars and Menus/7. Debug Menu (Important!).mp4 42.71 MB
13. 7. Loops and Report Writing Basics/18. The FOR EACH Loop.mp4 41.76 MB
14. 7. Loops and Report Writing Basics/3. Beginning our first Report using Loops.mp4 41.62 MB
15. 7. Loops and Report Writing Basics/8. Our First Printable Report part 1 - Declaring and Setting the Sheets.mp4 39.86 MB
16. 9. WorkBook Events/1. Workbook Open.mp4 39.54 MB
17. 10. Activex Controls on Worksheets/31. BONUS - Manipulating and Using Multiselect Items in a Listbox.mp4 38.96 MB
18. 8. EVENTS Worksheet Events made Easy/12. Change Event with EnableEvents toggle - Avoid endless loop!.mp4 37.93 MB
19. 7. Loops and Report Writing Basics/10. Printable Report Part 3 - Clearing Last Report.mp4 36.13 MB
20. 5. Toolbars and Menus/5. Watch Window Wonders!.mp4 34.11 MB
21. 7. Loops and Report Writing Basics/11. Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.mp4 33.91 MB
22. 7. Loops and Report Writing Basics/2. Fun with our For Next Loop.mp4 33.30 MB
23. 2. Range Properties/9. .FORMULA Property.mp4 31.59 MB
24. 7. Loops and Report Writing Basics/22. Intro to DO LOOPS.mp4 31.34 MB
25. 7. Loops and Report Writing Basics/13. Exercise 07a - Answer.mp4 30.39 MB
26. 8. EVENTS Worksheet Events made Easy/1. Intro to Worksheet Events and Selection_Change.mp4 30.30 MB
27. 11. Userforms - the best thing. EVER/18. Clear out Last Report.mp4 30.29 MB
28. 6. Super Important Tools and Excel Logic/23. Relative Positioning using Offset.mp4 29.22 MB
29. 4. Variables/3. Declaring Variables - Types Demo.mp4 28.15 MB
30. 6. Super Important Tools and Excel Logic/7. Using With and End With.mp4 27.86 MB
31. 7. Loops and Report Writing Basics/17. For Loop Going Backwards using STEP.mp4 27.57 MB
32. 3. The Cells Object/7. Using Range Object with Cells Object.mp4 27.42 MB
33. 7. Loops and Report Writing Basics/19. FOR EACH Loop - Practical Examples.mp4 27.01 MB
34. 8. EVENTS Worksheet Events made Easy/13. Change Event Triggered with Custom Range Using Intersect.mp4 26.74 MB
35. 7. Loops and Report Writing Basics/28. BONUS - Loop Through Multiple Files in a Folder and Scrape Data From Each.mp4 26.48 MB
36. 6. Super Important Tools and Excel Logic/1. Determining the Last Row in your Data Set.mp4 26.44 MB
37. 4. Variables/9. Public and Private Variables.mp4 24.81 MB
38. 7. Loops and Report Writing Basics/6. Add a Button to Open Our Report.mp4 24.51 MB
39. 7. Loops and Report Writing Basics/16. Handling Debug Error When Cancelling InputBox.mp4 24.44 MB
40. 8. EVENTS Worksheet Events made Easy/14. FollowHyperlinks Event.mp4 23.79 MB
41. 5. Toolbars and Menus/8. Run and Tools Menus.mp4 23.47 MB
42. 8. EVENTS Worksheet Events made Easy/15. Final Thoughts on Worksheet Events and Review Other Events.mp4 22.67 MB
43. 5. Toolbars and Menus/3. View Menu walkthrough.mp4 22.46 MB
44. 2. Range Properties/11. FONT.BOLD, UNDERLINE or ITALIC Properties.mp4 22.45 MB
45. 7. Loops and Report Writing Basics/7. Add a Cool Looking Button or Image to Open Report.mp4 22.40 MB
46. 8. EVENTS Worksheet Events made Easy/7. Calculate Event.mp4 21.91 MB
47. 4. Variables/2. Declaring Variables - Variable Types.mp4 21.77 MB
48. 7. Loops and Report Writing Basics/5. Adding InputBox to Our First Report to make it Dynamic.mp4 21.20 MB
49. 8. EVENTS Worksheet Events made Easy/5. BeforeDoubleClick Event - Trigger a Macro when Double Clicking.mp4 20.86 MB
50. 7. Loops and Report Writing Basics/21. Exercise 07b - Answer.mp4 20.09 MB