Expand your Excel skills on this 1-Day Intermediate Excel training course.
Learn to use some of Excel’s more powerful features like sorting and filtering data and creating charts.
This is a hands-on course and includes plenty of chances to trying out what you are being taught and ask questions.
✔ An intermediate Excel course that will build on your existing Excel skills.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.
Lucinda is our usual trainer for our intermediate Excel course. She has been training Microsoft Excel for over 20 years.
She is a certified Microsoft Office trainer, a certified life coach and also works as a teaching assistant working at a primary school one day per week.
By the end of this course you’ll be a far faster, more confident Excel user.
You’ll learn how to:
Click on the sections below to see the full syllabus that this Excel course covers.
Being able to manipulate and control worksheets is a key skill in Excel. This will show you how to make your worksheets do exactly what you want them to, and also how to format them to make working with them clearer. It also covers hiding and unhiding rows and columns within a worksheet.
The key topics covered include:
As you become a more proficient Excel user it is very likely that your spreadsheets will contain more than one worksheet. This means that you then need to be able to link data from one worksheet to another worksheet, and potentially from one workbook to another workbook. This lesson leads you through how to do that quickly and simply.
The key topics covered include:
The most common basic functions and how to use them are covered on our Essentials course. This session takes you a little further into using functions which are not only useful in themselves, but also allows you to see how powerful Excel is and the type of things it is capable of.
The ability to quickly and simply create a chart or graph to illustrate the data in your spreadsheet is one of the most used parts of Excel. The chart wizard offers a huge number of potential chart types and presentation options. This session shows you how to create a simple chart and the basics of how to work with it.
The key topics covered include:
Cutting and pasting in Excel can be tricky when working with different data types. As ever, Excel offers a number of options to ensure that it all works smoothly. This session will make sure that you get it right first time.
The key topics covered include:
Excel offers the ability to only change the formatting of cells meeting certain criteria. This can make finding key data in a large spreadsheet very quick and simple. This session shows you how to set the criteria that you are looking for and also how to format those cells to ensure that you can easily see them.
The key topics covered include:
Now you have learnt how to do all these things properly, here are some shortcuts:
You need a basic of level of Excel knowledge to attend this course.
This Excel course assumes that you have an understanding of the concepts covered in our basic Excel course like using AutoFill and AutoSum, Absolute Cell References, formatting worksheets and simple formulas.
If you are unsure if this course is the appropriate level for you, please either contact us or use our Excel level analyser tool to advise you.
Once you have completed this course you will be at the appropriate level to attend either our advanced Excel course or our financial modelling in Excel course.
You don’t need to bring anything with you – we provide everything you’ll need for a really fun, productive day of training.
Our courses run from 9.30 am to roughly 4.30 pm with refreshments and biscuits throughout the day and a break for a tasty, freshly prepared lunch.
We offer a relaxed, supportive learning environment, fully air-conditioned facilities and some of the nicest instructors on the planet.
Also, you’ll receive:
✔ A full-colour A4 manual covering everything in the course to keep.
✔ A USB stick so that you can take the course exercises home with you.
✔ A Certificate of Attendance.