AgManager.info: 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.

INSTRUCTOR:
Dr. Rich Llewelyn

Tips for using Excel (PDF)

Date	Location	Brochure	Contact Info
January 9, 2013	Kingman Kingman County Activity Center 121 South Main St.	Download	Matt Clark: 620.532.5131, mkc@ksu.edu
January 25, 2013	Wamego Highland Community College 500 Miller Drive	Download	Austin Sexten: 785.457.3319, ajsexten@ksu.edu
Postponed until: March 4, 2013 due to snow on 2/21/2013.	Troy Doniphan County 4-H Building 211 N. Boder St	Download	Mindy Young: 785.985.3623, myoung5@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.