About this course
This one day workshop style training event will take a Step-by-step approach in helping users learn the fundamental principles required to start automating spreadsheet tasks with macros. The course will enable you to create macro programs in Microsoft Excel to automate spread sheet tasks; and make changes to existing macros to meet your spread sheets requirements.
What you will learn
- The Macro Recorder
- Running macros from the Toolbar and from controls on your spread sheets
- Use the Visual Basic Editor to make changes to existing macros
- Work with and understand Object-oriented concepts – Objects, Methods and Properties
- Create macros that execute automatically via workbooks events
- Manage debug and other macros errors
Recent reviews
Chris is an excellent teacher, really knowledgeable about the subject, and willing to work with real life work examples to help the theoretical become grounded in practical day to day useability from start to finish of the course.
Informative course which was a good introduction to Macro training
Tasks were useful and varied, teaching was interesting and useful, learned a lot to do with the task and in excel and general :) would like to do more regularly! Would also like to do more on powerpivot