In this class, we will explore how to:
-
Use the Text to Columns feature to split data into multiple columns
-
Combine, extract, or separate data quickly with Flash Fill
-
Utilize the CONCAT function to create text strings with data across multiple columns
-
Generate unique lists of data using Remove Duplicates
-
Combine data from one or more worksheets using the Consolidate tool
-
Reference data between lists using the VLOOKUP and HLOOKUP functions
-
Prevent data changes by locking down worksheets with Protection features
-
Automate repetitive tasks by recording Macros