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

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.