25,000+ Courses Nationwide
0345 4506120

Excel Macros and VBA - One-to-One Training

For Excel users. Extend the capabilities of Excel with Macros and VBA code.

WHAT IS INCLUDED IN THE EXCEL VBA COURSES:
  • Excel VBA Course Certificate on completion
  • Excel VBA Course notes
  • Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work
  • After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.

Select specific date to see price, venue and full details.

Course Content

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

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best