EIEIOTECHNOVATION
← Training programmes

EIEIO / APPLICATION TRAINING

VBA and Macros - Microsoft Excel 2010 (Mrexcel Library)

Course outline

3 days

Duration

3 days

Course Description

Microsoft Excel VBA (Macro) introduces users the fundamentals of VBA concepts that are practical in the finance environment, as well as common tasks in using Microsoft Excel. The Microsoft Excel VBA allows customization of spreadsheet tools and integrating them with existing data and systems. Offering an easy and non-intimidating approach to VBA, this course takes a unique approach in uncovering the features that will allow users to customize the Microsoft Excel application to suit individual needs especially in automating repetitive tasks. Very quickly, the user will accumulate a wealth of programming skills that can easily be put to use in real-world scenarios.

Audience

This course is recommended for heavy users of Microsoft Excel especially financial professionals who have made Microsoft Excel as an indispensable tool at work. Most tasks at work will be simplified extensively with usage of the VBA tool. Participants are required to have fundamental knowledge in Microsoft Excel prior to attending this course.

Prerequisites

Delegates enrolling in this course should understand the basics of Windows. They should already have experience working with Microsoft Excel.

Programme scope, delivery arrangements and suitability are confirmed during enquiry.