search
search

Creating And Managing A Budget In Excel®

Webinar: ID# 1034616
Recorded CD
Qty:
About This Course:
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
Order:
Creating And Managing A Budget In Excel®
Available on CD format
Qty:
Share This:
About Us Privacy Guarantee Affiliate List Your Courses Contact Us My Account
FacebookCPATrainingCenter.com. 5755 North Point Parkway, Suite 227 | Alpharetta, GA 30022 | 770-410-9941 | support@CPATrainingCenter.com
Copyright CPATrainingCenter.com 2018 | Web Site Development by OTAU