In Excel 2007: Creating Business Budgets Curt Frye shows
business owners and managers how to use Excel to create
useful budgets that help them manage resources prudently.
The course demonstrates how to use Excel spreadsheets to
track cash on hand, and how to project income and expenses
based on scenarios. It also shows how to take information
from various sources to create a single Excel table, and
then use PivotTables to analyze that data. Exercise files
accompany the course.
Topics include:
* Tracking income and expenses by category and contract
* Using balance sheets
* Designing worksheets to assist decision making
* Creating income statements
* Calculating loans payments and interest
* Creating cell references to other worksheets
* Summarizing data in a chart
* Building alternative budget scenarios
Download File Size:94.72 MB