View Mobile Site

Harnessing the power of Excel workshop set for July 25

POSTED July 13, 2017 2:19 p.m.

The Women on the Farm Committee is hosting another Workshop set for July 25th. The Workshop topic will be “Harnessing the Power of Excel.” The presenter will be Rich Llewelyn, Extension Assistant, Department of Agricultural Economics, Kansas State University.
This hands-on workshop will help participants to better utilize the power of Excel spreadsheets. Participants will work on five different exercises in Excel designed to develop skills in mathematical calculations and formulas, including equations for breakeven prices and yields and using what-if analysis. They will also learn to use “Sum”, “Sumproduct”, “PMT” and “If” functions, link information from other spreadsheets and create and use look-up tables.
The workshop is entirely hands-on, and attendees will use Excel to create four different spreadsheets, including estimation of machinery costs, budgeting and enterprise analysis, calculating principal and interest payments and analysis of livestock economics. Participants will easily and confidently learn Excel skills by executing them in an interactive setting.
Laptop computers will be provided for use, but participants are encouraged to bring their own. The session is limited to 20 participants.
Rich Llewelyn was raised on a farm near Riley. He is a three-time graduate of K-State with a B.S. degree in Agronomy, and a Masters and PhD in Agricultural Economics. He spent 13 years teaching economics and working with urban and rural community development in East Java, Indonesia before returning to Kansas in 2006 to work with the website and departmental conferences. He has also taught the “Price Analysis and Forecasting” course for undergraduate students at K-State and uses Excel in class as well as for a multitude of projects.
Please join us for the workshop from 1- 4 p.m. on July 25, at the USDA Service Center in Great Bend. Please RSVP by July 18, by calling the Stephanie Royer at 785-222-2615 Ext 101. Please note if there are any accommodations needed. There is no fee thanks to our local sponsors. Snacks will be provided.
USDA is am equal opportunity provider, employer and lender.

Alicia Boor is the Agriculture and Natural Resources agent for Barton County K-state Research and Extension. Contact her by email at or call 620-793-1910.


  • Bookmark and Share

No comments have been posted. Log in or Register to post a comment. encourages readers to interact with one another. We will not edit your comments, but we reserve the right to delete any inappropriate responses. To report offensive or inappropriate comments, contact our editor.

The comments below are from readers of and do not necessarily represent the views of The Newspaper or Morris Multimedia.
To post a comment you must be a registered user of


Please wait ...