Prior knowledge: Basic Excel skills equivalent to Excel1
Format: One hour hands on
This course builds on Excel1 to make spreadsheets that are more robust for data entry and that help to analyse the data that they hold.
This course includes:
- Using conditional formatting to highlight data
- Validating entries using lists
- Using Sparklines to show trends
- Using tables to display data
- Managing sheets, columns and windows
- Using custom cell formats
If you can’t see the course you want scheduled or you want to request a different date/time then please contact digitaltraining@yorksj.ac.uk