If you don’t know about Data Validation in spreadsheets, this tool will blow your mind! With Data Validation, you can make sure your users enter information into cells the right way. There are different options to use Data Validation, but the one we explore in the video is to create a drop-down menu for each … More FSA Tip #14 Data Validation
You probably spend a lot of time scrolling through spreadsheets with your mouse clicking on this cell or that. Have you ever wished you could get to the right cell quicker? If so, this tip if for you! It covers 3 keyboard shortcuts to scoot around your spreadsheets and 1 bonus shortcut that lets you … More FSA Tip #8 Quickly Navigate Your Spreadsheets With Keyboard Shortcuts
This farm spreadsheet tip goes back to basics. Before you start setting up your Farm Spreadsheet System, you’ve got to decide on a spreadsheet application. Where to start among all the available options? I’ve got 5 considerations for you to evaluate different spreadsheet apps. I also explain why I use Google Sheets for my farm … More FSA Tip #7 How To Choose A Spreadsheet System
This spreadsheet tip follows up my post about our seed room. In it I look at the basics of how we manage our seed inventory through a spreadsheet. It is easy to try to make a spreadsheet row do too much. But by breaking down one row into multiple rows, you can get more detail … More FSA Tip #6 Every Row Tells A Story
Anchoring cells in a formula ensures that you are referring to the right cells when you reuse the same formulas elsewhere in your spreadsheet. … More FSA Tip #5 Anchoring Cells
SUMIF let’s you SUM up certain cells IF they meet certain conditions. … More FSA Tip #4 Sumif and Sumifs!
This week’s farmer spreadsheet tip is about using week numbers instead of dates in your spreadsheets. Week numbers are a critical piece of how I crop plan. They make it much easier to sort and look at information on a weekly basis rather then get bogged down with how there are 7 different days in each week. Are … More FSA Tip #3 Week Numbers