ICAEW.com works better with JavaScript enabled.

Excel online training

We now offer a new and improved range of Excel online training which available as part of your Excel Community membership subscription – this is a major benefit. Track your progress and improve your Excel capabilities and minimise spreadsheet risk.

Log in to register

In order to register for Excel training and access the courses listed on this page, you will need to be logged in

Log in

Filtered now provides a new and enhanced learning platform. It gives access to the courses and incentivises learning with levels and badges which you can collect as you go along.

Collaborate with other members on Excel challenges and share tips via the discussion forum and check your progress via a reporting inforgraphic. 

Excel and Advanced Excel online training courses – consist of a suite of training modules made up of a mixture of learning methods, model spreadsheets and video tutorials. The courses are tailored to each individual, based on a short set of questions which filter out anything they don't need or already know. The training covers Excel  2016 version and beyond.

Microsoft Excel

The world’s most popular spreadsheet software is designed to help users perform a myriad of business tasks. Most office staff can use Excel to a basic level for data entry, to format cells, even to use a basic PivotTable. But few make it to the next level, to be able to build models, conduct scenario analyses, apply checks to flag errors, create a dashboard or format to a client-ready standard. This course will do all of this, directing your attention to those areas of Excel most relevant to you.

Advanced Microsoft Excel

This course will take your Excel abilities to the next level. It demystifies the most complex areas of Excel using written text, screenshots and 160 videos. By the end of the course you will be proficient in the more complex functions and formulas used in Excel. The areas covered include Advanced Range Names, Array Formulas, Visual Basic and Macros, PivotTables and PowerPivots.

Having taken this course you will be able to:

Power BI

Power BI offers true self-service business analytics by enabling users to interact with corporate information and extract the intel they require. Covering the three main components of Power BI this introductory course demonstrates how to produce compelling visualizations and reports to provide deep insights into data.

Business Analysis

The course will take you through a proven, structured process to improve your ability to collect, analyse and forecast information, generate valuable insights and make well-supported business decisions.

Introduction to Data Science

The ability to work with data is becoming more desirable in a number of generalist roles, irrespective of the industry. If you want your staff to be able to draw insights and trends from reports then this course will give them the tools to do so.

Top ten tips: Excel for accountants

The Excel for Accountants (Basic) course is a short course consisting of 10 video-led modules. The course is primarily aimed at accountants, bookkeepers and accounting professionals and aims to provide learners with a solid foundation with which to build further skills.

Top ten tips: Excel for accountants – intermediate

This is a short course consisting of 10 video-led modules. The course is primarily aimed at accounting professions. It aims to teach ten important topics that will assist staff with daily Excel tasks.

Top ten tips: Data analytics

In this short, ten module course we aim to teach you the basic skills you need to analyse data effectively and efficiently. From PivotTables and Conditional Formatting to Lookup formulas and beyond, this course will set you up with a great foundation upon which to build further skills.

How good is your team at Excel?

If you think your team or company could benefit from Excel training then why not consider corporate membership. The benefits of corporate membership include:

  • Discounted rates
  • Live on-platform reporting, including course progress, test results and more
  • Access for line managers to view  team progress
  • Downloadable csv. of user data
 To find out more about individual or corporate membership of the Excel Community, contact the Excel Community.