ICAEW.com works better with JavaScript enabled.

Excel online training

Do you consider yourself a competent Microsoft Excel user? Have you ever had any formal training or have you picked it up by trial and error, reading or watching online tutorials and talking with colleagues? Excel and Advanced Excel online training courses from Filtered are part of your Excel Community membership.

Excel online training registration

Excel Community members can start your Excel online training here

Sign up

How good are you at Excel?

The Excel Community can now offer you the chance to formally assess your level of spreadsheet expertise and improve your skill set using personalised online training. Our partner, Filtered provides this.  This training is available through two main comprehensive online training courses. Each course is personalised to the needs of the user through a Filter.

The Filter asks questions to identify knowledge gaps and make learning recommendations. It links answers from similar users to suggest which training modules someone will find most useful. The result is focused training that is shorter and more relevant. The training takes less time to complete resulting in higher engagement and has a 26% greater impact on performance.

After completing the Filter every user receives:

  • A personalised course to suit their needs and knowledge
  • An Excel IQ score benchmarking them against their peers using a comparable competency level
  • A breakdown of the test to see user answers and correct answers

The Excel IQ score calculates in the same way as an Intelligence Quotient (IQ) where the average score of test-takers is 100, and the spread of scores is adjusted so that 95% of candidates score between 70 and 130. One important advantage of this type of adjusted score – called a T-score – is that it can be compared meaningfully between different tests because variations in the difficulty of questions are factored out. These tests reliably measure improvement in Excel, even though users answer a different set of questions before and after any training. 

About the main courses

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.

Additional courses

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