Excel Macros & VBA Course

Excel Macros and VBA Course

This practical course teaches Excel users how to automate tasks and extend Excel’s capabilities using Macros and VBA (Visual Basic for Applications). You will learn to record and edit macros, write and modify VBA code, work with worksheets and data, and create customised solutions that improve efficiency and reduce repetitive work. The course is suitable for Excel users who want to move beyond standard formulas and functions and use automation to work faster, smarter, and more effectively.

Who should attend the Excel Macros and VBA Course?

This course is ideal for:
• Excel users who want to automate repetitive tasks.
• Advanced Excel users looking to develop their VBA skills.
• Data analysts and business professionals who work with large or complex spreadsheets.
• Administrators and finance professionals who want to improve efficiency through automation.
• Anyone looking to extend Excel’s capabilities and create customised solutions using Macros and VBA.

Excel Macros and VBA Outline

Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon
Setting Excel Macro Options
Record and Run Simple Macros
Assign Macros to the Quick Access Toolbar
Introduction to the Excel VBA Editor
Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules
Starting the Visual Basic Editor
Using the Project Explorer
Using the Properties Window
Creating Procedures and Functions
Create simple macro procedures in code that use variable to store data and communicate with the user
Creating Sub and Function Procedures
Declare and Use Variables
Displaying Message to the User
Getting Input from the User
Controlling Program Flow
Using decision making and looping structures to control the way your program works
Using the IF Statement
Using the Select Case Statement
Using For Next Loops
Using Do Loops
Using For Next Loops
Interacting with the spreadsheet :
Referencing Cells and Ranges
Gathering Cell and Range Information
Using the Offset Method
Using With Blocks
Referencing Workbooks and Worksheets
Updating values in the spreadsheet
Functions
Using standard Excel functions in VBA
Creating new custom functions
Calling functions and sub procedures
User Forms
Basic design and display
Getting information via forms and update cells
Practical project and examples

Book the Excel Macros and VBA Course

Contact us / Customise your Excel course

Powered byEMF HTML Contact Form

What makes the Excel course special?

Contact PCWorkshops