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
 

November

SMTWTFS
12
3456789
10111213141516
17181920212223
24252627282930

Wednesday, November 6, 2019

1:30pm - 4:00pm

Instructor