Master Microsoft Excel Macros and Excel VBA
$0.99
Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA.
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.
What you’ll learn
- 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
Course content
1010 sections • 64 lectures • Total duration 5 hours 25 minutes
Course Introduction and Overview
Project #1: Using Excel's Macro Recorder Tool
Excel VBA Concepts
Project #2: Moving Beyond the Basics and Into VBA
Project #3: Preparing and cleaning up Data with a little VBA
Project #4: Using VBA to automate Excel Formulas
Project #5: Bringing it all togther and create a weekly report
Project #6: Working with VBA Forms
Project #7: Importing Data from Text Files
Course Wrap Up