Copyright © Optimise Consultancy Ltd
"Gave me a good knowledge to be able to use this software for work."
Amy Hicks - Trent & Dove Housing.
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.
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
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.
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
An advanced understanding of creating spreadsheets and manipulating data in Excel.
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
Day 2 Macro Master Class
* May be an additional charge for 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.