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
 

Request this session for your group

In addition to any upcoming scheduled times noted under "Upcoming sessions," this session is also available by request for groups.

Use this form to request this session. You’ll receive a response by email as soon as possible, typically within one week, to discuss scheduling and more details. We appreciate requests made at least one month in advance.