Course Introduction and Overview
- Welcome to the Course
- Understanding the Why and How Behind Excel Macros
Project #1: Using Excel's Macro Recorder Tool
- Introduction to Project #1 - Inserting and Formatting Text
- Project #1 - Start Recording!
- Running A Macro
- Project #1 - Running a Macro with a Button
- Project #1 - Opps! I Need to Edit My Macro
- Saving an Excel File that contains Macros
- Practical Uses of Excel Macros
- Project #1 - Quiz - Test Your Knowledge on Using the Macro Recorder
- Project #1 - Exercise - Try it Yourself and Practice
Excel VBA Concepts
- Excel VBA Concepts
- The Visual Basic Editor
- Excel VBA Modules
- Creating Excel VBA Procedures
- Adding Code to a VBA Procedure
- Understanding Excel VBA Variables
- Building Logic with an IF Statement
- Working Excel VBA Loops to repeat blocks of code
- VBA Concepts - Quiz - Test Your Knowledge on VBA Programming Concepts
Project #2: Moving Beyond the Basics and Into VBA
- Introduction to Project #2 - Interacting with the User
- Project #2 - Breaking Down the VBA Code
- Project #2 - Prompting the User for Information
- Continue Excel VBA InputBox
- Project #2: Building Logic in Your Macros
- Project #2 - Alerting the User of Errors
- Other Practical Uses of Message Boxes and Input Boxes
- Project #2 - Quiz - Test Your Knowledge on Editing Your Macros
- Project #2 - Exercise - Try it Yourself and Practice
Project #3: Preparing and cleaning up Data with a little VBA
- Introduction to Project #3 - Cleaning Up and Formatting Multiple Worksheets
- Project #3: Preparing to use the Macro Recorder
- Project #3 - Inserting the Headers
- Project #3 - Formatting the Headers
- Project #3 - Putting it all Together with alittle VBA Magic
- Project #3 - Running the Loop
- Project #3 - Quiz - Test Your Knowledge on VBA
- Project #3 - Exercise - Try it Yourself and Practice
Project #4: Using VBA to automate Excel Formulas
- Introduction to Project #4 - Automate Microsoft Excel Formulas with VBA
- Project #4: Automate the SUM Function through Code
- Project #4 - Continue Automate SUM Function
- Project #4 - Test the SUM Function
- Project #4: Loop the SUM Function over Multiple Worksheets
- Project #4 - Quiz - Test Your Knowledge Automating a Function with VBA
- Project #4 - Exercise - Try it Yourself and Practice
Project #5: Bringing it all togther and create a weekly report
- Introduction to Project #5 - Creating a Final Report
- Project 5: Creating the Final Report Loop
- Project #5 - Copying and Pasting Data with VBA
- Project #5 - Running the Final Report Procedure
- Project #5 - Quiz - Test Your Knowledge of Creating the Final Report
- Project #5 - Exercise - Try it Yourself and Practice
Project #6: Working with VBA Forms
- Introduction to Project #6 - Working with Excel VBA Forms
- Project #6: Creating an Excel VBA Form
- Project #6: Adding Controls to the Form
- Project #6: Adding VBA Code to the Initialize Event of the Form
- Project 6: Adding VBA Code to the ComboBox Change Event
- Project #6: Adding VBA Code to the Add Worksheet Button Click Event
- Project #6 - Change Worksheet Name
- Project #6: Adding VBA Code to the Create Report Button Click Event
- Project #6: Showing the Form
- Project #6 - Quiz - Test Your Knowledge on Creating Excel VBA Forms
- Project #6 - Exercise - Try it Yourself and Practice
- Introduction to Project #7: Importing Data from a Text File(s)
Project #7: Importing Data from Text Files
- Project #7: Opening a Text File for Import
- Project #7: Get Data from Text File
- Project #7: Importing Multiple Text Files with the GetOpenFilename Method
- Project #7: Creating a Loop to Read Each File
- Project #7: Adding a New Sheet for Imported Data
- Project #7: Clear the Clipboard
- Project #7: Working with the ScreenUpdating Property
- Project #7: Creating Reusable Code with a VBA Function
Course Wrap Up
- Congratulations! You're an Excel Macro/VBA Master
