Tailored Courses for IT and Business Professionals

Excel VBA - Statistical and Business Analysis Modelling and Decision Making Using Excel and VBA

Objectives

This course takes as it's starting point a basic familiarity with Excel and VBA syntax in Microsoft Excel, and uses these technologies to develop algorithms in VBA and Excel that address common numerical and statistical analysis, business problems and decision making.

The course starts where the Excel VBA Professional Macro Development course finishes, to make use of the tools and technologies the delegate has become familiar with, and now apply them to real-world statistical and business problems.

Prerequisites

Thorough knowledge and understanding of Microsoft Excel and a familiarity with VBA in Excel

Duration

Three Days. Two additional days (days 4 and 5) are available to follow on from the course. These can be taken independently of each other.