Master Microsoft Excel Macros and Excel VBA

1 Review

248 Enrolled

3.5 Hours

$15.00$50.00

You save 70%

57 Lessons (3.5h)

Course Introduction and Overview
Welcome to the Course4:08
Something to THINK About and SHARE2:01
Understanding the Why and How Behind Excel Macros3:18
Project #1: Using Excel's Macro Recorder Tool
Introduction to Project #1 - Inserting and Formatting Text1:39
Project #1 - Start Recording!7:14
Project #1 - Running a Macro with a Button2:12
Project #1 - Opps! I Need to Edit My Macro4:04
Practical Uses of Excel Macros2:17
Project #1 - Quiz - Test Your Knowledge on Using the Macro Recorder
Project #1 - Exercise - Try it Yourself and Practice
Excel VBA Concepts
Excel VBA Concepts0:30
The Visual Basic Editor2:06
Excel VBA Modules1:14
Creating Excel VBA Procedures2:05
Understanding Excel VBA Variables5:16
Working Excel VBA Loops to repeat blocks of code4:11
Building Logic with an IF Statement2:39
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 User2:42
Project #2 - Breaking Down the VBA Code3:05
Project #2 - Prompting the User for Information5:35
Project #2: Building Logic in Your Macros4:57
Project #2 - Alerting the User of Errors7:05
Other Practical Uses of Message Boxes and Input Boxes3:18
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 Worksheets2:59
Project #3 - Using the Macro Recorder to Lay the Foundation1:53
Project #3: Preparing to use the Macro Recorder2:28
Project #3 - Inserting the Headers2:40
Project #3 - Formatting the Headers5:07
Project #3 - Putting it all Together with alittle VBA Magic9:54
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 VBA2:23
Project #4: Automate the SUM Function through Code9:30
Project #4: Loop the SUM Function over Multiple Worksheets5:57
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 Report2:56
Project 5: Putting it all together to create a Final Report9:57
Project #5 - Quiz - Test Your Knowledge of Creating the Final Report
Project #5 - Exercise - Try it Yourself and Practice
Bonus Project #6: Working with VBA Forms
Introduction to Bonus Project #6 - Working with Excel VBA Forms3:14
Bonus Project #6: Creating an Excel VBA Form2:48
Bonus Project #6: Adding Controls to the Form2:42
Bonus Project #6: Changing Control and Form Properties4:56
Bonus Project #6: Adding VBA Code to the Initialize Event of the Form7:26
Project 6: Adding VBA Code to the ComboBox Change Event4:20
Project #6: Adding VBA Code to the Add Worksheet Button Click Event6:15
Project #6: Adding VBA Code to the Create Report Button Click Event2:03
Bonus Project #6: Showing the Form3:27
Bonus Project #6 - Quiz - Test Your Knowledge on Creating Excel VBA Forms
Bonus Project #6 - Exercise - Try it Yourself and Practice
Course Wrap Up
Congratulations! You're an Excel Macro/VBA Master1:02
BONUS! - Special Offer! Any of my courses for only $10

DescriptionInstructorImportant DetailsReviewsRelated Products

Use 6 Simple Projects to Become a Master Working with Excel Macros & VBA

Kyle Pew

Instructor

Kyle Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including:

Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
Excel, Word, PowerPoint, Outlook, Access and Visio
SharePoint End-User 2007, 2010, 2013
VBA (Excel and Access)
Adobe Suite
Photoshop, Illustrator, InDesign
Maya (Modeling and Animation)
Unity3d (Game Design)
HTML, CSS and JavaScript
Crystal Reports

Description

During this course, you will build a foundation of working with Excel Macros and VBA. You'll engage in several projects that will build upon one another as you progress through the basic building blocks of automating tasks within Excel. Soon you'll be ready to enter the world of Excel VBA, where you will experience a more dynamic, robust experience for yourself and your peers.

Access 57 lectures & 3.5 hours of content 24/7
Automate placing & formatting a title on a worksheet
Interact w/ the users of your Macros through input & message boxes
Clean up multiple Excel worksheets & prepare the data to be reported on
Create a report based on multiple sets of data found within multiple Excel worksheets
Automate the creation of Excel Formulas to SUM data up in your report

Specs

Important Details

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels

Requirements

Internet required
Microsoft Excel 2010, 2013, or 2016

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

1 Review

5/ 5

All reviews are from verified purchasers collected after purchase.

Trey Russell

Verified Buyer

Very good presentation and content . Helped me understand and work VBA into my Excel workbooks for repetitive actions.

Aug 29, 2020

Your Cart

Your cart is empty. Continue Shopping!

Processing order...