|
SE MN | It sounds like I am about in the same place as you. I started farming in 2013, but took on a lot more ground in the last 3 years due to farmers retiring. I have always loved computers and excel even though I never really knew to much about either one, I could get done what I needed. The last three years I have learned more about Excel then my entire life combined. Most of it was through Google and YouTube with AgTalk close third. The largest issue I have had trying to learn something new with Excel is that I would know what I want to do and knew it could do it, but had no idea what they called the function. For instance, when I wanted to reference a specific cell in another one it’s called Vlookup, which is what I used for the first year. Then I learned about Index,Match which is what I use now. Another example is the drop down list, which Excel calls Data Validation and in that you have to select “list” from a drop down.
I attached a small spreadsheet that I have been working on for the last 3 years. I am constantly changing/ adding to it. I feel like it’s pretty easy to use, but then again I made it. I have several different inputs that I keep track of in it. Most of the information only has to be typed in once and then a drop down will supply the tables with the information and all of the tables go to a pivot table for a quick summary.
If you have any questions about it feel free to ask. I am also open to suggestions about what changes could be made. I have attached a few screenshots as well as the Excel file. Maybe it’s not what you are looking for, but it gives you an idea.
(E054E51E-9A5C-4092-B594-26786661A4FE (full).png)
(BA6F967D-7EC0-4E62-A404-AC9019516456 (full).png)
(F4E4780C-02BD-402E-A0B6-E0F754894D9C (full).png)
(CD2C3AF5-05CE-46DE-84D2-C3BDAA938EB2 (full).png)
Attachments ---------------- E054E51E-9A5C-4092-B594-26786661A4FE (full).png (121KB - 150 downloads) BA6F967D-7EC0-4E62-A404-AC9019516456 (full).png (118KB - 133 downloads) F4E4780C-02BD-402E-A0B6-E0F754894D9C (full).png (128KB - 139 downloads) CD2C3AF5-05CE-46DE-84D2-C3BDAA938EB2 (full).png (93KB - 133 downloads) All Inputs spreadsheet-NAT.xlsx (204KB - 139 downloads)
| |
|