Skip to main

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
 

Thursday, September 3, 2020

9:00am - 12:00pm

September

SMTWTFS
12345
6789101112
13141516171819
20212223242526
27282930

Instructor