Master Microsoft Excel Macros and Excel VBA
4.7 /5- Offered byUDEMY
Master Microsoft Excel Macros and Excel VBA at UDEMY Overview
Duration | 5 hours |
Total fee | ₹449 |
Mode of learning | Online |
Credential | Certificate |
Master Microsoft Excel Macros and Excel VBA at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 17 downloadable resources
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Master Microsoft Excel Macros and Excel VBA at UDEMY Course details
- For those that use Microsoft Excel and are looking to become more efficient by automating their daily Excel tasks
- 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
- Complete real world Macro/VBA projects from beginning to end
- During this course you will build a foundation of working with Excel Macros and VBA
- This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course
- Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks
- The course also contains detailed instructions through the video lectures as well as a series of PDF documents that you can reference as you complete the projects
Master Microsoft Excel Macros and Excel VBA at UDEMY Curriculum
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
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
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 #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 #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 #5: Bringing it all together 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
Master Microsoft Excel Macros and Excel VBA at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?