Creating And Managing A Budget In Excel®

As a project manager, business owner, department head, accountant, etc., budgets are part of our lives. It can be a very stressful task to make a budget. There's many things you have to think about. You have to make sure everything is accounted for, you have to make sure you don't go over budget.

You want to ask for a reasonable amount of money for your project, but you don't want to appear like you are asking for too much. There are many other things that go into making a budget.

After this material, you will be able to use Excel® tools like Autosum, Subtotals, Goal Seek, Solver, Scenarios, formulas, charts, grouping and others to help you get your budget done efficiently and more quickly than you are doing it now.What You'll Learn:Creating Budgets in Excel®

• Simple Budget
  
• Grouping Categories Together to Get Subtotals
  
• Linking to Other Sheets
  
• SUMIF to Help With Subtotals
  
• Using Previous Data as a Baseline for a Budget

Showing Budget vs. Actual

• Conditional Formatting
  
• Charting
  
• Difference and % of Difference

Bottom up Budgeting

• Goal Seek
  
• Solver
  
• Using Scenarios to Go Back and Forth Between Different Sets of Numbers