Microsoft Office, Excel and VBA
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.
|Start||End||Places Left||Course Fee|| |
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.