Improve staff productivity with a Microsoft Excel course. Our programmes are expert lead face-to-face sessions delivered in-house in London and across the South and East of the UK.
Increase the efficiency of your teams with our comprehensive range of Excel courses. With all of our programmes we include the following:
This one-day Introduction to Excel course equips delegates with the fundamental skills required to use Microsoft Excel productively.
Delegates will develop the skills required to build a worksheet including the principals of formulae & functions, the manipulation of data, printing and graphically representing data through charts.
Delegates will gain an appreciation of how Microsoft Excel can be used in typical business scenarios through the creation of several worksheets and may include budgeting, sales analysis, entry-level bookkeeping and staff scheduling.
Emphasis will be placed on keyboard and mouse shortcuts to ensure all delegates work as efficiently as possible.
Basic Excel formulae will be used to summarise data in a worksheet. Various number & layout formatting techniques will be applied to ensure the worksheets have a professional feel about them. Several different chart types will be used to explore ways of analysing data through graphical representation.
I have learned skills I did not have before this training, I have gained knowledge on formulas and how to use them. The course was clear and easy to understand, Mark explained everything in a way that was easy to digest.
This Intermediate Microsoft Excel course is aimed at delegates who are using Excel to maintain lists of data and carry out some form of analysis on them. It is designed for people who need to know how to fully understand and manipulate lists to maximum effect. This will be done by covering data manipulation and filters, the more advanced mathematical and statistical analysis of data and ultimately the use of Pivot Tables within Excel.
– For delegates who use Excel to store and analyse data
– To create and maintain a list of data that makes lists work for you
– Use filters to quickly select sets of data within lists
– Manipulate data into useful elements e.g. separate data from a single cell
– See the magic of Pivot Tables and the speed of which they analyse and present statistical information.
This Advanced Microsoft Excel course is designed to take delegates through performing complex data analysis, using complex formulae, importing and exporting of data and introducing them to recording macros and editing in the Visual Basic environment.
It is recommended that participants should have attended or be confident with the foundation and intermediate level subjects.
– For delegates who use Excel to store and analyse data
– To create and maintain a list of data that makes lists work for you
– Use filters to quickly select sets of data within lists
– Manipulate data into useful elements e.g. separate data from a single cell
– See the magic of Pivot Tables and the speed of which they analyse and present statistical information.
I’ve learned everything I needed to know. I’ve achieved so much confidence in using pivot tables. Mark was an amazing trainer and the course was really well structured.