Covid-19 update: The learning doesn’t have to stop, join our online community. We will be delivering courses remotely until further notice. Live tutor support and virtual lessons will take place during advertised teaching hours. The classes are taught in small groups, so you’ll get lots of support from your tutor. Book now.
The Applied MS Excel for Business short course covers the most important aspects of MS Excel, essential knowledge in every workplace.
This highly popular course is ideal for anyone at any workplace that uses Excel. The course teaches the most commonly required skills in Excel.
A basic knowledge of MS Excel is required, such as entering and editing data in Excel; calculating numerical data; using mathematical formulas; analysing data using simple statistical functions; sorting and filtering data.
This practical short course takes the form of a series of evening classes taking place once a week in our Central London location.
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 Excel & database functions, logical tests, Pivot tables and what-if analysis.
In the final week we look at the recording, running and basic editing of VBA macros.
By the end of the course, you will be able to:
“ The course gives good overview of advanced excel options. ”
“ Really handy slides and workbooks ”
A basic knowledge of MS Excel, such as:
Robert Stephenson is a visiting lecturer at London Metropolitan University. He has a Mathematics and Computing BSc (UNL) and Data Communications, Networks and Distributed Systems MSc (UCL).