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
 

October

SMTWTFS
12345
6789101112
13141516171819
20212223242526
2728293031

Wednesday, October 2, 2019

1:30pm - 4:00pm

Instructor