Excel courses London

Microsoft Excel: Introduction

This course introduces the essential concepts of spreadsheets and covers how to set up, format and print a spreadsheet.

It also includes how to create formulas including Sum, Average, minimum and maximum and how to present data in different formats including professional graphs and charts.

outline | pricing | dates | booking

Microsoft Excel: Intermediate

A continuation from the introductory course, this one day course looks at more in-depth functionality and commands in Excel.

You will look at different ways of formatting, analysing and presenting information and learn to use both databases and charts to analyse data.

outline | pricing | dates | booking

Microsoft Excel: Advanced

This course is designed for those who require a greater knowledge of the more advanced features of Excel including Goal Seek, What-if scenarios and pivot tables.

This is a \'power-user\' course and you will leave able to create and customise your own macros and utilise Excel\'s auditing tools.

outline | pricing | dates | booking

Microsoft Excel and VBA

This is a two day course for experienced Microsoft Excel users who manage large and variable amounts of data and wish to harness the power of VBA to improve its\\\' accessibility and usability.

This course will take Excel users who are able to record macros and teach them to use VBA to edit and personalise their macros.

During the course you will learn best practise for writing and editing VBA code, working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions and working with forms.

As this course is run on a private company basis we are able to tailor it to your specific requirements, running it whichever version of software you wish.

For those who already have some VBA experience we are happy to offer a one day version of this course, please call for details.

outline | pricing | dates | booking