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.