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