- 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 Preview![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/12/680x440-Excel-PivotTable-and-PivotChart.jpg)
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/12/680x440-Excel-PivotTable-and-PivotChart-640x414.jpg)
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/03/PowerPoint-365-380x214.jpg)
Eager to take your PowerPoint skills to the next level and utilise the newest features Microsoft offers? If so, this Microsoft PowerPoint 365 for […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/06/Using-the-Data-Model-with-Pivot-Tables-course-image-380x214.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/06/15-Essential-Advanced-Excel-Formulas-course-image-1-380x214.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/06/Cleaning-Data-in-Power-Query-course-image-1-380x214.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/06/New-Dynamic-Array-Functions-course-image-1-380x214.jpg)
In this course, you will delve into advanced techniques using the newly released dynamic array functions by Microsoft 365. Discover the power of TOCOL […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/06/Mastering-Excel-Lookup-Functions-course-image-1-380x214.jpg)
This course will explore the essential Excel lookup functions — VLOOKUP, XLOOKUP, INDEX, and MATCH. You will gain a profound understanding of VLOOKUP and […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2024/06/Excel-365-Intermediate-1-380x214.jpg)
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, […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Excel-380x246.jpg)
This empowering course will equip you with the skills to effectively manage and validate user inputs, ensuring data accuracy and reliability in Excel workbooks. […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Excel-380x246.jpg)
This course, Formula Auditing in Excel, is an exploration into the intricacies of managing and understanding complex formulas, designed to empower you with the […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Excel-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Excel-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/12/680x440-Excel-PivotTable-and-PivotChart-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/12/680x440-Excel-PivotTable-and-PivotChart-380x246.jpg)
Functions and formulas are the heart of Excel, enabling you to perform calculations, manipulate data, and automate tasks. There are five functions that are […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/12/680x440-Excel-PivotTable-and-PivotChart-380x246.jpg)
This course is aimed at learners with basic knowledge of Excel, and are looking to understand the versatile software better. Excel, a powerful spreadsheet […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/12/680x440-Excel-PivotTable-and-PivotChart-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/12/680x440-Excel-PivotTable-and-PivotChart-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/12/680x440-Excel-PivotTable-and-PivotChart-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Office-365-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Windows-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Excel-380x246.jpg)
In the course, Ten Essential Excel Formulas to Master, you will learn the fundamental Excel formulas that are crucial for data analysis and manipulation. […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Sharepoint-380x246.jpg)
Welcome to Mastering Microsoft 365 SharePoint Online: The Essential Guide. If you seek an application that combines document storage, team collaboration, and seamless integration […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Powerpoint-380x246.jpg)
Unlock the full potential of PowerPoint and take your presentations to the next level with our training course, PowerPoint Tips to Maximise Your Efficiency […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Excel-380x246.jpg)
Address Excel bad habits and equip you with practical solutions to boost your productivity and make a lasting impact in this comprehensive training course. […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Outlook-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Excel-380x246.jpg)
Transform raw data into valuable information through meticulous data cleaning and preparation in this training course. From dealing with messy spreadsheets, inconsistent formatting, or […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Excel-380x246.jpg)
Elevate your data presentation skills efficiently with impactful charts that leave a lasting impression with this training course. This course will help equip you […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/11/680x440-Excel-380x246.jpg)
In this course, you will learn how to assign meaningful names to cell ranges and tables and understand how to use names in formulas […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
Successful enterprises make the most out of the information available to them. They derive value from the numbers driving their business – and this […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
In this second course of our Excel 2021 series, we build on the skills learned in the beginners’ Excel course. This course will teach […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
In this third course of our Excel 2021 series, we build on the skills learned in the beginners’ and intermediate Excel courses. This course […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Microsoft-Project-2019-Advanced-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/04/sharepoint-380x246.jpg)
SharePoint has been referred to as the ‘Swiss Army Knife’ of collaboration software suites. It has over 100 million users worldwide, with an average […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/04/office-380x246.jpg)
Learn how to master the most essential features of Windows 10 with our 9 hr course. We will introduce you to new Windows features […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/09/Microsoft-Teams-380x246.jpg)
Microsoft Teams is becoming the new way to communicate. This comprehensive Microsoft Teams Online Course shows you how to get started with Teams and […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/09/Microsoft-Windows-11-380x246.jpg)
Master the essential features of Microsoft Windows 11 in this detailed beginners course.
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Microsoft-Word-Advanced-380x246.jpg)
The ability to efficiently produce proposals, reports and a host of other business documents is an extremely valuable and transferable business skill. Such documents […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Microsoft-Word-Advanced-380x246.jpg)
The ability to efficiently produce proposals, reports and a host of other business documents is an extremely valuable and transferable business skill. Such documents […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Microsoft-Word-Advanced-380x246.jpg)
In this detailed Advanced Word course, we look at many of Microsoft Word’s advanced functions that you may never have seen before.
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/04/onenote-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/04/outlook-380x246.jpg)
Email is the most widely used form of business communication, but also one of the main causes of lost productivity in the workplace. Managing […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/09/Microsoft-Outlook-2021-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Power-BI-Beyond-Basics-380x246.jpg)
Power BI enables business users to interact with corporate information and to extract the reports and intel they need. This course will show you […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Microsoft-Power-Automate-380x246.jpg)
Whether for briefing internal colleagues or pitching to clients, presenting is at the heart of business life. Successful presentations have the power to create […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/09/Microsoft-Power-Automate-380x246.jpg)
Utilizing Power Pivot, Power Query, and DAX allows you to manipulate, analyse, and evaluate millions of rows of data from Excel or other databases. […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2023/09/Microsoft-Power-Automate-380x246.jpg)
Power Automate is the automation tool from Microsoft designed to help improve your productivity and reduce the number of repetitive tasks you need to […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Microsoft-Power-Automate-380x246.jpg)
This PowerPoint 2021 course will teach you how to create contemporary, visually stunning, and creative PowerPoint presentations from scratch. We start by going over […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Microsoft-Power-Automate-380x246.jpg)
Whether for briefing internal colleagues or pitching to clients, presenting is at the heart of business life. Successful presentations have the power to create […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
In this Advanced Pivot Tables in Excel course, we teach you how to make the most of the powerful PivotTable function in Excel.
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Microsoft-Project-2019-Advanced-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/03/Excel-Courses-380x246.jpg)
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 […]
![](https://lpshowcase.learningpool.com/wp-content/uploads/2022/01/Banner-6-1920x600-1.jpg)
Get in Touch
"*" indicates required fields