Microsoft Excel is used by pretty well anyone who analyzes data: whether it's summarizing sales figures or producing a business plan at work, or managing subscriptions or events for your social club. Maybe even for household budgets...
We run two sets of courses, at Introduction (beginner) to Advanced levels:
Our MS Excel 365/2021 courses cover the latest stand-alone release from Microsoft and include the features and functionalities currently available only in the subscription-based Excel 365. They are also extremely detailed, with each course giving you around 10 hours of interactive study.
Our MS Excel VBA courses really help you to supercharge your spreadsheets - they're based on Excel 2016, which uses VBA 7.1 and this hasn't changed since 2013. In fact, you can use much of what you learn here on other applications like Word, PowerPoint and Access.
Our MS Excel 2013/2016 courses are a great alternative for a lower-cost option (few of the basics have changed), for anyone looking for a speedy "crash course", and also for people who are using older versions of the software.
All our courses teach you the "right" way, using best practice and avoiding common pitfalls. By enhancing your data analysis skills, they will increase what you can do, the quality of your work -- and boost your productivity too!
The CPD mark of approval means that not only have our courses been rigorously assessed in terms of content and quality, but there are options for you to get a CPD Certification certificate to keep.
A thorough guide to getting started with Microsoft Excel: whether you're a complete beginner, or someone who wants to learn the basics using best practice, this is the course for you.
It starts with the Excel 2021 interface and keyboard shortcuts, then introduces you to Excel formulas and functions before moving on to formatting cells and using Excel lists. We show you how to use charts, insert pictures, work with views, set page layout and a whole host more!
You'll now have a solid basis for understanding and using Excel confidently and effectively.
The course shows you how to use dynamic array functions as well as XLOOKUP, XMATCH, and FILTER.
It's a comprehensive guide on intermediate-level formulas, cleaning & analyzing data using PivotTables and Pivot Charts, controlling data input with validation rules, making decisions with WhatIf analysis, using the golden rules of best practice in spreadsheet design -- and a whole lot more!
The course takes advantage of the latest updates from Microsoft including the game-changing LET and LAMBDA functions. These exciting functions allow students to create their own variables and even their own Excel functions.
You'll be introduced to six brand-new dynamic array functions, learn how to build advanced Excel formulas, analyse data with advanced PivotTable skills, create macros to automate tasks, import and clean data with Power Query, forecast data, and so much more!
Are you spending too much of your time performing repetitive and laborious tasks in Excel? Our VBA Introduction course will save you time, by getting you up and running using macros and VBA fast!
We will show you how to create your own VBA programmes to automate complex tasks in Excel, and help you to gain a solid understanding of the main concepts of VBA.
This professionally produced course teaches you how to transform your spreadsheets.
You start with a great, easy-to-follow treatment of more advanced VBA language.
Next you learn about Event Patterns, and advanced tools for doing just about anything you need with VBA, and this is followed by a major section on Custom Objects.
There's plenty of information on making VBA work smoothly with Excel, before the course wraps up with a great tutorial on how to use References and Libraries.
This is the training you need to acquire advanced skills in using VBA.
A thorough guide to getting started with Microsoft Excel: whether you're a complete beginner, or someone who wants to learn the basics using best practice, this is the course for you.
We show you how to get started, how to use the Excel interface and we outline the basics of running the software.
We then move to editing your workbook, printing and viewing your work, and we show you how to create and use Charts.
You will now have a solid basis for understanding and using Excel confidently and effectively.
Take your Excel skills to the next level with formulas & functions, tables, spreadsheet data tools and charts.
We start you off with advanced Excel file tasks, then move on to working with Functions and Formulas.
You than learn how to manage Tables, Data Tools and Charts, and finish with a great feature called Sparklines.
Your Excel skills will now enable you to produce impressive apreadsheets with little effort.
Are you ready to take your work from good to downright impressive?
You learn about Grouping, Outlining and Subtotals, and how to use What-If Analysis, Pivot Tables and Pivot Charts.
Then we introduce you to HLOOKUPS and VLOOKUPS, and finish with an introduction to Macros which will make your spreadsheets FLY!
You will now be able to produce spreadsheets that not only display your data, but analyse and play tricks with it too...
This course will enable you to get more out of Excel than most people will think possible!
You begin with Advanced Conditional Formatting, Form Controls and Templates, then learn about Advanced LOOKUP Functions
We teach you Advanced Functions, Array Formulas and Advanced Pivot Table Tools before introducing you to User Defined Functions and VBA.
But please don't rush to this level: make sure you have mastered the content of our other three courses first!
If you use Microsoft Excel (and who doesn't?) we have the training course for you - giving you the education to boost your skills and your career.
We take you from understanding the Excel interface, through Functions, Formulas and Formatting, to data analysis tools like Pivot Tables and Lookups, and on up to automating spreadsheets using Macros.
If you're an advanced Excel user, we can take you through VBA programming from first principles up to a level where you may surprise yourself with what you can do!
In fact, if you're looking for a crash course in Excel, our online Excel training courses are the best way to get it, because you also get extended 24/7 access that allows you to go back as often as you like to review and revise your learning.
You have total flexibility ... you can work through all the course content so you have a thorough knowledge from start to finish. Or treat the content as your "library" - to refer to and learn as you need.
Either way, you'l find all our courses easy to watch and available 24/7 to upgrade your Microsoft Excel skills.
POWER pack: Microsoft Excel Beginner to Professional (Four courses)
You do not require any experience of using Excel, but you do need to be familiar with using a PC with Microsoft Windows.