Hi, you are logged in as , if you are not , please click here
You are shopping as , if this is not your email, please click here

Microsoft Office, Excel and VBA

Microsoft Office, Excel and VBA

Applied MS Excel for Business

Applied MS Excel for Business

Description

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.

StartEndPlaces LeftCourse Fee 
05/10/202207/12/20220£490.00[Read More]
18/01/202322/03/20230£490.00[Read More]
26/04/202328/06/20230£490.00[Read More]
Financial Modelling in Excel

Financial Modelling in Excel

Description

Learn 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.

StartEndPlaces LeftCourse Fee 
10/10/202212/12/20220£560.00[Read More]
16/01/202320/03/20230£560.00[Read More]
24/04/202310/07/20230£560.00[Read More]
Microsoft Access Database

Microsoft Access Database

Description

This 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.

StartEndPlaces LeftCourse Fee 
13/10/202215/12/20220£490.00[Read More]
19/01/202323/03/20230£490.00[Read More]
27/04/202329/06/20230£490.00[Read More]
Microsoft Access VBA Programming

Microsoft Access VBA Programming

Description

The Microsoft Access VBA programming short course teaches in-depth Microsoft Access VBA programming techniques that enable the developer to go beyond capabilities offered by basic Access usage and smooth out the rough edges that Access leaves behind.

StartEndPlaces LeftCourse Fee 
19/01/202323/03/20230£490.00[Read More]
27/04/202329/06/20230£490.00[Read More]
VBA in Excel Part 1 (Visual Basic for Applications)

VBA in Excel Part 1 (Visual Basic for Applications)

Description

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 
10/10/202212/12/20220£560.00[Read More]
16/01/202320/03/20230£560.00[Read More]
24/04/202310/07/20230£560.00[Read More]
VBA in Excel Part 2 (Visual Basic for Applications)

VBA in Excel Part 2 (Visual Basic for Applications)

Description

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.

StartEndPlaces LeftCourse Fee 
19/01/202323/03/20230£560.00[Read More]
27/04/202329/06/20230£560.00[Read More]