中文名: 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
截圖預覽:

目錄:
Introduction 01:25
Welcome 01:05
Using the exercise files 00:20
09:19 1. Managing Cash on Hand
Creating an Excel table to track cash on hand 03:46
Tracking income and expenses by category and contract 03:12
Summarizing cash on hand in a chart 02:21
13:40 2. Calculating Loan Repayments
Calculating payments for a fully amortized loan 03:35
Calculating interest and principal components of a loan payment 07:19
Determining the maximum amount that can be borrowed using Goal Seek 02:46
16:32 3. Budgeting Using Financial Statements
Introducing the balance sheet 04:22
Introducing the income statement 02:29
Introducing the cash flow statement 04:26
Creating a management income statement 02:43
Creating a management balance sheet 00:55
Creating a budget for next year 01:37
10:33 4. Managing Budgets
Referring to cells from other worksheets and workbooks in formulas 03:39
Summarizing budget data by creating a PivotTable 02:16
Analyzing budget data in a PivotTable 04:38
11:49 5. Defining Alternative Budget Scenarios
Deciding which scenarios to create 01:44
Creating and applying scenarios 05:57
Editing and deleting scenarios 01:50
Summarizing scenarios 02:18
00:16 Conclusion
Goodbye 00:16

資源來自網絡收集 未經過一一的質量 安全等檢測
只是把收集的資源和各位驢友分享 僅作網絡學習交流使用 請勿用於商業用途 !
希望各位下載的驢友能多多參與分流保源