Excel VBA/Macros Foundations

Excel VBA/Macros Foundations

get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

Overview

Get the most out of Microsoft’s most popular business application by taking this expert 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

Certificate of Achievement

Endorsed Certificate of Achievement from the Quality Licence Scheme

Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £109.00. Please note that overseas students may be charged an additional £10 for postage.

CPD Certificate of Achievement from One Education

Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.

Endorsement

This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.

Method of Assessment

In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate.

Why Study This Course

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

The Excel VBA/Macros Foundations is fully available to anyone, and no previous lessons 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
Resources
Resources – Excel VBA/Macros Foundations 00:00:00
Assignment
Assignment – Excel VBA/Macros Foundations 2 weeks, 1 day
Order Your Certificate
Order Your Certificate QLS 00:00:00
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
2
  • Item added to cart
  • Item added to cart
2
Your Cart
Digital Forensics for Cyber Professionals

Level-4 Digital Forensics for Cyber Professionals
- +
£29
Get A PDF Certificate & Transcript After You Complete Your Course

Scholarship: Score 80% or more in your final exam to get this Fee refunded.

New Certificate On A Table
- +
£9.99

Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

Claim Offer & Upgrade

Membership renews after 12 months. You can cancel anytime from your account.

Other Students Also Buy
    Apply Coupon