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