Microsoft Office, Excel & VBA

Assuming a basic knowledge of Microsoft Excel, this hands-on step-by-step spreadsheet course guides you through commonly used business applications such as forecasting techniques, advanced database functions, logical tests, Pivot tables and what-if analysis.

Using a step-by-step approach, this course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel. Participants will write macros to accept user input, read to and write from cells and manipulate data; they will also write custom functions and create user forms.

This course builds on Visual Basic for Applications (VBA) in Excel, introducing a wider range of objects and applying previously learnt programming constructs to more complex and robust programs. Applications covered include importing data into Excel, manipulating pivot tables, reporting and complex data manipulation.