Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
544 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
We offer friendly, expert live online or classroom training courses in Excel with course sizes limited to 6 people: learn anything from creating your first Excel formula through to writing advanced macros in VBA!
We currently run the following scheduled Excel courses:
We've been teaching Excel since the early days (anyone remember Excel 4.0?), and consider ourselves gurus! There's a lot you can learn, so we've divided our training into three areas: standard courses, VBA (macros) and Office Scripts courses.
We run 3 standard Excel courses, covering the needs of everyone from beginners to advanced users:
Course | Length | Notes |
---|---|---|
1 day | This is aimed at beginners: it shows how to create, format and print basic worksheets, and how to create simple charts. You won't need any existing experience to attend this course. | |
1 day | This is aimed at people who know the basics, but want to find out a bit more about what you can do in Excel. You'll learn how to sort and filter data in tables, how to apply conditional formatting, how to use IF functions, how to create range names and much more. | |
2 days | For those who are already comfortable using Excel, and want to find out what else the software allows you to do, we've created this two-day advanced course. You'll learn much more about the many useful functions in Excel such as VLOOKUP, MATCH and INDEX, as well as how to work with pivot tables and how to import data from different sources. | |
2 days | Do you consider yourself proficient at using Excel? Do you build spreadsheet models as part of your job? This two day course will show you three things above all: how (and why) to use range names for every formula you create, the many short-cut keys available in Excel and how to use all the built-in Excel functions. Along the way you'll learn how to create robust financial models. |
Excel contains a built in macro programming language called VBA (Visual Basic for Applications), which it shares with the other Microsoft Office applications. We run two courses on VBA - introduction and advanced - as well as a three-day consolidated fast-track course:
Course | Length | Notes |
---|---|---|
2 days | You won't need any prior experience to attend this course, although if you've used another programming language you'll find it easier to pick things up. The course will teach you pretty much all of the theory that you'll need to automate routine tasks in Excel, although don't underestimate the need to then practise what you've learnt after the course has finished. | |
2 days | If you already know how to declare variables, test conditions, create loops and select cells using keywords like END and OFFSET, you may be ready for our two-day advanced VBA course (but note that for casual users of VBA this will be a course too far). You'll learn how to get Excel to talk to other Microsoft applications like Outlook and Word, how to loop over files and folders processing each in turn, how to work with tables of data in Access or SQL Server, how to create your own objects using class modules, and much more! | |
3 days | If you want to learn as much Excel VBA in as short a time as possible, this is the course for you! The training aims to cover the entire contents of the other two courses with the exception of class modules in just three days. |
Excel has two programming languages! If you're using Excel 365 online (or security is a big concern for you) you should use Office Scripts, rather than the older VBA. Here are the Office Scripts courses that we run:
Course | Length | Notes |
---|---|---|
2 days | This course will show you how to program in Office Scripts, a language which is a variant of TypeScript (itself based on JavaScript). You'll learn how to select ranges, work with arrays and write conditions and loops. | |
2 days | If you already know the basics of programming in Office Scripts, this will show you how to perform advanced tasks, such as wroking with charts, tables, emails, pivot tables and Power Automate flows. |
If you're still not sure which is the right Excel course for you, have a look at our blog giving more detailed help on what each Excel course involves.
Each of our scheduled courses (whether classroom or online) includes:
In addition, our classroom courses also include:
Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.
Here are the next Excel courses we have scheduled:
Course | Dates | Venue |
---|---|---|
Excel VBA macros | 10-11 Dec | Online |
Excel VBA macros | 09-10 Jan | Online |
Excel Introduction | 16 Jan | Online |
Excel Intermediate | 27 Jan | Online |
Excel Advanced | 03-04 Feb | Manchester |
Excel Business Modelling | 05-06 Feb | Online |
Advanced VBA | 05-06 Feb | Online |
Introduction to Office Scripts | 05-06 Feb | Online |
Excel Advanced | 06-07 Feb | Online |
Excel Introduction | 10 Feb | Manchester |
All prices exclude VAT. If you can't see the dates you want, don't forget that you always have the option of arranging onsite training at your offices (we'll even provide the computers and projector).
We don't just teach in Excel - we use it internally too. And not just for work ...
Will this trainer beat his Park Run PB? The omens are not looking too good ...
We've written versions of Flappy Bird and Wordle in VBA within Excel too, just for fun. Book on one of our Excel courses to share our enthusiasm!
There are many ways in which we can help you learn Excel!
We believe in showing you everything we can - which is why you can view our Excel exercises online using one of the following links (you can even try them out in advance of any course!).
We've written blogs on all manner of things Excel - take a look!
Our online VBA course will teach you how to program within Excel.
We've got a range of videos to help you learn how to use Excel, write VBA macros or use PowerPivot.
Have a look at our Microsoft Excel tips and tricks.
We run our scheduled Excel courses in the following places.
You can sample or license the following courseware manuals.
You can assess your Excel or Excel VBA skills online using one of these links.
We can help you create everything from beautiful spreadsheet models to powerful Excel systems using VBA … find out more!
If you want to learn how to program within Excel using VBA, try this book.
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.