Excel is a powerful application, but it does have its limitations: for example, every day you have to make the same list, add the totals, the Pivot Tables or charts,… You have to set up the same filter on 15 sheets,… In this course you will learn how to automate all these actions so that with one click of your mouse all the repetitive work is done for you and you can start immediately on your real work.

Macros

• Recording a macro
• Link a macro to a button

Visual Basic

• The VBE (Visual Basic Editor)
• Modules
• Types of variables
• Procedures and functions
• Inputbox and Msgbox
• Decision structures
• Loops
• Error Handling

Excel Objects

• The Excel Object Model
• Properties, Methods and Events
• The application object
• The workbook(s) object
• The worksheet(s) object
• The range object

Forms

• Working with form objects (command button, listbox, checkbox,…)
• Working with forms in Excel