Tutorial – Automatically extracting or merging cells

This training module includes the following elements

  1. How to format numbers in Excel?
  2. Text orientation and alignment
  3. Sorting data
  4. Filtering your data
  5. Automatically extracting or merging cells.
  6. Creating a dropdown menu


  • In Excel, a common task is extracting text from a cell (like a name) or combining results from multiple cells.
  • An integrated tool, known as "Flash Fill", automates this process, enhancing efficiency for users.
  • Let's see how it works

Merge firstname and lastname


This quiz must be completed in 15 minutes.