Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Macros
- Recording and Modifying Macros
- Assigning Macros to Toolbar, Buttons, Shortcut key
Visual Basic for Applications Environment
- Visual Basic Editor and its options
- Component Management
- Shortcuts
- Environment Optimization
Introduction to Procedural Programming
- Procedures: Functions and Sub-routines
- Data Types
Control Flow
- If ...Then....Elseif....Else....Endif
- Case
- Do...Loop , While
- For... Next
- Exit
- Arrays and Loops
- Strings
Visual Basic
- VBA and Sheet Data Exchange (Cells, Range Methods)
- Getting and Printing Data from Users (InputBox, MsgBox)
- Variable Declaration
- Scope and LifeTime of Variables and Objects
- Operators and Their Priorities
- Modules Options
- Creating Worksheet Functions
- Objects, Classes, Methods and Properties
- Locking Project for Viewing
Debugging
- Run Time, Design Time, and Break Mode
- Brakes and Watches
- Local Window
- Immediate Window
- Call Stack
Error Handling
- Errors Types
- On Error GoTo
- On Error Resume Next
Excel Model Object
- Application Object
- Workbook Object and Workbooks Collection
- Worksheet Object and Worksheets Collection
- ThisWorkbook, ActiveWorkbook, ActiveCell, ....
- Selection Object
- Range Collection
- Cells Collection
- Using Status Bar
- Screen Updating and Optimizing
- Timer and Time Measuring
Events Handling in VBA
VBA Forms
- Creating and Using Forms
- Invoking Forms in VBA Code
- Using VBA Forms in Worksheet
Requirements
- Good Excel user knowledge.
Audience
- Data Analysts
14 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses