Master Microsoft Excel Macros and VBA with 6 Simple Projects

Join me in this course and take control of Microsoft Excel mastering the process of automating tasks with Macros and VBA.

During this course you will build a foundation of working with Macros and VBA. This foundation will be built as you engage and participate in 5 Excel Macro/VBA projects detailed throughout the lectures within this course. Each of the 5 projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating tasks within Excel and ending with a fully customized Excel VBA project that will automate a series of tasks.

• Welcome to the Course
• Understanding the Why and How Behind Excel Macros
• Introduction to Project #1: Inserting and Formatting Text
• Project #1: Start Recording!
• Project #1: Running a Macro with a Button
• Project #1: Opps! I Need to Edit My Macro
• Project #1: Practical Uses of Excel Macros
• Excel VBA Concepts
• The Visual Basic Editor
• Excel VBA Modules
• Creating Excel VBA Procedures
• Understanding Excel VBA Variables
• Working with Excel VBA Loops to Repeat Blocks of Code
• Building Logic with an IF Statement
• Project #2: Intro to Interacting with the User
• Project #2: Breaking Down the VBA Code
• Project #2: Prompting the User for Information
• Project #2: Alerting the User of Errors
• Project #2: Other Practical Uses of Messages Boxes and Input Boxes
• Project #3: Intro to Cleaning and Formatting Data
• Project #3: Using the Macro Recorder to Lay the Foundation
• Project #3: Preparing to Use to the Macro Recorder
• Project #3: Inserting Headers
• Project #3: Formatting Headers
• Project #3: Putting it All Together with a Little VBA Magic
• Project #4: Automate Microsoft Excel Formulas
• Project #4: Automate the SUM Function through Code
• Project #4: Loop the SUM Function Over Multiple Worksheets
• Project #5: Creating the Final Report
• Project #5: Putting it all Togehter to Create the Final Report
• Project #6: Working with Excel VBA Forms
• Project #6: Creating an Excel VBA Form
• Project #6: Adding Controls to the Form
• Project #6: Changing Control and Form Properties
• Project #6: Adding VBA Code to the Intialize Event
• Project #6: Adding VBA Code to the ComboBox Change Event
• Project #6: Adding VBA Code to the Add Worksheet Button
• Project #6: Adding VBA Code to the Create Report Button
• Project #6: Showing the Form
• Congratulations