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.
Who Is This Course For?
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.
Prerequisites
A thorough knowledge of Microsoft Excel is required, or completion of our Microsoft Excel Advanced course.
Benefits
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.
Course Syllabus
Introducing Visual Basic for Applications
Why use VBA?
Recording and running macros
Absolute v relative cell selection
Working with the Visual Basic Editor
Creating your own code
Understanding and creating modules
Defining procedures
Calling procedures
Where to store macros
Making decisions in code
Using logical comparisons
The IF...ENDIF structure
The SELECT CASE...END SELECT structure
When to use IF v SELECT CASE
Repeating code with loops
The DO... LOOP structure
The FOR... NEXT structure
The FOR EACH... NEXT structure
How to debug problems with loops
Debugging errors
Defining errors
Setting breakpoints to pause execution
How to step through code
Working with break mode to spot errors
Identifying the value of expressions
Understanding Visual Basic
What is an Object?
Examining the Excel object hierarchy
Using the object browser
How to explore methods and properties
Getting help in VBA
We seek to provide an unrivalled value and quality service, enabled by our unique business model. We are excited to announce that we have resumed face-to-face training both on our public schedule and onsite.
We're here to help - from Managing Teams Remotely, using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch, to leadership & development programmes.
The professionalism and performance of our people is fundamental to us. Our company culture brings together individuals that cooperate through trust. Bureaucracy and micro-management are kept to a minimum. No photocopiers exist and only essential paper documents are retained.
Our working relationships are typified by their openness and the common goal to achieve the best performance in our industry, both personally and organisationally. The team enjoys a high level of decision making authority, allowing flexibility and creativity.
By working with individuals that have the passion and integrity to deliver, the management team is freed from policing and able to focus on continuous improvement. Feedback to drive quality development is continuously applied from a 100% client satisfaction sampling system.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy