Excel & VBA training for professionals
A hands-on course designed to help participants use Excel and Visual Basic for Applications as efficiently as possible in their day-to-day work.
Two main topics
- Advanced Excel use
- Visual Basic for Applications (VBA)
VBA is an extensive, powerful, professional programming language. After the course, you will still need to invest significant practice time before you can independently develop time-saving, professional Excel applications.
Participants
Solid basic knowledge of Excel is required. Group size is limited to 8 participants. This training is offered exclusively to businesses (B2B/B2G), not to private individuals.
Duration
The course spans 2 days of 6 teaching hours each. We run it in Dutch or in English. The depth depends on participants' starting level, the desired end level, and the practical situations to be covered.
What's covered
Advanced Excel use
- Various general tips and tricks
- Three-dimensional models
- Working with dates and times
- Advanced functions (IF, VLOOKUP, ISERROR, etc.)
- Named ranges
- Protection
- Data validation
- Form controls
- Conditional formatting
- Working with lists, sorting and filtering
- Subtotals and pivot tables
- Links between files
Visual Basic for Applications
- The macro recorder, absolute and relative recording
- The Visual Basic Editor
- Range manipulation
- Decision structures and loops
- Sub procedures and variables
- Help resources and the object hierarchy
- Interaction: message, input and dialogue boxes, user forms
- Error handling
- Visual Basic functions
- Practical exercises based on your own workplace situations
Course materials
After the course, participants receive digital copies of all worked examples as reference material.
Practical arrangements
- By default, the course takes place on-site at your organisation.
- The training room is then set up with participant computers, a projector and a whiteboard or flipchart.
- Other venues can be arranged; rates may differ.
- Optional: a follow-up day to cover specific workplace situations further.
Interested in this training?
Get in touch and we will work out what suits your organisation.