Designed for Excel 365, 2019, 2016, 2013, 2010
This course is suitable for advanced users of Microsoft Excel. If they are responsible for very large and variable amounts of data, or teams, who need to learn how to program features and functions to develop the accessibility and usability of their data.
A thorough knowledge of Microsoft Excel is required, or completion of our Microsoft Excel Advanced course.
By the end of the course the delegate will be competent in the fundamentals of VBA, including recording macros, working with the Visual Basic Editor and writing their own code.
In order to ensure minimal downtime while building and rolling out the program, the course also includes advice on debugging code and handling errors.
Why use VBA?
Recording and running macros
Absolute v relative cell selection
Working with the Visual Basic Editor
Understanding and creating modules
Where to store macros
Using logical comparisons
The IF…ENDIF structure
The SELECT CASE…END SELECT structure
When to use IF v SELECT CASE
The DO… LOOP structure
The FOR… NEXT structure
The FOR EACH… NEXT structure
How to debug problems with loops
Setting breakpoints to pause execution
How to step through code
Working with break mode to spot errors
Identifying the value of expressions
What is an Object?
Examining the Excel object hierarchy
Using the object browser
How to explore methods and properties
Getting help in VBA