Overview

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.

Learning Outcomes

• Discover how to clean the raw data in the spreadsheet using Excel tools.
• Understand how to use the VLOOKUP and HLOOKUP functions to lookup a value.
• Combine the INDEX and MATCH functions to create a dynamic two-way lookup.
• Explore how to use the IF function to perform a simple logical test and return one value if TRUE and another if FALSE. 
• Practice creating Nested IF Statements to incorporate additional criteria for more powerful decision-making.

Audience

Anyone looking to explore the basics of Excel.