Question about Business & Productivity Software

2 Answers

Budgets in excel

I want to create a budget in excel...and for my expenses section, i want to create "total expenses" cell...that updates each time i have a new expense. How can i do this, without having to update the formula? Currently, the formula has a range of cells in it to add but if I add new cells, I'd have to update the formula each time.

Posted by on

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 292 Answers
Re: budgets in excel

Hi Madih35
My solution is this:
Make sure there is a blank row just above the Total expenses cell.
Rewrite the formula to include the blank cell as well and save.
Every time you have a new expense which requires a new row, insert a row and type in the new cell, instead of typing in the existing blank cell. Your formula will be updated automatically.
Best of luck

Posted on Sep 01, 2009

  • Level 1:

    An expert who has achieved level 1.


    An expert that got 5 achievements.


    An expert whose answer got voted for 20 times.


    An expert who has answered 20 questions.

  • Contributor
  • 35 Answers
Re: budgets in excel

Dear Madiha35,


I would recommend the use of the Table Function in Excel.


Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.


Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.


Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.


Step 1:  Enter your data into the worksheet.


Step 2:  Create Table

             Highlight the relevant data

             On the insert tab, click on Table


Step 3:  Verify Table range is correct, Click OK


Step 4:  Select the cell you where you wish to Sum Data.

         Click on Autosum.


Step 5:  To Insert new data

         Click on the sum row in the table, (Not the entire worksheet row)

         Right click, Insert, Insert Table rows from above


Step 6:  Enter new data in row


Step 7:  Data is automatically calculated in formula.

Posted on Oct 29, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

What is budgetting

Budgeting is when you write a plan for how you are going to spend your money.

Oct 18, 2012 | Microsoft Office Accounting Professional


How to view total editing time updated in Real time in Word 2007

The total amount of time that a document has been edited is useful for lawyers, consultants, and other professionals who bill for their time.
Knowing how long you have spent working on a document enables you to provide a more accurate accounting of your time.
If you have a time budget that you’re trying to stick to, you may find yourself constantly checking the document’s Properties dialog box to view the Total editing time value.
Rather than wasting time performing that chore, add the EditTime field to your document.
Word’s EditTime field displays the total time, in minutes, that the document has had the system focus (and, presumably, has been edited) since the time at which the document was
created. This is the same as the Total editing time value displayed in the Statistics tab of the document’s Properties dialog box.
Follow these steps to add some code that displays the total editing time with the word minutes added for clarity:

1. Type some descriptive text (such as Total Editing Time).
2. Press Ctrl+F9 to start a new Word field (signified by the { and } braces).
3. Between the field braces, type the following:
EDITTIME # “0 minutes” * mergeformat
4. Press F9 to complete and update the field.

Now all you have to do is update the field (or simply press F9) to check the total editing time instead of going in the properties tab to see total time worked on the document.

on Jul 21, 2010 | Business & Productivity Software

1 Answer

IF Formula

You can use this formula
=IF(A2<=100,"Within budget","Over budget")
Which means
If the number above is less than or equal to 100, then the formula displays "Within budget". Otherwise, the function displays "Over budget" (Within budget)
or you and try something like this
which means
If the number above is 100, then the range B5:B15 is calculated. Otherwise, empty text ("") is returned ()
I got these examples from the help within Exel they give several more examples and more expaination.

Jan 10, 2009 | Microsoft Office Standard for PC

2 Answers

How to do profit and loss a/c in ms excel

Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Sales Product A

Sales Product B

Total Sales
Cost of Sales Product A

Cost of Sales Product B

Total Cost of Sales
Gross Profit




Office Supplies

Total Expenses

Net Profit

I hope this helps


Jan 05, 2009 | Microsoft Business & Productivity Software

1 Answer

Automatically creating a new worksheets

You can not do it by formulea but there is something called as ***-in you need to create add -in for this

I will suggest you that get a small program for doing this which will do all buisiness processing automatically will give you lots of benifits such as notification error catching and all.

If you need anything else,let me know.

Dec 17, 2008 | Microsoft Office Excel 2003 for PC

1 Answer

Microsoft excel(data analysing)

Microsoft Excel is an application used for building spreadsheets. It has many built in calculation and graphics tools. Some people use it to track expenses while other use it to graph numbers for charting process. As far as data analyzing it all depends on the data. Whether is sales figures or budget information. It all can be done inside of excel using it built in formulas and functions.

Sep 22, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

271 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides