FSA Tip #19 Refer to things with INDEX MATCH

A good spreadsheet should play well with other spreadsheets. That means if you enter something into one spreadsheet, then you can easily refer to another spreadsheet that has additional information about that same something. Here’s an example … Say you are setting up a schedule for all the crops you are going to direct seed. … More FSA Tip #19 Refer to things with INDEX MATCH

FSA Tip #17 Take Things Apart With The MID And FIND Formulas

Last tip we joined things together with the Ampersand. Now we’re going to take them apart. Unfortunately taking them apart is a little more work. Fortunately I’ve got you covered with this tip! In this tip, we’ll see … How to use the MID formula to extract the beginning portion of text in a spreadsheet … More FSA Tip #17 Take Things Apart With The MID And FIND Formulas

FSA Tip #16 Join Things Together With Ampersand And Other Formulas

What is an Ampersand? An ampersand is the AND symbol. That classic “&” that you can use to save space from all those extra letters that come with AND. You can use the Ampersand just about the same way in spreadsheets! It unites things to make longer things. In this video, I’ll show you how … More FSA Tip #16 Join Things Together With Ampersand And Other Formulas

FSA Tip #15 Quickly Fill Your Spreadsheet With The Fill Handle

In many spreadsheets we wind up entering the same date over and over. You can use copy paste to speed up your data entry, but there’s another tool that is even quicker. The FILL HANDLE!!!!! With the fill handle you can quickly drag data to fill cells in your spreadsheets. In this video, I’ll show … More FSA Tip #15 Quickly Fill Your Spreadsheet With The Fill Handle