0
  • LOGIN
Excel VBA/Macros Foundations

CPD Accredited Course

  • Calendar 2 Students
  • Calendar 1 Year
  • chart Regular
  • clock 8 hours, 53 minutes

Get This Course And 2200+ Others For Only £49. ORDER NOW

Course Overview

Gear up to get well equipped in Excel VBA/Macros Foundations now, make up your mind to be the best in the business! All you need is proper training, firm support and push to shine in your vocation, and Compliance Central is determined to provide you with it all! Explore what you got in this exclusive Excel VBA/Macros Foundations, start learning and excel in it! This amazing Excel VBA/Macros Foundations course has been designed and developed by the industry specialists who had been to the business for years, went through ups-and-downs, climbed up the success ladder with sheer excellence! You’ll get to-the-point knowledge both practical and theoretical, and gain valuable insights on the business which will help you understand the drill better than ever! Join today, be skilled, learn with positive energy and enthusiasm, create an excellent career using your full potential! Brace yourself, enrol now for an amazing venture!

This Excel VBA/Macros Foundations Course Package Includes

  • Free CPD Accredited PDF Certificate
  • Comprehensive lessons and training provided by experts on Excel VBA/Macros Foundations
  • Interactive online learning experience provided by qualified professionals in your convenience
  • 24/7 Access to the course materials and learner assistance
  • Easy accessibility from any smart device (Laptop, Tablet, Smartphone etc.)
  • A happy and handy learning experience for the professionals and students
  • 100% learning satisfaction, guaranteed by Compliance Central — a leading compliance training provider approved by IAO

Learning Outcome

Upon successful completion of this highly appreciated Excel VBA/Macros Foundations course, you’ll be a skilled professional, besides—
  • You can provide services related to Excel VBA/Macros Foundations with complete knowledge and confidence
  • You’ll be competent and proficient enough to start a Excel VBA/Macros Foundations related business on your own
  • You can train up others and grow an efficient peer community on your locality and serve people
  • It will enhance your portfolio, you can use the certificate as proof of your efficiency to the employer
  • It will boost up your productivity, you can use the skill and credentials, and become more competent in your vocation with increased earning!

Assessment

Complete this Excel VBA/Macros Foundations course and sit up for a short online assessment to instantly evaluate your understanding of the subject. The test will be an automated one, your answers will be checked and reviewed then and there, and you'll get unlimited chances to retake the exam! Our concern is to make you competent for the job that is why you get full support from our part to learn and understand it thoroughly. The test fees are included in the one-time paid course fee. As said earlier, you can retake the exam if you fail early attempt —you would not be charged any money further for the later attempts.

Certification

You can instantly download your certificate for £4.79 right after finishing the Excel VBA/Macros Foundations course. The hard copy of the certification will also be sent right at your doorstep via post for £10.79. All of our courses are continually reviewed to ensure their quality, and that provide appropriate current training for your chosen subject. As such, although certificates do not expire, it is recommended that they are reviewed or renewed on an annual basis.

Who Is This Course For

Compliance Central aims to prepare efficient human resources for the industry and make it more productive than ever. This helpful course is suitable for any person who is interested in Excel VBA/Macros Foundations. There are no pre-requirements to take it. You can attend the course if you are a student, an enthusiast or a
  • Employee
  • Employer
  • Manager
  • Supervisor
  • Entrepreneur
  • Business Professional
  • Company Leader
  • HR Professional

Course Currilcum

    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • The Messagebox – Introduction 00:03:00
    • The Messagebox – Introduction 00:03: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
    • 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
    • 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 Window Activate event 00:06: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
Excel VBA/Macros Foundations

ex Vat

Save Upto 98% - Ends Soon! counter
Take this course

OR

All Courses For Only £49
Certified Certified Certified
£11 /Unit Price
£110
Add to Cart
Subscribe Now

Student Reviews

Ben lim

Gaining improve knowledge in the construction project management and the course is easy to understand.

Mr Brian Joseph Keenan

Very good and informative and quick with marking my assignments and issuing my certificate.

Sarah D

Being a support worker I needed add a child care cert in my portfolio. I have done the course and that was really a good course.

Sam Ryder

The first aid course was very informative with well organised curriculum. I already have some bit and pieces knowledge of first aid, this course helped me a lot.

Ben lim

Gaining improve knowledge in the construction project management and the course is easy to understand.

Thelma Gittens

Highly recommended. The module is easy to understand and definitely the best value for money. Many thanks

BF Carey

First course with Compliance Central. It was a good experience.

Course Currilcum

    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • The Messagebox – Introduction 00:03:00
    • The Messagebox – Introduction 00:03: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
    • 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
    • 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 Window Activate event 00:06: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