- Business Skills
- Microsoft Office Digital Skills by FILTERED
- Analysing Large Datasets in Excel: Mini Masterclass
- Lesson
Analysing Large Datasets in Excel: Mini Masterclass
- 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 learn how to clean raw data in a spreadsheet using VLOOKUP and HLOOKUP to find a value, and combine INDEX and MATCH to create a two way lookup.
We will also cover how to use the IF function to perform a logical test and practice creating nested IF statements. Whether you’re categorising data, calculating metrics, or making data-driven decisions, these functions provide a robust framework for handling large datasets and deriving valuable insights
Watch Content PreviewEager to take your PowerPoint skills to the next level and utilise the newest features Microsoft offers? If so, this Microsoft PowerPoint 365 for […]
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 […]
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 […]
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 […]
In this course, you will delve into advanced techniques using the newly released dynamic array functions by Microsoft 365. Discover the power of TOCOL […]
This course will explore the essential Excel lookup functions — VLOOKUP, XLOOKUP, INDEX, and MATCH. You will gain a profound understanding of VLOOKUP and […]
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, […]
This empowering course will equip you with the skills to effectively manage and validate user inputs, ensuring data accuracy and reliability in Excel workbooks. […]
This course, Formula Auditing in Excel, is an exploration into the intricacies of managing and understanding complex formulas, designed to empower you with the […]
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 […]
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 […]
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 […]
Functions and formulas are the heart of Excel, enabling you to perform calculations, manipulate data, and automate tasks. There are five functions that are […]
This course is aimed at learners with basic knowledge of Excel, and are looking to understand the versatile software better. Excel, a powerful spreadsheet […]
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 […]
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 […]
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 […]
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 […]
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 […]
In the course, Ten Essential Excel Formulas to Master, you will learn the fundamental Excel formulas that are crucial for data analysis and manipulation. […]
Welcome to Mastering Microsoft 365 SharePoint Online: The Essential Guide. If you seek an application that combines document storage, team collaboration, and seamless integration […]
Unlock the full potential of PowerPoint and take your presentations to the next level with our training course, PowerPoint Tips to Maximise Your Efficiency […]
Address Excel bad habits and equip you with practical solutions to boost your productivity and make a lasting impact in this comprehensive training course. […]
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 […]
Transform raw data into valuable information through meticulous data cleaning and preparation in this training course. From dealing with messy spreadsheets, inconsistent formatting, or […]
Elevate your data presentation skills efficiently with impactful charts that leave a lasting impression with this training course. This course will help equip you […]
In this course, you will learn how to assign meaningful names to cell ranges and tables and understand how to use names in formulas […]
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 […]
Successful enterprises make the most out of the information available to them. They derive value from the numbers driving their business – and this […]
In this second course of our Excel 2021 series, we build on the skills learned in the beginners’ Excel course. This course will teach […]
In this third course of our Excel 2021 series, we build on the skills learned in the beginners’ and intermediate Excel courses. This course […]
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 […]
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 […]
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 […]
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 […]
SharePoint has been referred to as the ‘Swiss Army Knife’ of collaboration software suites. It has over 100 million users worldwide, with an average […]
Learn how to master the most essential features of Windows 10 with our 9 hr course. We will introduce you to new Windows features […]
Microsoft Teams is becoming the new way to communicate. This comprehensive Microsoft Teams Online Course shows you how to get started with Teams and […]
Master the essential features of Microsoft Windows 11 in this detailed beginners course.
The ability to efficiently produce proposals, reports and a host of other business documents is an extremely valuable and transferable business skill. Such documents […]
The ability to efficiently produce proposals, reports and a host of other business documents is an extremely valuable and transferable business skill. Such documents […]
In this detailed Advanced Word course, we look at many of Microsoft Word’s advanced functions that you may never have seen before.
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 […]
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 […]
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 […]
Email is the most widely used form of business communication, but also one of the main causes of lost productivity in the workplace. Managing […]
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 […]
Power BI enables business users to interact with corporate information and to extract the reports and intel they need. This course will show you […]
Whether for briefing internal colleagues or pitching to clients, presenting is at the heart of business life. Successful presentations have the power to create […]
Utilizing Power Pivot, Power Query, and DAX allows you to manipulate, analyse, and evaluate millions of rows of data from Excel or other databases. […]
Power Automate is the automation tool from Microsoft designed to help improve your productivity and reduce the number of repetitive tasks you need to […]
This PowerPoint 2021 course will teach you how to create contemporary, visually stunning, and creative PowerPoint presentations from scratch. We start by going over […]
Whether for briefing internal colleagues or pitching to clients, presenting is at the heart of business life. Successful presentations have the power to create […]
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 […]
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 […]
In this Advanced Pivot Tables in Excel course, we teach you how to make the most of the powerful PivotTable function in Excel.
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 […]
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 […]
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 […]
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 […]
Get in Touch
"*" indicates required fields