ICAEW.com works better with JavaScript enabled.

Register for Excel training

To register for your online training and access all the courses outlined on this page, please click the button below

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

Excel and Advanced Excel online training courses - provided by award-winning training provider – Filtered.com – consist of a suite of training modules made up of a mixture of learning methods, model spreadsheets and video tutorials. Filtered.com offers courses 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 2003, 2007, 2010, 2013 and 2016 for PC as well as the 2011 and 2016 Mac versions.

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
  • A management dashboard giving complete visibility of staff activity
  • Access for line managers to view their team progress
  • Excel IQ scores across the cohort to assess progress and prove ROI
  • Downloadable csv. of user data
   

team results box 

To find out more about individual or corporate membership of the Excel Community, contact the Excel Community.

Join the Excel Community

Use Excel to its maximum potential. Develop your skills and minimise spreadsheet risk with our online training and more.

Find out more