• No products in the basket.

  • LOGIN

Login

  • 23 Students

  • Certified

Overview

Get the most out of Microsoft’s most popular business application by taking this professional Excel VBA/Macros Foundations course. Visual Basic for Applications (VBA) is the Office programming language of choice. Knowing how to combine this with macros will allow you to install complicated tasks and automation for more productivity and effectiveness.      

This Excel VBA tutorial provides expert tuition and guidance for attaining the skills and knowledge to successfully utilise these platforms to their full potential. You will be shown how to write VBA syntax, record macros, explore the Visual Basic Environment, work with active sheets, understand variables, and interact with users. Alongside those critical capabilities, you will also be taught how to handle errors and allow automation to trigger events and updates.    

This training delivers the core competencies that will take you from an Office novice to an Excel expert and help you to streamline all of your administration and reporting facilities.

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.

Why study this course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Excel VBA/Macros Foundations is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.

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
Assignment
Assignment – Excel VBA/Macros Foundations 00:00:00

Training 10 or more people?

Get your team access to 3,000+ top courses anytime, anywhere.

Try One Education Business

Certifications

Get accredited certificates

New skills

Add skills to your CV

Exams

Test your skills

Dedicated Support

For any questions

Set your own speed

Self-paced learning

Save your money

Monthly subscription

COPYRIGHT © 2022 One Education

0
Your Cart