MS Excel is well-known and probably the most widely used spreadsheet application and arguably a very powerful tool especially when VBA is unleashed.

VBA or Visual Basic for Applications enables building User-Defined Functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). It supersedes and expands on the abilities of earlier application-specific macro programming languages such as Word’s WordBASIC. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes. – Wikipedia

LEARNING OBJECTIVES

At the end of the training, participants shall be able to:

• create automated tasks and processes within Excel workbooks, for the purpose of simplifying repeated

manual tasks, and in so doing enable the Excel user to focus on the essence and insight of the data that

they are processing.