Excel VBA & Macros
1 DAY TRAINING WORKSHOP
Email us for next date
Course level - Introductory / Developmental
Those who wish to increase spreadsheet potential by automating their tasks and processes. Spreadsheet authors, Excel developers and finance professionals looking to learn and experiment with VBA programming in order to speed up everyday tasks.
Course Content
By the end of the course the delegate will be competent in an array of VBA essentials:
- The fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions.
- Mastering how to control program execution.
- In order to ensure minimal downtime while building and rolling out the program, the course also includes modules on debugging code and handling errors.
Learning outcomes include obtaining a greater understanding of:
- Introducing Visual Basic for Applications
- Recording and running macros
- Absolute vs relative movement and selection
- Working with the Visual Basic Editor and Developer tab
- Getting VBA to make decisions
- Using logical comparisons
- The IF...ENDIF structure
- The SELECT CASE...END SELECT structure
- Error handling and trapping
- Introduction to repeating code
- The need for and benefits of loops
- Implementing a DO WHILE LOOP
- Examples of the FOR... NEXT structure
- Interaction between VBA and the end-user
- Activating message boxes and user prompts
- Processing end-user input via input boxes
- Creating functions
- Writing your own User Defined Functions (UDFs)
- Working with multiple arguments
- Using your bespoke function in Excel
For further information CLICK to complete our quick contact form or call our team of advisors on 0845 555 1030