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 Excels most well-known and widely-used functions.In this course, youll start by using various string and data manipulation functions to clean data and fill in missing values.Next, youll perform simple data validation based on specific numeric thresholds and text lengths, before moving on to validation using lists. Youll then combine data validation to implement a formidable, dynamic data validation mechanism using named ranges and the INDIRECT formula.Finally, youll 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.