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
 

Wednesday, October 7, 2020

1:00pm - 4:00pm

Sign up in myUK

October

SMTWTFS
123
45678910
11121314151617
18192021222324
25262728293031

Instructor