Also in Microsoft Office Digital Skills by FILTERED

Using the Data Model with Pivot Tables in Excel
lesson / 35m

In this training course, you will learn the fundamental concept of data modelling and understand why it’s crucial in data analysis. The Data Model […]

View
15 Essential Advanced Excel Formulas
lesson / 53m

This course will help break down the barriers of seemingly intimidating functions like VLOOKUP, INDEX, MATCH, FILTER, and even the cutting-edge LAMBDA function, making […]

View
Cleaning Data in Power Query to Maximise Your Efficiency and Impact
lesson / 37m

Power Query is not just about tidying up your data; it’s a game-changer for merging, transforming, and automating complex data tasks. This course uncovers […]

View
New Dynamic Array Functions in Excel
lesson / 40m

In this course, you will delve into advanced techniques using the newly released dynamic array functions by Microsoft 365. Discover the power of TOCOL […]

View
Mastering Excel Lookup Functions
lesson / 54m

This course will explore the essential Excel lookup functions — VLOOKUP, XLOOKUP, INDEX, and MATCH. You will gain a profound understanding of VLOOKUP and […]

View
Microsoft Excel 365 Intermediate
lesson / 8h 56m

In this course, you’ll improve your Excel skills to manage data and efficiently make informed decisions. You’ll learn to design better spreadsheets, improve readability, […]

View
Controlling User Input in Excel: Mini Masterclass
lesson / 35m

This empowering course will equip you with the skills to effectively manage and validate user inputs, ensuring data accuracy and reliability in Excel workbooks. […]

View
Formula Auditing in Excel: Mini Masterclass
lesson / 45m

This course, Formula Auditing in Excel, is an exploration into the intricacies of managing and understanding complex formulas, designed to empower you with the […]

View
Basic Navigation and Editing in Excel: Mini Masterclass
lesson / 30m

In this course, you will learn the basics of navigation and editing in Microsoft Excel. You’ll utilise the Find and Replace function, develop your […]

View
Summarising Data in Excel: Mini Masterclass
lesson / 40m

This course, Summarising Data in Excel, is a strategic dive into efficiently condensing and analysing vast datasets. You will learn to harness Excel’s robust […]

View
Organising Data in Excel: Mini Masterclass
lesson / 45m

Organising your data in Excel using the SORT and FILTER functions is not just a matter of convenience; it’s essential for effective data management […]

View
Analysing Large Datasets in Excel: Mini Masterclass
lesson / 45m

Analysing large datasets in Excel often requires a combination of powerful functions and logical conditions to extract valuable insights. In this course you will […]

View
Getting Started with Functions and Formulas in Excel: Mini Masterclass
lesson / 30m

Functions and formulas are the heart of Excel, enabling you to perform calculations, manipulate data, and automate tasks. There are five functions that are […]

View
Setting Up Excel: Mini Masterclass
lesson / 30m

This course is aimed at learners with basic knowledge of Excel, and are looking to understand the versatile software better. Excel, a powerful spreadsheet […]

View
What-If Analysis in Excel: Mini Masterclass
lesson / 30m

This Excel mini masterclass looks at how to use the What-If Analysis tools in Excel. The What-If Analysis tools in Excel are essential to […]

View
Logical Functions in Excel: Mini Masterclass
lesson / 30m

This Excel masterclass takes the learner through how to use IF and Logical functions in Excel effectively. This course will cover decision-making with IF […]

View
Excel Pivot Table and Pivot Chart: Mini Masterclass
lesson / 45m

Excel’s Pivot Tables and Pivot Charts are invaluable data analysis and visualisation tools. They empower users to transform raw data into actionable insights, fostering […]

View
Microsoft 365
lesson / 1h 32m

In today’s ever-changing digital landscape, effective communication, seamless collaboration, and practical productivity tools are crucial for individuals and organizations alike. This course is your […]

View
Windows 11 Advanced
lesson / 1h 32m

Elevate your Windows 11 expertise with our Microsoft Windows 11: Advanced Features and Settings course. Whether you’re a newcomer or an experienced user, this […]

View
Ten Essential Excel Formulas to Master
lesson / 1h 18m

In the course, Ten Essential Excel Formulas to Master, you will learn the fundamental Excel formulas that are crucial for data analysis and manipulation. […]

View
SharePoint Online 2023
lesson / 3h 49m

Welcome to Mastering Microsoft 365 SharePoint Online: The Essential Guide. If you seek an application that combines document storage, team collaboration, and seamless integration […]

View
PowerPoint Tips to Maximise Your Efficiency
lesson / 51m

Unlock the full potential of PowerPoint and take your presentations to the next level with our training course, PowerPoint Tips to Maximise Your Efficiency […]

View
Fix Bad Habits in Excel
lesson / 52m

Address Excel bad habits and equip you with practical solutions to boost your productivity and make a lasting impact in this comprehensive training course. […]

View
Outlook Email Management
lesson / 37m

Ensure your inbox remains clutter-free and your productivity soars in this training course. In this course, learn how to optimise Outlook’s features and practical […]

View
Cleaning Data in Excel
lesson / 47m

Transform raw data into valuable information through meticulous data cleaning and preparation in this training course. From dealing with messy spreadsheets, inconsistent formatting, or […]

View
Chart Formatting in Excel
lesson / 47m

Elevate your data presentation skills efficiently with impactful charts that leave a lasting impression with this training course. This course will help equip you […]

View
Manipulating Data in Excel: Mini Masterclass
lesson

In this course, you will learn how to assign meaningful names to cell ranges and tables and understand how to use names in formulas […]

View
VBA for Beginners
lesson

You’ve completed the beginner course in VBA, or have some experience. Now challenge yourself with the next step. Advanced VBA is a learner-friendly course […]

View
Top Ten tips: Data Analysis
lesson

Successful enterprises make the most out of the information available to them. They derive value from the numbers driving their business – and this […]

View
Microsoft Excel 2021 Intermediate
lesson / 10h 0m

In this second course of our Excel 2021 series, we build on the skills learned in the beginners’ Excel course. This course will teach […]

View
Microsoft Excel 2021 Advanced
lesson / 10h 0m

In this third course of our Excel 2021 series, we build on the skills learned in the beginners’ and intermediate Excel courses. This course […]

View
Top ten tips: Excel for Accountants Beginners
lesson / 3h 0m

This lesson is a short course consisting of 10 video-led modules. The lesson is primarily aimed at accountants, bookkeepers and accounting professionals and aims […]

View
Microsoft Excel 2021 Beginners
lesson / 11h 0m

Excel 2021 is the latest standalone release from Microsoft and includes many of the features and functionalities currently available only in the subscription-based Excel […]

View
Top ten tips: Excel for Accountants Intermediate
lesson / 3h 0m

This lesson is a short course consisting of 10 video-led modules. The course is primarily aimed at accounting professionals. It aims to teach ten […]

View
Microsoft Projects for Beginners 2016
lesson

Work smarter, not harder. Microsoft Project is a feature-rich tool that will help a project manager plan, track, and control a project and facilitate […]

View
Microsoft Sharepoint
lesson

SharePoint has been referred to as the ‘Swiss Army Knife’ of collaboration software suites. It has over 100 million users worldwide, with an average […]

View
Microsoft Visio 2019
lesson
Microsoft Windows 10
lesson

Learn how to master the most essential features of Windows 10 with our 9 hr course. We will introduce you to new Windows features […]

View
Microsoft Teams
lesson / 5h 0m

Microsoft Teams is becoming the new way to communicate. This comprehensive Microsoft Teams Online Course shows you how to get started with Teams and […]

View
Microsoft Windows 11
lesson / 4h 0m

Master the essential features of Microsoft Windows 11 in this detailed beginners course.

View
Microsoft Word 2016
lesson

The ability to efficiently produce proposals, reports and a host of other business documents is an extremely valuable and transferable business skill. Such documents […]

View
Microsoft Word 2019
lesson

The ability to efficiently produce proposals, reports and a host of other business documents is an extremely valuable and transferable business skill. Such documents […]

View
Advanced Microsoft Word 2019
lesson / 15h 0m

In this detailed Advanced Word course, we look at many of Microsoft Word’s advanced functions that you may never have seen before.

View
Microsoft Access 2013 Beginners
lesson
Microsoft Access 2016 Beginners
lesson
Microsoft Excel 2016
lesson

Microsoft Excel, the world’s most popular spreadsheet software, is designed to help users perform a myriad of business tasks, from to-do lists to forecasts […]

View
Microsoft Excel 2019
lesson

Microsoft Excel, the world’s most popular spreadsheet software, is designed to help users perform a myriad of business tasks, from to-do lists to forecasts […]

View
Microsoft OneNote 2016
lesson

OneNote is a hidden gem with immense potential that goes beyond simple note-taking. Whether for business purposes or personal use, this simple tool will […]

View
Microsoft Outlook 2019
lesson

Email is the most widely used form of business communication, but also one of the main causes of lost productivity in the workplace. Managing […]

View
Microsoft Outlook 2021
lesson / 6h 0m

In this Outlook 2021 course, we will fast-track your email management knowledge, meaning you spend less time on email admin and more time on […]

View
Microsoft PowerBi
lesson / 7h 0m

Power BI enables business users to interact with corporate information and to extract the reports and intel they need. This course will show you […]

View
Microsoft Powerpoint 2016
lesson

Whether for briefing internal colleagues or pitching to clients, presenting is at the heart of business life. Successful presentations have the power to create […]

View
Power Pivot, Query and Dax
lesson / 4h 0m

Utilizing Power Pivot, Power Query, and DAX allows you to manipulate, analyse, and evaluate millions of rows of data from Excel or other databases. […]

View
Power Bi Beyond The Basics
lesson
Power Automate for Beginners
lesson / 3h 0m

Power Automate is the automation tool from Microsoft designed to help improve your productivity and reduce the number of repetitive tasks you need to […]

View
Microsoft PowerPoint 2021
lesson / 8h 0m

This PowerPoint 2021 course will teach you how to create contemporary, visually stunning, and creative PowerPoint presentations from scratch. We start by going over […]

View
Microsoft Powerpoint 2019
lesson

Whether for briefing internal colleagues or pitching to clients, presenting is at the heart of business life. Successful presentations have the power to create […]

View
Advanced Microsoft Excel 2019
lesson

Microsoft Excel provides a range of advanced functions that greatly extend its capabilities. Powerful analysis, forecasting, automation and presentation techniques offer wide-ranging business benefits […]

View
Excel for Business Analysts
lesson

Microsoft Excel provides a range of advanced functions that greatly extend its capabilities. Powerful analysis, forecasting, automation and presentation techniques offer wide-ranging business benefits […]

View
Advanced Pivot Tables in Excel
lesson / 10h 0m

In this Advanced Pivot Tables in Excel course, we teach you how to make the most of the powerful PivotTable function in Excel.

View
Excel Dashboards
lesson

Microsoft Excel provides a range of advanced functions that greatly extend its capabilities. Powerful analysis, forecasting, automation and presentation techniques offer wide-ranging business benefits […]

View
Advanced Fomulas in Excel
lesson

Microsoft Excel provides a range of advanced functions that greatly extend its capabilities. Powerful analysis, forecasting, automation and presentation techniques offer wide-ranging business benefits […]

View
Microsoft Advanced Access
lesson
Advanced Microsoft Projects 2019
lesson

Work smarter, not harder. Microsoft Project is a feature-rich tool that will help a project manager plan, track, and control a project and facilitate […]

View
Advanced VBA
lesson

You’ve completed the beginner course in VBA, or have some experience. Now challenge yourself with the next step. Advanced VBA is a learner-friendly course […]

View