Microsoft Excel Training Courses

This page lists out the public training courses that Wise Owl offer in Excel, but also include links to our exercises, course manuals, tutorials, blogs and more!

Microsoft Excel classroom training

Excel classroom training

Wise Owl run a host of training courses in Excel, Excel Visual Basic and PowerPivot, as follows:

Can't see the course you want? Have a look at our onsite Microsoft Excel training page, or see our other Excel training resources.

Not sure which course you want? See what you can learn on one of our Excel courses.

Which is the right Excel course for you?

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 3 areas: standard courses, specialist courses and VBA (macros) courses.

Our standard Excel courses

We run 3 standard Excel courses, covering the needs of everyone from beginners to advanced users:

Course Length Notes
Introduction to Excel 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.
Intermediate Excel 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. 
Advanced Excel 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.

Our specialist Excel courses

In addition to the above, we run two specialist Excel courses:

Course Length Notes
PowerPivot 2 days You can use PowerPivot to import data from multiple data sources, then link it together to construct simple data models.  You can then use these to show data in pivot tables.  This course also covers how to write DAX formulae to create additional measures (calculations by any other name) for display in your pivot tables, including date-based comparison formulae, before finishing with a quick demonstration of Power BI Desktop.  If you're not sure whether you should learn PowerPivot or Power BI Desktop, see our comparison blog.
Business Modelling in Excel 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.

Our VBA (Visual Basic for Applications) courses

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:

Course Length Notes
Introduction to VBA 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.
Advanced VBA 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 modeules, and much more!

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.

10 things our Excel courses include

Each of our scheduled courses includes:

  1. Small course sizes - we have a maximum of 6 people on each course, and frequently run courses with fewer delegates.
  2. A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls (our average feedback scores are in the range 9.2 to 9.8 out of 10).
  3. Full colour courseware and exercises of oustanding quality (download a sample Excel courseware chapter to judge this claim for yourself) .
  4. A no cancellation guarantee (once you've booked/confirmed training, it will run).
  5. A computer for each delegate (obviously).
  6. Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
  7. Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.
  8. A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too, together with a Sheaffer biro.
  9. Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).
  10. A certificate sent out digitally or in paper form (your choice) after each course, together with (for online courses) the trainer's thoughts on how the course went.

Have a look at our full list of benefits, or read hundreds of testimonials to the quality of our training.

Scheduled Excel training dates

Here are the Excel courses we have scheduled for the next 3 months:

Course Dates Days Venue Price Booking
Wed/Thu 14-15 November 2018 2 £585 Book places
Tue/Wed 20-21 November 2018 2 £695 Fully booked
Thu/Fri 22-23 November 2018 2 £685 Book places
Tue/Wed 27-28 November 2018 2 £895 Book places
Monday 10 December 2018 1 £245 Book places
Tuesday 11 December 2018 1 £295 Book places
Tue/Wed 11-12 December 2018 2 £850 Book places
Thu/Fri 13-14 December 2018 2 £585 Book places
Thu/Fri 13-14 December 2018 2 £895 Book places
Thursday 03 January 2019 1 £345 Book places
Friday 04 January 2019 1 £395 Book places
Tue/Wed 08-09 January 2019 2 £695 Book places
Thu/Fri 10-11 January 2019 2 £585 Book places
Thu/Fri 10-11 January 2019 2 £695 Book places
Tue/Wed 15-16 January 2019 2 £750 Book places
Thu/Fri 17-18 January 2019 2 £850 Book places
Mon/Tue 21-22 January 2019 2 £685 Book places
Thu/Fri 31st Jan/1st February 2019 2 £850 Book places
Tuesday 05 February 2019 1 £245 Book places
Wednesday 06 February 2019 1 £295 Book places
Thu/Fri 07-08 February 2019 2 £750 Book places
Course Date(s) Venue
14/11
20/11
22/11
27/11
10/12
11/12
11/12
13/12
13/12
03/01
04/01
08/01
10/01
10/01
15/01
17/01
21/01
31/01
05/02
06/02
07/02

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 Excel training at your offices (we'll even provide the computers and projector).

About our Excel training

We've got a wealth of experience to draw on when teaching Excel.  Accomplishments include:

  • Andy (Gould) has written a game of Flappy Owl in Excel VBA
  • Sam is working on a simulation of Game of Thrones in Excel VBA
  • Andy (Brown) logs his daily crossword scores in a chart with a dynamic range name as a data source

We've been enthusiastically using Excel internally and for external courses for many years now.  Let us show you how Excel can make your working life more efficient!

Other Microsoft Excel training resources

Microsoft Excel exercises

Try our Excel exercises

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!):

Microsoft Excel training venues

Excel training venues

We run our scheduled Excel courses in the following places:

Microsoft Excel consultancy

Excel consultancy

We can help you create everything from beautiful spreadsheet models to powerful Excel systems using VBA … find out more!

Microsoft Excel blogs

Blogs on Excel

We've written blogs on all manner of things Excel - take a look!

Microsoft Excel courseware

Excel courseware manuals

If you're thinking of booking Excel training with Wise Owl, you'll want to know what our courseware is like - so we've published some sample chapters:

Microsoft Excel book

Excel books or publications

If you want to learn how to program within Excel using VBA, try this book:

Microsoft Excel videos

Videos on Excel

We've got a range of videos to help you learn how to use Excel, write VBA macros or use PowerPivot:

Microsoft Excel skills assessment

Test your Excel skills

You can assess your Excel or Excel VBA skills online using one of these links:

This page has 0 threads Add post