Copyright © Optimise Consultancy Ltd
What people think
"Gave me a good knowledge to be able to use this software for work."
Amy Hicks - Trent & Dove Housing.
Level 1
Microsoft Excel
Introduction to Macros
Pre-requisites
Delegates attending this course should be have a good understanding of Excel and be able to open, edit and save files. They should also be able to use various formula and be able to format spreadsheets.
Course Objectives
By the end of the course users will be able to record and edit basic macros. You will understand where and why macros are stored in specific locations and be able to create a button to activate a macro.
Course Content
Automating Spreadsheets with Macros
- Recording Macros
- The Developer Tab
- Creating Macro Buttons
- Relative and Absolute modes
- Editing recorded code
- Reducing recorded code
- Documenting your macros
- The Personal Macro Workbook
- Modifying the Ribbon Bar
Level 2
Microsoft Excel
Macros and Automation
Pre-requisites
Delegates attending this course should be have a good understanding of Excel and be able to open, edit and save files. They should also be able to use various formula and be able to format spreadsheets.
Course Objectives
By the end of the course users will be able to record and edit basic macros. You will understand where and why macros are stored in specific locations and be able to create a button to activate a macro. You will be able to edit code and have an understanding of the syntax used in VBA.
Course Content
- Recording Macros
- The Developer Tab
- Creating Macro Buttons
- Relative and Absolute modes
- Editing recorded code
- Reducing recorded code
- Documenting your macros
- The Personal Macro Workbook
- Modifying the Ribbon Bar
- Documenting your macros
- Creating and using variables
- Creating a User Form
- Basic Looping
- Using If statements
Level 3
Microsoft Excel
Macro Master Class
Pre-requisites
An advanced understanding of creating spreadsheets and manipulating data in Excel.
Course Objectives
At the end of the course users will be able to understand and create VBA code. You will be able to create procedures, user-defined functions and forms to help automate Excel spreadsheets for End Users.
Course Content
Day 1 Macro Introduction
- Recording Macros
- The Developer Tab
- Creating Macro Buttons
- Relative and Absolute modes
- Editing recorded code
- Reducing recorded code
- Documenting your macros
- The Personal Macro Workbook
- Modifying the Ribbon Bar
- Documenting your macros
- Creating and using variables
- Creating a User Form
- Basic Looping
- Using If statements
- Homework project
Day 2 Macro Master Class
- User Form Controls
- Input Boxes and Message Boxes
- Controlling program low with IF structures
- Sorting and Filtering worksheet data
- Applying worksheet functions within VBA
- De-Bugging macros
- Building in bug reporting to code
- Automatic macros
* May be an additional charge for Off-Site Training
On-site and Off-site training *
Training to suit you and your business
Need Help?
Your place or mine?
What do you need?
'The course was excellent, there were areas which I didn't know about. The Trainer was very helpful.'
Shirley Cole - South Staffordshire Council
Book training with us now.
