Microsoft Excel VBA For Beginners

by Skillsgen Claim Listing

This course is for those who wish to take their first steps toward using the incredibly powerful tool that is Visual Basic in Excel. You will learn how to programmably automate tasks and get the basics of forms; objects; expressions and variables down.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Skillsgen Logo

img Duration

1 Day

Course Details

This course is for those who wish to take their first steps toward using the incredibly powerful tool that is Visual Basic in Excel. You will learn how to programmably automate tasks and get the basics of forms; objects; expressions and variables down. Please be sure to read the pre-requisites for this course to ensure you meet the requirements.

 

Course Content
Using the Recorder:

  • Naming Macros
  • Assigning Shortcuts
  • Absolute and Relative Recording
  • Where macros are stored
  • Personal Macro Workbook

Getting Started:

  • Developer tab
  • Filing
  • Macro Security

Overview:

  • VBA or Macros?
  • What it can be used for

Editing Code :

  • Understanding the code structure
  • Simple edits
  • Calling procedures

The VB Editor:

  • Overview of the VB Editor
  • Projects and the Project Explorer
  • Properties and Code Windows

Running Macros:

  • Shortcut keys
  • Quick Access Toolbar
  • Worksheets buttons and shapes
  • Ribbon

The If statements:

  • Single line
  • Blocked If
  • Logical expressions

Exploring Code with the Immediate Window:

  • Variables and Constants
  • Dimensioning
  • Option Explicit
  • Data Types
  • Scope
  • Locals and Watch Windows

Stepping and Debugging:

  • Step Intro, Over, Out
  • Setting Breakpoints
  • Editing code while Stepping
  • Dealing with Runtime error

Writing Macros:

  • VBA Terminology
  • Procedures, Subroutines, Macros, Functions
  • Objects, Methods, Properties

Adding Simple Interactivity to Macros:

  • Creating an Interactive Message Box
  • Creating a Custom Input Box
  • Liverpool Branch

    South Road, Liverpool

Check out more MS Excel courses in UK

Nexus Human UK Logo

Microsoft Word

In this course, you'll learn how to use Word 2019 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents. Microsoft Word 2019 is designed to help you move smoothly through the task of creating professional.

by Nexus Human UK [Claim Listing ]
Wise Owl Training Logo

MS Excel (Intermediate)

Once you've got the basics of Excel, it's time to learn a little more about what you can do. This one-day intermediate course will show you how to use range names, sort and filter lists, create decision (IF) functions and much more!

by Wise Owl Training [Claim Listing ]
I Train Scotland Logo

Office 365 for End Users

Microsoft Office 365 offers a suite of Cloud based business applications including Teams, Planner, Office Online, OneDrive, SharePoint This 1 day course aimed at end-users, will teach your staff how to get the best out of these Cloud based apps.

by I Train Scotland [Claim Listing ]
Olas Logo

Microsoft Excel

Microsoft Excel course is offered by Olas. Olas uses a variety of delivery methodologies and believe a blended learning approach leads to the participants retaining the knowledge learnt through the learning event.

by Olas [Claim Listing ]
3D Educators Logo

Advance Excel Training

This Advance Excel training program is highly specialized with the duration of 16 Credit hours, where this Advance Excel training covers all the major areas of Financial Formulas, excel reporting, Advance Excel with Financial Formulas.

by 3D Educators [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy