#Free business expense tracker template software#
#Free business expense tracker template free#

Now that you know the basics of making an epic spreadsheet, check out these genius ways to use spreadsheets to manage and grow your business. Related 7 Tips for Writing Successful Marketing Emails Hiring and Growth

In the source field, click the small icon and select the list of values for the dropdown.

Click the Data tab and then the Data Validation button.

Select the cell where you want the dropdown to appear.

Each item should be entered into its own cell.

Enter the items you want to appear in the dropdown list in the cells in column A.

Enter the items you want to be able to select from the dropdown.

Select the cell you want the dropdown to appear in.

Want to cut down the amount of typing you do into your spreadsheet? Add a dropdown list! If there is an error, it tells the spreadsheet to enter a value of zero. To get rid of this warning while maintaining the formula, use the IFERROR function, which tells the spreadsheet what to put in the cell if thereвЂ™s an error.ДЇor example, the formula =IFERROR (A1/B1, 0) tells the spreadsheet to divide B1 by A1 if thereвЂ™s no error. You get something that looks like this: #DIV/0! This is the spreadsheetвЂ™s way of telling you that it doesnвЂ™t have the information it needs to complete the function.

Click and drag the formula down or across the cells you want to copy it to.ДЄ SUPER annoying thing happens if you copy a formula with division in it and the cells involved in the function are empty.

Hover your cursor over the square until it turns into a cross.

On the bottom left of the cell, a small square will appear.

Click on the cell with the formula you wish to copy.Instead of having to type in the sum formula every time, you can drag the formula across multiple cells. LetвЂ™s say you want to add up column A1 through A25, and then you want to add column B1 through B25, and column C1 through C25. Think of the вЂњ:вЂќ as a shortcut for вЂњthrough.вЂќ For example, if you enter the formula =SUM(A1:A25), cells A1 through A25 will be added up. This is awesome if you have a long column of numbers you need to add up. The SUM formula adds up a selected range of cells. In spreadsheets, the function in the innermost parentheses happens first, and then the order works its way outwards. Then the difference is multiplied by 0.50 (aka 50%). Translation:В Sum of cells A1 and B1 minus the sum of cells C1 and D1. HereвЂ™s a translation of the following formula: Just like in your seventh-grade math class, adding parentheses to your formulas allows you to create more complex formulas. Pick a cell where you want the final value to appear, enter an equal sign (=), and follow the examples below for each function: Use the following symbols to perform basic mathematical functions in your spreadsheet. These are some of my favorite spreadsheet formulas and tips: You donвЂ™t have to be a numbers genius to create a super useful spreadsheet.

#Free business expense tracker template free#

You can opt to make a one-time investment in Excel or use Google Sheets, which is free with any Google account. The best part? Spreadsheets are super inexpensive. In fact, you could probably run your entire business with just spreadsheets. Nowadays, there are a bunch of fresh new ways to turn the old school spreadsheet into a business management tool. Spreadsheets have evolved so much since the days of pivot tables and nested formulas.

#Free business expense tracker template software#

Because sometimes even the niftiest software canвЂ™t stand up to an old standby: the spreadsheet.