K-State AgManager.info website
  About     Contributors     Useful links     Site map      Feedback  

Search AgManager.Info:

 

K-State AgManager.info website
Agribusiness
Crops
Energy
Farm Management
Livestock & Meat
Policy
Decision Tools
--------------------
Ag Econ News
Contributors
Programs
Sponsors
Upcoming Events
Presentations Archive
--------------------
K-State Dept. of Agricultural Economics
--------------------
Department Theses & Dissertations
--------------------
KFMA
--------------------
SIGN-UP for Weekly Email Updates
--------------------
--------------------
--------------------
PFT
AgManager.info: Excel Workshops
   Home / Events / Excel Workshops

2015
Excel Workshops

Program Description

The ability to use Excel spreadsheets allows users to have the capability to benefit from the many Excel calculators and tools publicly available. These day-long workshops will provide hands-on Excel training. The workshops will use laptop computers to allow participants to create their own spreadsheets. Various spreadsheets will be created which will teach the following skills: creating appropriate mathematical formulae and using the correct functions, linking between sheets, using absolute and relative references, formatting, copying, look-up tables, and what-if analysis. In addition, a portion of the afternoon session will introduce several of the Excel tools on the AgManager.info website and allow participants to use these tools in a situation where they can ask questions of the workshop presenters.

INSTRUCTORS:
Dr. Rich Llewelyn
Tips for using Excel (PDF)

 

Date Location Brochure Contact Info
January 20, 2015 GARDEN CITY
Finney County Extension Office
501 S. 9th St.

Download

David Coltrain: 620-272-3670, coltrain@ksu.edu
       
       

 

APPROXIMATE SCHEDULE
(see brochure for individual locations)
TIME EVENT or TOPIC
9:00 - 9:30 am Registration
9:30 - 10:00 am

Introduction to Excel  

Discuss tips and ways to use Excel, including tricks which are helpful.

10:00 - 10:45 am

Spreadsheet 1: Estimating Machinery Costs

Participants create a spreadsheet to estimate machinery costs on their farm. This will utilize the "Sum" and "Sumproduct" functions, as well as routine mathematical calculations

10:45 - 11:00 am Break
11:00 am - 12:00 pm

Spreadsheet 2: Crop Budgets

Develop a spreadsheet with crop budgets, which link input cost information from other sheets, to calculate breakeven prices and yields and to use what-if analysis to view the effects of changes in price and costs on the breakeven values.

12:00 - 12:45 pm Lunch
12:45 - 1:30 pm

Spreadsheet 3: Principal and Interest Payments

Develop a spreadsheet to determine principal and interest payment and the sales needed to cover loan payments, utilizing financial functions in Excel.

1:30 - 2:15 pm

Spreadsheet 4: Adjusted Weaning Weights

Calculate the adjusted weaning weight of beef calves, using "If" functions and look-up tables.

2:15 - 2:45 pm

Introduce Decision Tools on AgManager.info

Introduce and demonstrate several of the spreadsheet decision tools on AgManager.info.

2:45 - 3:00 pm Summary and Questions
3:00 pm Adjourn

 

For more information, contact Rich Llewelyn at the phone or email below:
Phone: 785-532-1504  Email: rvl@ksu.edu

Notice of Nondiscrimination Kansas State University is committed to nondiscrimination on the basis of race, sex, national origin, disability, religion, age, sexual orientation, or other non-merit reasons, in admissions, educational programs or activities and employment (including employment of disabled veterans and veterans of the Vietnam Era), as required by applicable laws and regulations. Responsibility for coordination of compliance efforts and receipt of inquiries concerning Title VI of the Civil Rights Act of 1964, Title IX of the Education Amendments of 1972, Section 504 of the Rehabilitation Act of 1973, the Age Discrimination Act of 1975, and the Americans With Disabilities Act of 1990, has been delegated to Clyde Howard, Director of Affirmative Action, Kansas State University, 214 Anderson Hall, Manhattan, KS 66506-0124, 785-532-6220. Revised April 28, 2003.

 
Department of Agricultural Economics   K-State Research & Extension   College of Agriculture   Kansas State University