Patrick Curtis – VBA Macros In Excel Course

- 70%

$97.00 $29.00

Add to wishlistAdded to wishlistRemoved from wishlist 0
[Pre-Order] – Deliver digital download link within 4-8 business days after successful payment. Please contact us to get more details.
Add your review

Introducing…

The Wall Street Oasis

VBA MACROS IN EXCEL COURSE

35+ lessons, 3+ hours of video & a comprehensive capstone case study

 
HERE’S JUST SOME OF WHAT YOU’LL GET IN THIS COURSE
 
Code Syntax and Formatting (3 video lessons)

In this module, we use 3 video lessons to explain code syntax and best practices on how to gain maximum efficiency when writing code. This includes a tutorial on how to build macros and guidelines to make sure you are building good habits for coding.

 
Referencing and Clearing (3 video lessons)

In this module, we use 3 video lessons to build the fundamental blocks necessary to write more complex code. This module includes a step-by-step guide on how to reference macros, reference a range, and edit cells.

 
Copy / Paste Methods and Variables (4 video lessons)

In this module, we use 4 video lessons to continue building on our fundamentals by learning two Copy/Paste methods and how to declare a Variable. This module includes a walkthrough of several types of variables within Excel.

 
Message Boxes and Naming (3 video lessons)

In this module, we use 3 video lessons to learn how to troubleshoot errors within our code and display user instructions using message boxes. We wrap up this module by exploring a new referencing technique through named ranges.

 
Ranges, Offsets, and For Next Loops (8 video lessons)

In this module, we use 8 video lessons to dive into more complex range functions and learn about logical statements that will wrap up the basic fundamental building blocks necessary to write VBA code.

 
Dynamic Code (4 video lessons)

In this module, we use 4 video lessons to learn how to make our code dynamic so that our Excel macros can be used in any situation. We wrap up the module by learning several suggestions for learning VBA code.

 
Recording Macros (3 video lessons)

In this module, we use 3 video lessons to build on the previous module by learning how to record Macros and manipulate a recorded Macro. This module includes a step-by-step guide on how to dissect a recorded Macro to improve and streamline code.

 
Case Study (7 video lessons)

In this module, we use 7 video lessons to work through a case study using all the VBA Macros and techniques we have learned so far. This include includes creating a Yes/No box, using For…next loops with an IF statement, and repurposing our code for future projects.

Course Summary – Table Of Contents

Below you will find a list of the modules and lessons included in this course.

 
 
 
 
 
 
 
 
 
 
 
Salepage: https://www.wallstreetoasis.com/vba-macros-in-excel-course-overview
Archive: https://archive.ph/wip/EQxKn

User Reviews

0.0 out of 5
0
0
0
0
0
Write a review

There are no reviews yet.

Be the first to review “Patrick Curtis – VBA Macros In Excel Course”

Your email address will not be published. Required fields are marked *

Patrick Curtis – VBA Macros In Excel Course
Patrick Curtis – VBA Macros In Excel Course

$97.00 $29.00

Courseavai - Best Online Courses
Logo
Enable registration in settings - general
Shopping cart