Using Farm Data - Course 2 Outline

Telephone 0800 273 337

Session 1 - Getting to know Excel

By the end of this session you will be able to:

  • Identify potential uses of Excel in relation to your farm business
  • Move around spreadsheets using your mouse, arrow and tab keys
  • Rename and save a spreadsheet to a specific folder
  • Create a "shortcut"
  • Identify different cell format types used e.g. text, number and formula

Session 2 - Next steps in Excel

By the end of this session you will be able to:

  • Enter and update text and numbers
  • Edit columns and rows
  • Copy and paste information
  • Format the cells (colour, bold, font, text wrapping, decimal places)

Session 3 - Organise information and formulae

By the end of this session you will be able to:

  • Find and replace data
  • Sort and filter data
  • Show and hide columns
  • Create formulae

Session 4 - Farm Management tools

By the end of this session you will be able to:

  • Identify potential uses of specialist farming software for your farm business
  • Identify areas for further learning