Analysing Large Datasets Using Excel: Mini Excel Masterclass Series

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.