Course overview
Recording and Running Macros in Excel
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, Importing and Exporting Modules
- Explore Recorded Macros
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
Working With the Excel Object Model
Explore a variety of ways our code can manipulate data within cells, create and navigate around worksheets and workbooks
- Understanding Objects, Properties and Methods
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 and Putting Values into the Spreadsheet
Functions
- Using Standard Excel Functions in VBA
- Creating new Custom Functions
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
Practical Project and Examples
Study method
- Online
- Blended
- In-class

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.
Enrol in a course today to unlock exclusive deals.
Duration study load
- 1 Day
Course features
- Excel Macros and VBA course certificate on completion (assessment based)
- Excel Macros and VBA course notes
- Practical Excel Macros and VBA course exercises, Excel Macros and VBA course homework/Excel Macros and VBA course revision work
- To assist after the course, 1 free session for questions online Excel Macros and VBA course via Skype/Teamviewer
About PCWorkshops
PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.
We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.
Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.