Udemy - Learn Microsoft Excel VBA Macros for Beginners

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Welcome
• 1. Welcome to the course.en_US.srt (2.7 KB)
• 1. Welcome to the course.mp4 (47.0 MB)
• 2. Course materials.html (0.2 KB)
• 2. Course materials_Resource_Microsoft Excel VBA Macros Solution xlsm.xlsm (1.9 MB)
• 2. Course materials_Resource_Microsoft Excel VBA Macros xlsx.xlsx (1.9 MB)
2 - Intro to VBA Coding
• 1. Quiz 1.html (7.9 KB)
• 3. Preparing your workbook for macros.en_US.srt (4.4 KB)
• 3. Preparing your workbook for macros.mp4 (24.0 MB)
• 4. The Developer tab.en_US.srt (4.0 KB)
• 4. The Developer tab.mp4 (13.9 MB)
• 5. VBA project view.en_US.srt (7.9 KB)
• 5. VBA project view.mp4 (46.7 MB)
• 6. Code syntax pt I.en_US.srt (6.6 KB)
• 6. Code syntax pt I.mp4 (48.9 MB)
• 7. Code syntax pt II.en_US.srt (6.1 KB)
• 7. Code syntax pt II.mp4 (47.3 MB)
• 8. Code formatting.en_US.srt (6.9 KB)
• 8. Code formatting.mp4 (44.5 MB)
3 - VBA Code Basics
• 10. Referencing a range.en_US.srt (4.7 KB)
• 10. Referencing a range.mp4 (26.7 MB)
• 11. Clearing a cell's contents.en_US.srt (3.7 KB)
• 11. Clearing a cell's contents.mp4 (20.5 MB)
• 12. Copy and paste method #1.en_US.srt (7.1 KB)
• 12. Copy and paste method #1.mp4 (40.3 MB)
• 13. Copy and paste method #2.en_US.srt (4.1 KB)
• 13. Copy and paste method #2.mp4 (27.0 MB)
• 14. Declaring a variable pt I.en_US.srt (6.4 KB)
• 14. Declaring a variable pt I.mp4 (32.3 MB)
• 15. Declaring a variable pt II.en_US.srt (5.8 KB)
• 15. Declaring a variable pt II.mp4 (39.0 MB)
• 16. Message boxes pt I.en_US.srt (5.2 KB)
• 16. Message boxes pt I.mp4 (32.7 MB)
• 17. Message boxes pt II.en_US.srt (5.8 KB)
• 17. Message boxes pt II.mp4 (42.4 MB)
• 2. Quiz #2.html (5.8 KB)
• 9. Referencing a worksheet.en_US.srt (7.8 KB)
• 9. Referencing a worksheet.mp4 (41.8 MB)
4 - Named Ranges & If Statements
• 18. Naming & referencing a named range.en_US.srt (5.7 KB)
• 18. Naming & referencing a named range.mp4 (39.7 MB)
• 19. Setting a range as a variable.en_US.srt (5.8 KB)
• 19. Setting a range as a variable.mp4 (46.4 MB)
• 20. Finding the last row of data pt I.en_US.srt (7.2 KB)
• 20. Finding the last row of data pt I.mp4 (50.5 MB)
• 21. Finding the last row of data pt II.en_US.srt (2.8 KB)
• 21. Finding the last row of data pt II.mp4 (29.1 MB)
• 22. Offset.en_US.srt (7.4 KB)
• 22. Offset.mp4 (55.6 MB)
• 23. If statements pt I.en_US.srt (9.2 KB)
• 23. If statements pt I.mp4 (52.5 MB)
• 24. If statements pt II.en_US.srt (5.1 KB)
• 24. If statements pt II.mp4 (36.5 MB)
• 3. Quiz #3.html (6.6 KB)
5 - For Next Loops & Making Our Code Dynamic
• 25. For Next loops pt I.en_US.srt (6.8 KB)
• 25. For Next loops pt I.mp4 (28.5 MB)
• 26. For Next loops pt II.en_US.srt (5.4 KB)
• 26. For Next loops pt II.mp4 (43.4 MB)
• 27. Making our code dynamic pt I.en_US.srt (8.3 KB)
• 27. Making our code dynamic pt I.mp4 (58.3 MB)
• 28. Making our code dynamic pt II.en_US.srt (5.1 KB)
• 28. Making our code dynamic pt II.mp4 (34.7 MB)
• 29. Making our code dynamic pt III.en_US.srt (7.6 KB)
• 29. Making our code dynamic pt III.mp4 (52.9 MB)
• 4. Quiz #4.html (6.4 KB)
6 - Recording and Manipulating a Macro
• 30. 3 suggestions for learning VBA code.en_US.srt (8.5 KB)
• 30. 3 suggestions for learning VBA code.mp4 (48.8 MB)
• 31. Recording a macro.en_US.srt (6.7 KB)
• 31. Recording a macro.mp4 (42.9 MB)
• 32. Manipulating a recorded macro pt I.en_US.srt (5.0 KB)
• 32. Manipulating a recorded macro pt I.mp4 (57.8 MB)
• 33. Manipulating a recorded macro pt II.en_US.srt (6.7 KB)
• 33. Manipulating a recorded macro pt II.mp4 (68.6 MB)
• 5. Quiz #5.html (5.9 KB)
7 - Real World Case Study
• 34. Introduction to the case study.en_US.srt (7.0 KB)
• 34. Introduction to the case study.mp4 (39.5 MB)
• 35. Creating a Yes No message box.en_US.srt (7.8 KB)
• 35. Creating a Yes No message box.mp4 (52.4 MB)
• 36. Finding the first and last rows.en_US.srt (4.7 KB)
• 36. Finding the first and last rows.mp4 (36.3 MB)
• 37. Adding For Next loops w an If statement.en_US.srt (7.0 KB)
• 37. Adding For Next loops w an If statement.mp4 (62.6 MB)
• 38. Making our macro more dynamic.en_US.srt (5.9 KB)
• 38. Making our macro more dynamic.mp4 (36.1 MB)
• 39. Repurposing our code pt I.en_US.srt (5.3 KB)
• 39. Repurposing our code pt I.mp4 (41.8 MB)
• 40. Repurposing our code pt II.en_US.srt (5.8 KB)
• 40. Repurposing our code pt II.mp4 (49.1 MB)
• 41. Reviewing what we've learned.en_US.srt (3.6 KB)
• 41. Reviewing what we've learned.mp4 (30.7 MB)
• 6. Quiz #6.html (7.5 KB)
8 - Conclusion
• 42. Wrapping up.en_US.srt (2.5 KB)
• 42. Wrapping up.mp4 (40.5 MB)
• Bonus Resources.txt (0.1 KB)