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