• No products in the cart.


Course Curriculum

Course Curriculum

Section 01: Introduction
Recording Macros vs Writing VBA 00:04:00
Understanding Objects in Excel VBA 00:07:00
Understanding VBA Syntax and Parts of Speech 00:10:00
Activating the Developer tab 00:01:00
Recording a basic Macro 00:05:00
Absolute vs Relative Macro recording 00:04:00
Section 02: Exploring the Visual Basic Environment
Introduction to the Visual Basic Environment 00:02:00
The Project Explorer 00:02:00
The Properties Window 00:02:00
The Code Window 00:04:00
Immediate, Locals and Watch Window 00:03:00
Dealing with Modules 00:03:00
Comments in Excel VBA 00:01:00
Section 03: The Range Object
Introduction and Changing Cell Values 00:10:00
Adding a text to a cell 00:01:00
Dealing with Named Ranges 00:03:00
Value vs Text Property 00:04:00
Row and Column properties 00:02:00
The Select Method 00:02:00
The Count Property 00:04:00
The Address Property 00:09:00
The Formula Property 00:03:00
The Number Format Property 00:07:00
The Font Property 00:08:00
Section 04: Understanding the Cells Collection Object
What is the cells object? 00:06:00
Using the Cells collection to affect cells positionally within a range 00:05:00
Affecting all cells within a sheet 00:02:00
Combining Range and cells objects 00:03:00
Section 05: Working with Sheets/Worksheets
Selecting Sheets 00:06:00
Adding Sheets 00:11:00
Sheets vs Worksheets 00:04:00
Copying Sheets 00:05:00
Moving Sheets 00:01:00
Deleting Sheets 00:04:00
Section 06: Understanding Variables in Excel VBA
Introduction to Variables 00:06:00
Variable Data Types 00:09:00
Declaring Variables 00:14:00
Object Variables 00:08:00
Calling a procedure from Another Procedure & Variable Scope 00:03:00
Public and Private Variables 00:07:00
Declaring Constants 00:04:00
Exercises-Variables 00:06:00
Section 07: Dealing with Workbooks
Referring to Workbooks-Different ways 00:04:00
Closing Workbooks 00:03:00
Adding and Saving Workbooks Part 1 – Save method 00:04:00
Adding and Saving Workbooks Part 2 – Save as method 00:10:00
Opening Workbooks 00:06:00
Section 08: Must Know Excel VBA Logic
Finding the Last row 00:09:00
Finding the Last Column 00:04:00
Finding the next row 00:04:00
The WITH Statement 00:04:00
Comparison operators in Excel VBA 00:01:00
IF Statements- Simple IF Statements 00:07:00
IF THEN ELSE Structure 00:03:00
IF THEN ELSEIF Structure 00:07:00
Nested IFs 00:04:00
OR – AND logical operators 00:07:00
NOT Logical operator 00:03:00
CASE Statements Part 1 – Single Case Statements 00:09:00
CASE Statements Part 2 – Nested Case Statements 00:06:00
Case Statements-Exercise 00:01:00
GOTO and Labels 00:03:00
Section 09: Looping in Excel VBA
Loops-Introduction 00:01:00
FOR NEXT Loop 00:11:00
Exit For 00:09:00
Exercise – For Next loop 00:01:00
FOR EACH Loop – Intro 00:07:00
FOR EACH Loops – More examples 00:05:00
Do Loop – Introduction 00:04:00
Do Loop Example 00:01:00
Do Until 00:02:00
Do While 00:02:00
Do while vs Do until – Movies Example 00:04:00
Exit Do Statement 00:05:00
Exercise – Do Loop 00:01:00
Section 10: Interacting with Your Users
The Messagebox – Introduction 00:03:00
Messagebox – Inputs 00:07:00
Messagebox – Capturing the User’s input 00:05:00
Adding a new line to your VBA Strings 00:02:00
The Inputbox – introduction 00:04:00
Inputbox – Example1 – Capturing a user’s name 00:05:00
Inputbox – Employee Database Example Part 1 00:05:00
Inputbox – Employee Database Example Part 2 00:04:00
Exercise – InputBox 00:02:00
Section 11: Error Handling in Excel VBA
Error Handling – Introduction 00:09:00
Different Error types in action 00:04:00
On Error Goto statement 00:04:00
Resetting the error handling Status with On Error Goto 00:02:00
The Err Object 00:07:00
Setting a Breakpoint 00:02:00
Section 12: Triggering Code with Events!
Worksheet Events – Selection change 00:08:00
Worksheet Events – Worksheet Activate event 00:03:00
Worksheet Events – Deactivate event 00:02:00
Worksheet Events – Before Delete Event 00:02:00
Worksheet Events – Before Double click event 00:08:00
Worksheet Events – Before Right Click event 00:03:00
Worksheet Events – Calculate event 00:03:00
Enabling and Disabling Events 00:03:00
Worksheet events – Worksheet change event 00:11:00
Worksheet events – Follow Hyperlink event 00:03:00
Worksheet events – Exercise 00:01:00
Workbook Events – Workbook open event 00:05:00
Workbook Events – Workbook Activate event 00:02:00
Workbook Events – Workbook Before save event 00:06:00
Workbook Events – Workbook Aftersave event 00:04:00
Workbook Events – Workbook Beforeclose event 00:09:00
Workbook Events – Workbook BeforePrint event 00:03:00
Workbook Events – Workbook De-activate events 00:02:00
Workbook Events – New Chart event 00:08:00
Workbook Events – New sheet event 00:03:00
Workbook Events – Sheet calculate event 00:03:00
Workbook Events – Sheet De-activate event 00:06:00
Workbook Events – Follow Hyperlink event 00:02:00
Workbook Events – Workbook Window Activate event 00:06:00
Workbook Events – Workbook Window De-Activate event 00:02:00
Workbook Events – Window Resize event 00:02:00
Exercise- Workbook Events 00:01:00
Resources – Excel VBA/Macros Foundations 00:00:00

Excel VBA/Macros Foundations

0( 0 REVIEWS )
Duration: 8.88 Hours
Excel VBA/Macros Foundations
  • Course Highlights

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Excel VBA/Macros Foundations has been specially designed to help learners gain a good command of Excel VBA/Macros Foundations, providing them with a solid foundation of knowledge to become a qualified professional.

Through this Excel VBA/Macros Foundations, you will gain both practical and theoretical understanding of Excel VBA/Macros Foundations that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.

Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.

  • Learning outcome
  • Get a deep understanding of the Excel VBA/Macros Foundations just in hours not years
  • Familiar yourself with the recent development and updates of the relevant industry
  • Know how to use your theoretical and practical knowledge to adapt in any working environment
  • Get help from our expert tutors anytime you need
  • Access to course contents that are designed and prepared by industry professionals
  • Study at your convenient time and from wherever you want
  • Requirements
  • No formal qualifications required, anyone from any academic background can take this course.
  • Access to any internet-enabled smart device.
  • Why should I take this course?
  • 9 hours of on-demand video lectures and downloadable resources.
  • Affordable premium-quality E-learning content, you can learn at your own pace.
  • You will receive a completion certificate upon completing the course.
  • Internationally recognized Accredited Qualification will boost up your resume.
  • You will learn the researched and proven approach adopted by successful salespeople to transform their careers.
  • You will be able to incorporate various practical sales techniques successfully and understand your customers better.


Hear what our happy students want to say

Setup Menus in Admin Panel

Select your currency
    Your Cart
    Your cart is emptyReturn to Shop

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only$68.11 / year


    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon