Microsoft Office, Excel and VBAMicrosoft Office, Excel and VBAApplied MS Excel for BusinessDescriptionAssuming 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.
Financial Modelling in ExcelDescriptionLearn the practical skills needed to construct robust financial models that can be used for business planning and evaluation. You will learn best practice design principles required for building flexible models using a range of excel techniques and functions which are applied when building a detailed financial model case study from scratch.
Microsoft Access DatabaseDescriptionThis highly popular short course is ideal for anyone in an Access database developer's/administrator's role, or where Access is a component of a diverse data management solution. The Microsoft Access Database Access short course is for everyone who uses data and would like to quickly create reports without the need for programming knowledge.
VBA in Excel Part 1 (Visual Basic for Applications)DescriptionUsing 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.
VBA in Excel Part 2 (Visual Basic for Applications)DescriptionThis 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.
|