Have You Already Joined IOMH ?

Fueling your journey to inspire, overcome, and motivate towards a brighter future. Join us today

Don’t have an account yet? Sign Up

Already have an account? Sign In

By signing up, I accept IOMH (Terms & Conditions)

Excel VBA/Macros Foundations

Overview This Excel VBA/Macros Foundations course will unlock your full potential and will show you how to excel in a career …

Enrolled Students: 20

★ ★ ★ ★ ★

(0 Reviews)

Join our Excel VBA/Macros Foundations course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Excel VBA/Macros Foundations course has everything you need to get a great start in this sector.

Improving and moving forward is key to getting ahead personally. The Excel VBA/Macros Foundations course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now!

You will Learn The Following Things:

This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Excel VBA/Macros Foundations. Enrol today and complete the course to achieve a certificate that can change your career forever.

Details

Perks of Learning with IOMH

Process of Evaluation

After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate.

Certificate of Achievement

Certificate of Completion – Digital/PDF Certificate

After completing the Excel VBA/Macros Foundations course, you can order your CPD-accredited Digital/PDF Certificate for £5.99.

Certificate of Completion – Hard copy Certificate

You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each)

Shipping Charges:

Inside the UK: £3.99
International: £10.99

Who Is This Course for?

This Excel VBA/Macros Foundations is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.

On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.

This course has been developed with maximum flexibility and accessibility, making it ideal for people who don’t have the time to devote to traditional education.

Requirements

There is no prerequisite to enrol in this course. You don’t need any educational qualification or experience to enrol in the Excel VBA/Macros Foundations course.

Do note: you must be at least 16 years old to enrol.

Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course.

Career Path

The certification and skills you get from this Excel VBA/Macros Foundations Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.

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