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