Understand how to prepare Excel data through logical functions, nested formulas, lookup functions, and PivotTables.
Overview
Syllabus
- Starting Data Preparation in Excel
- In this chapter, you’ll learn different ways to source and import your raw data into Excel. You will then start your preparation of raw data by removing duplicates added in error and filling in the missing parts of your data that will help you prepare the best dataset for analytical use.
- Functions for Data Preparation
- In this chapter, you’ll learn how to use text category functions to combine text strings with useful variables for better analysis. You will also utilize some of Excel's date and time functions, taking simple date columns to a new level.
- Conditional Formulas
- In this chapter, you’ll learn how to use logical functions to create conditional formulas for new flags and filters for your data. You will combine the logical operators to create nested formulas, specifically using the IF function to create new category data. Additionally, you will understand how to differentiate between notes and comments in Excel and use them effectively to share information with others.
- Lookups and Data Transformation
- In this chapter, you’ll finish by looking at some important lookup and reference functions available within Excel, specifically the VLOOKUP and HLOOKUP functions. Additionally, you’ll be introduced to the powerful world of PivotTables, which helps you summarize and analyze large volumes of data through dynamic tables.
Taught by
Iason Prassides