Complete Guide to Excel 365: Validating Cleaning & Performing Lookups on Data

“Excel is not only used for aggregating and analyzing data but also for data cleansing. There are several data cleaning validation and checking techniques avAIlable some of which are among Excel s most well-known and widely-used functions.
In this course you ll start by using various string and data manipulation functions to clean data and fill in missing values.
Next you ll perform simple data validation based on specific numeric thresholds and text lengths before moving on to validation using lists. You ll then combine data validation to implement a formidable dynamic data validation mechanism using named ranges and the INDIRECT formula.
Finally you ll use one-dimensional lookups – the classic HLOOKUP and VLOOKUP worksheet functions – as well as more complex two-dimensional lookups utilizing a combination of INDEX and MATCH.á”