Making confident, profit-focused farm business decisions in a volatile farm economy is not easy. Applying high-level farm financial analysis is key in your farm’s long-term success. We’re here to help!
Excel is an incredibly powerful program but many of you have just scratched the surface with its functionality. This course is dedicated to how you can incorporate high-level data analysis skills with the goal of protecting and growing your farm’s bottom line.
The vast majority of the most successful farms we’ve worked with use spreadsheets extensively. Are they perfect, heck no! That’s why we’re developing powerful farm-focused farm business software. But spreadsheets are here to stay.
In an ever-changing commodity-based business, spreadsheets give you the confidence to make profit-focused and numbers-based farm business decisions.
If you’re currently using spreadsheets in your farm business…or would like to use them more often…this course is for you. I guarantee you’ll learn something new and valuable to your operation.
The tools and techniques offered in the course are backed up by building 1,000’s of farm and non-farm related spreadsheets. Many of the formulas presented in this course were learned while I worked at one of the most successful private equity firms in the US, ShoreView Industries ($900 million of capital managed). I love applying this functionality in farm-focused analysis.
Excel for Farmers Course is a 14-day email-based course (the demo button listed on the site is for our farm management software, not this Excel course).
We’ve chosen to release this course via email so you will have it available “at your fingertips” and you can file it away for future reference. Each lesson of this course will be focused on a farm-based use case.
The course will have two primary components over the 14 days.
- We’re going to focus on 10 Excel formulas and how they can be used in your farm business.
- We’re going to be building 4 powerful spreadsheet tools that will help you become a farm spreadsheet Ninja!
Important note: Even though some have already begun the course, everyone who signs up will begin on Day 1. No matter what date you sign up, you’ll start at the beginning of the course. Sign up at anytime (although the sooner the better before the price goes up)!
We’ll be simply giving you the spreadsheets we build for you to do whatever you want with them.
Our advisors told me to price the course at $149 with the reasoning being “if your users successfully implement only one of these tools it’s worth much more than that” but I didn’t listen. I want this course to be available to anyone.Much of this content comes from our comprehensive and highly-reviewed Business of Farming course we released last spring. See below what one of our users had to say about to me recently about the Excel tutorials from this course.
Great work on the Excel tutorials. After 6 months, I still refer back to the videos. Thanks!
The course will cover farm-based applications of formulas you may be familiar with:
- And more….
And some you may not be familiar with.
- Data tables
- Using data validation to create drop-down lists
- And more….
In addition to Excel fucntionality we’re going to show you how to implement high-level statistical analysis methods into your farm data analysis.
There’s a general rule-of-thumb regarding the effectiveness of data analysis that can be summed up as follows, “Those that benefit the most from data analysis, are those that interact the most with the data.” What business has more data than a modern family farm?! To benefit from your data, you need to interact with it.
Applying statistical analysis to data is what professional farm businesses do on a daily basis.
Thanks for a great two week course on tools in Excel. Definitely refreshed some things and taught me other new features. Well worth my time and money!! Was very convenient to follow on my schedule. Thanks again!!
Studying formulas is great, but we’re also going to build some real world tools. See below for a few of them.
Note that I’ll give you these spreadsheets so you don’t have to build from scratch!
Price and Yield Probability Models
These models use implied price volatility (from the options markets) and historical yield volatility on your farm to create probabilites for future yields and prices. No model is perfect. This tool is simply meant to introduce you to how we can apply statistical thinking to farm decision making.
Variable Input Price Calculators
The example shown below is a fertilizer caculator that will show you how you can build multi-variable cost calculations easily in Excel. I bet I’ve used this simple fertilizer calculator 100+ times the last 12 months (yes, I’m a numbers nerd). I bet you’ll find it valuable too!
Field-by-field and Total Farm Financial Tracking Tool
We’ll build a comprehensive farm P&L tracking tool. Similar to the above comment, an advisor told me “Why the heck would you include this? It competes with your own software!”. What a fun hater! Frankly, our software is a kick ass product and will only get better. But it isn’t for everyone. This tracking tool can be used by those that aren’t ready for a software package like ours. When you are, we’ll be waiting for you!!
Just finished your 14-part Excel course and I loved it. Tons of information I have already put to use.
We’d love to have you join us for our 14-day Excel for Farmers Master Class.
We’re ready to get started when you’re ready!
A profit-focused approach is a key trait of successful farmers. In this post, we discuss a simple farm management software feature that allows producers to easily build a field-by-field budget. This feature allows producers to build a budget, update it throughout the growing season, and view actual and historical performance post-harvest.Read More »
Small changes can lead to large increases in farm profitability. Farms should focus on making incremental improvements to yield and price while reducing overhead expenses. This ROI-focused approach is a key step in building a successful business, farm businesses included.Read More »