Learn how to record macros and explore the Visual Basic Environment
Discover how to manipulate cells and define an object
Know how to work with worksheets and understand variables
Explore workbook functions and VBA logic
Understand how to introduce looping and user interaction
Gain the ability to handle errors and trigger coded events
Course Overview
Use Microsoft’s most versatile business application to its full potential by taking this Excel VBA/Macros Foundations Level 4 course. VBA (Visual Basic for Applications) is consistently regarded as the Office programming language of choice for many experts, who combine it with macros for intuitive automation and versatile functions. You can gain their techniques and knowledge by participating in this professional foundation training and gain a new appreciation for this Office tool.
This comprehensive and advanced Excel course will take your administrative processes to a whole new level of efficiency and competency and free your valuable time to be used on other projects. Aspects of automation, real-time triggers, and worksheets will be taught, enabling you to return your business or organisation and put these valuable techniques straight into practice. So enrol now and go from a beginner to an Excel expert in no time at all.
This best selling Excel VBA/Macros Foundations Level 4 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Excel VBA/Macros Foundations Level 4 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.
The Excel VBA/Macros Foundations Level 4 is CPD-accredited, so you can be confident you’re completing a quality training course will boost your CV and enhance your career potential. The Excel VBA/Macros Foundations Level 4 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.
After successfully completing the Excel VBA/Macros Foundations Level 4, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Excel VBA/Macros Foundations Level 4 will help you stand out from the crowd. You can also validate your certification on our website.
We know that you are busy and that time is precious, so we have designed the Excel VBA/Macros Foundations Level 4 to be completed at your own pace, whether that’s part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.
Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.
Preview
Certification
After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).
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:05: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:02: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
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.