《Excel 2007企业预算教程》(Excel 2007: Creating Business Budgets)[光盘镜像]

中文名: Excel 2007企业预算教程

英文名: Excel 2007: Creating Business Budgets

资源格式: 光盘镜像

发行日期: 2010年06月16日

地区: 美国

对白语言: 英语

文字语言: 英文

简介:

资源简介:

Lynda出品的Excel 2007: Creating Business Budgets. Excel 2007应用于企业财政预算方面的教程.

教程时长：1小时3分

主讲： Curt Frye

教学光盘提供有练习素材.

Description:

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

截图预览: