Hi, you are logged in as , if you are not , please click here

Microsoft Office, Excel and VBA

Microsoft Office, Excel and VBA

Applied MS Excel for Business

Applied MS Excel for Business

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

StartEndPlaces LeftCourse Fee 
03/05/201705/07/2017£480.00[Read More]
05/05/201707/07/2017£480.00[Read More]
Financial Modelling in Excel

Financial Modelling in Excel

Financial Modelling gives student practical skills need to construct robust financial models of businesses/organisations that can be used for budgeting/business planning.

StartEndPlaces LeftCourse Fee 
03/05/201705/07/2017£540.00[Read More]
08/05/201710/07/2017£540.00[Read More]
MS Access database

MS Access database

Microsoft Access short course teaches you the fundamentals of how to design and build databases; this fully hands-on course gives you an introduction to Access programming.

StartEndPlaces LeftCourse Fee 
03/05/201705/07/2017£430.00[Read More]
Visual Basic for Applications in Excel Part 1

Visual Basic for Applications in Excel Part 1

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.

StartEndPlaces LeftCourse Fee 
02/05/201704/07/2017£540.00[Read More]
06/05/201703/06/2017£540.00[Read More]
08/05/201717/07/2017£540.00[Read More]
10/06/201708/07/2017£540.00[Read More]
Visual Basic for Applications in Excel Part 2

Visual Basic for Applications in Excel Part 2

This course builds on Visual Basic for Applications 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.

StartEndPlaces LeftCourse Fee 
03/05/201705/07/2017£540.00[Read More]
Visual Basic for Applications in Excel Part 3

Visual Basic for Applications in Excel Part 3

For students who have successfully completed Visual Basic for Applications (VBA) in Excel Part 2 or have knowledge of subjects therein, this course includes customisation features such as classes and Add-ins, database-enabled web publishing, and integrating Excel VBA with functionality from other applications.

StartEndPlaces LeftCourse Fee 
08/05/201717/07/2017£540.00[Read More]