IIRF Online > Office Productivity > Microsoft > Excel VBA > Master Microsoft Excel Macros and Excel VBA
Master Microsoft Excel Macros and Excel VBA by Udemy
Project Based Course on Excel VBA (Visual Basic for Applications) and Excel Macros
Course Highlights
- Learn how to automate daily routine tasks within Excel
- Learn best practices when creating macros and streamline your VBA code
- Determine when it's best to use the Macro Recorder versus VBA
- Learn how to write custom VBA Macros to create more robust automation
- Learn VBA programming concepts to create dynamic, re-usable code
- Complete real world Macro/VBA projects from beginning to end
Skills you will learn!
Curriculum
2 Topics
Welcome to the Course
Understanding the Why and How Behind Excel Macros
9 Topics
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
9 Topics
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
9 Topics
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
8 Topics
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
7 Topics
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
6 Topics
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
11 Topics
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
9 Topics
Introduction to Project #7: Importing Data from a Text File(s)
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
1 Topic
Congratulations! You're an Excel Macro/VBA Master
Master Microsoft Excel Macros and Excel VBA
Related Excel VBA Courses
Thank You!
Your review has been submitted successfully.