Excel for Dummies…er Brilliant Business Moms!

1. To download your orders in Etsy, you will go to “Orders”, and at the bottom of the page “Download a CSV file with the details for each order.” Decide which date spread to download.
2. Once you’ve downloaded your data, save your spreadsheet.
3. Next, it can be helpful to clean up your columns so you are looking at less information. To do this, you will hide the columns you don’t want to see. I’m going to hide some of the columns that are blank. Select the columns by clicking on the column letter, and dragging over to the last column you want to hide. Right-click, select “Hide”.
4. Note that every selected column will be hidden, so if you want some to show, just hide them in sections. To unhide the columns, follow the same steps and click “Unhide”. You’ll know that you have hidden columns if you see missing column numbers at the top.

1. Double-click on the bar to the right of my item title column to expand it to show the full item descriptions. (Mine are looong, because I’m sure to maximize my title SEO!)
2. Click on the number to the left of your Header Row. It should be the first row, row 1. This will highlight the entire row.
3. Click on the “Data” Menu at the top, and select “Filter”. Now you should see a little arrow by each row heading.
4. When you click on the little arrow to the right of your Item Header, a black box pops up with all the items in your item row. Uncheck “Select All” (top of the list), and select one of your items to view. Once you click away from the black box, you’ll see only the items you filtered out.
5. THE CHEATER MATH WINDOW (not his real name): If you want to quickly sum the totals for the items you’ve filtered, click on the column letter above your “Price” column. This selects the entire column. Now you’ll look at the bottom of your Excel window. There is a little cheater math window that says “Sum” (or it may say “Count”). Click on the little black arrow on the right side of the box and you’ll see the variety of information you can get out of this little guy. It’s a great quick way to sum a column without actually entering formulas.
6. To clear your filter, click on the little funnel (formerly an arrow) at the top of your column, and click the checkbox that says “Select All”. Now all your rows will reappear.

1. Click on the little + on the tab at the bottom of your window to create a new worksheet.
2. Rename the Sheet “Totals” by double-clicking on the title.
3. Select a Cell, any Cell, and type “Total Sales”.
4. In the next column, type “  =sum(  ” and then click the tab at the bottom of your window that will take you to your orders worksheet.
5. Click the column letter above your order totals column, then hit “enter”.
6. Voila! You have your total sales in your “Totals” sheet. If you download and paste in more orders, this total will continue to update, because you’re totaling the entire column from your orders worksheet.

1. 1. 1. Add two more blank worksheets to your spreadsheet by again clicking the little + sign on the tab at the bottom of your window. Label one “Expenses”, and the other “Expense Categories.”
      2. On the Worksheet “Expense Categories”, type a list, all in Column A, of categories you can think of for your business expenses. It’s ok if you can’t think of all of them now, you can add more later.

1. 1. 1. Go to the Worksheet “Expenses” and create three columns. (You can add more later if you want more detail.) Column A: “Date”, Column B: “Expense Category”, Column C “Amount”.
      2. Click on the “B” at the top of Column B to select the column. Go to the Data Menu and select “Validation”.
      3. Under “source”, click the emblem to the right of the blank. Click on your tab “Expense Categories” to go to that worksheet. Select a large chunk of Column A – as many rows as you think you’ll need for Expense Categories in the future. I’m selecting 30 rows of Column A. Hit “Enter”. Then hit “OK”.

1. 1. 1. Now you should be back in your “Expenses” worksheet. Click on the top blank cell of the column “Expense Category.” You’ll see an up/down arrow to the right of the cell. Click on this arrow and you will see a box displaying your categories, and you can select the appropriate category for the expense your are entering. This will keep your expenses categorized correctly so you can easily sort them just like we did above for orders. You can also get fancy and learn to use VLOOKUP or SUMIFS formulas within this spreadsheet to easily show you totals for each category.
      2. Go to your “Totals” worksheet, and follow the instructions for totaling up your sales, but this time do it for your expenses.

Find this information helpful? Look at these posts, next!

• Track Business Mileage & Keep More Money (+ a Free Printable!)

• What’s the Deal with Assets and Depreciation?

• Episode 22: Pricing Your Products – The Details