Excel 2: Making sense of Excel data

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

Leave a comment

Your email address will not be published. Required fields are marked *