At the end of this workshop, you will be able to:

Insert data in cells and ranges

  • Replace data
  • Cut, copy or paste data
  • Paste data by using special paste options
  • Fill cells by using Auto Fill
  • Insert and delete cells

Format cells and ranges

  • Merge cells
  • Modify cell alignment and indentation
  • Format cells using Format Painter
  • Wrap text within cells
  • Apply number formats
  • Apply cell formats
  • Apply cell styles

Summarise and organise data

  • Insert sparklines
  • Outline data
  • Insert subtotals
  • Apply conditional formatting