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.
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.
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:
- Use advanced graphics and presentation techniques to create impactful reports.
- Increase interactivity and automate your spreadsheet with macros and Visual Basic.
- Solve complex problems with superpower functions.
- Use PivotTables and PowerPivot to turn raw data into refined information to support key decisions
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