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

Search AgManager.Info:


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

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.

Dr. Rich Llewelyn
Tips for using Excel (PDF)


Date Location Brochure Contact Info
January 11, 2016 HAYS
Ellis County Extension Office
Meeting Room
601 Main St.


Stacy Campbell
785-628-9430, scampbel@ksu.edu
January 14, 2016 PARSONS
Frontier Farm Credit
2005 Harding Dr.


Keith Martin
620-784-5337, rkmartin@ksu.edu
January 15, 2016 HUTCHINSON
Reno County Extension Office
Meeting Room
2 W. 10th St.


Darren Busick
620-662-2371, darrenbusick@ksu.edu
February 1, 2016 HERINGTON
Herington Community Center
20 N. Broadway St.


Rickey Roberts
620-382-2325, rroberts@ksu.edu 
February 3, 2016 MANHATTAN
Women Managing the Farm
Hilton Garden Inn


Janel Koons
800-321-3276, jksu@ksu.edu 
February 24, 2016 JETMORE
Hodgeman County 4-H Building
1005 Atkin St.


DeWayne Craghead
620-357-8321, dcraghea@ksu.edu
Register at: hg@listserv.ksu.edu 


(see brochure for individual locations)
9:30 - 10:00 am Registration
10:00 - 10:15 am

Introduction to Excel  

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

10:15 - 11:00 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

11:00 - 11:15 am Break
11:15 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:30 pm

Introduce Decision Tools on AgManager.info

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

2:30 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