Project Based Course on Excel VBA (Visual Basic for Applications) and Excel Macros
Course Introduction and Overview
1. Welcome to the Course
2. Understanding the Why and How Behind Excel Macros
Project #1: Using Excel’s Macro Recorder Tool
3. Introduction to Project #1 – Inserting and Formatting Text
4. Project #1 – Start Recording!
5. Running A Macro
6. Project #1 – Running a Macro with a Button
7. Project #1 – Opps! I Need to Edit My Macro
8. Saving an Excel File that contains Macros
9. Practical Uses of Excel Macros
10. Project #1 – Exercise – Try it Yourself and Practice
Excel VBA Concepts
11. Excel VBA Concepts
12. The Visual Basic Editor
13. Excel VBA Modules
14. Creating Excel VBA Procedures
15. Adding Code to a VBA Procedure
16. Understanding Excel VBA Variables
17. Building Logic with an IF Statement
18. Working Excel VBA Loops to repeat blocks of code
Project #2: Moving Beyond the Basics and Into VBA
19. Introduction to Project #2 – Interacting with the Userform
20. Project #2 – Breaking Down the VBA Code
21. Project #2 – Prompting the User for Information
22. Continue Excel VBA InputBox
23. Project #2: Building Logic in Your Macros
24. Project #2 – Alerting the User of Errors
25. Other Practical Uses of Message Boxes and Input Boxes
Project #3: Preparing and cleaning up Data with a little VBA
27. Introduction to Project #3 – Cleaning Up and Formatting Multiple Worksheets
28. Project #3: Preparing to use the Macro Recorder
29. Project #3 – Inserting the Headers
30. Project #3 – Formatting the Headers
31. Project #3 – Putting it all Together with alittle VBA Magic
32. Project #3 – Running the Loop
Project #4: Using VBA to automate Excel Formulas
34. Introduction to Project #4 – Automate Microsoft Excel Formulas with VBA
35. Project #4: Automate the SUM Function through Code
36. Project #4 – Continue Automate SUM Function
37. Project #4 – Test the SUM Function
38. Project #4: Loop the SUM Function over Multiple Worksheets
Project #5: Bringing it all togther and create a weekly report
42. Project #5 – Copying and Pasting Data with VBA
43. Project #5 – Running the Final Report Procedure
Project #6: Working with VBA Forms
45.Introduction to Project #6 – Working with Excel VBA Forms
46. Project #6: Creating an Excel VBA Form
47. Project #6: Adding Controls to the Form
48. Project #6: Adding VBA Code to the Initialize Event of the Form
49. Project 6: Adding VBA Code to the ComboBox Change Event
50. Project #6: Adding VBA Code to the Add Worksheet Button Click Event
51. Project #6 – Change Worksheet Name
52. Project #6: Adding VBA Code to the Create Report Button Click Event
53. Project #6: Showing the Form
55. Introduction to Project #7: Importing Data from a Text File(s)
Project #7: Importing Data from Text Files
56. Project #7: Opening a Text File for Import
57. Project #7: Get Data from Text File
58. Project #7: Importing Multiple Text Files with the GetOpenFilename Method
59. Project #7: Creating a Loop to Read Each File
60. Project #7: Adding a New Sheet for Imported Data
61. Project #7: Clear the Clipboard
62. Project #7: Working with the ScreenUpdating Property
63. Project #7: Creating Reusable Code with a VBA Function
Section 10: Course Wrap Up
64. Congratulations! You're an Excel Macro/VBA Master