資料介紹

• 辦公軟件與office教程
• 計算機資料

資源簡介:

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

截圖預覽: