Target audience: Farm Managers
This course begins with the essential vocabulary of spreadsheets and databases and moves the student into designing, formatting and creating a formatted, consolidated workbook with formulas, functions, and range references. The workbook will be used for budgets and cash flows on a simple case study. The purpose of the workbook will be to learn the features of Excel that simplify data analysis. The case study data will be used for sensitivity analysis, scenarios, goal seek and break-even analysis using data tables. An expansion on the case will allow several years data to be studied for trends using outlining tools, pivot-tables, and pivot charts.
Contact hours: 8 hours