【Lynda】Excel 2007: Creating Business Budgets【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2007: Creating Business Budgets
作者：Curt Frye
主题：Business, Accounting, Finance
使用软件：Excel 2007
难度等级：中级
时长： 1h 3m
发布日期： Jun 16, 2010
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2007- Creating Business Budgets[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Managing Cash on Hand
│ └─◇ 0101 Creating an Excel table to track cash on hand.srt
│ └─◇ 0102 Tracking income and expenses by category and contract.srt
│ └─◇ 0103 Summarizing cash on hand in a chart.srt
├─◆2. Calculating Loan Repayments
│ └─◇ 0201 Calculating payments for a fully amortized loan.srt
│ └─◇ 0202 Calculating interest and principal components of a loan payment.srt
│ └─◇ 0203 Determining the maximum amount that can be borrowed using Goal Seek.srt
├─◆3. Budgeting Using Financial Statements
│ └─◇ 0301 Introducing the balance sheet.srt
│ └─◇ 0302 Introducing the income statement.srt
│ └─◇ 0303 Introducing the cash flow statement.srt
│ └─◇ 0304 Creating a management income statement.srt
│ └─◇ 0305 Creating a management balance sheet.srt
│ └─◇ 0306 Creating a budget for next year.srt
├─◆4. Managing Budgets
│ └─◇ 0401 Referring to cells from other worksheets and workbooks in formulas.srt
│ └─◇ 0402 Summarizing budget data by creating a PivotTable.srt
│ └─◇ 0403 Analyzing budget data in a PivotTable.srt
├─◆5. Defining Alternative Budget Scenarios
│ └─◇ 0501 Deciding which scenarios to create.srt
│ └─◇ 0502 Creating and applying scenarios.srt
│ └─◇ 0503 Editing and deleting scenarios.srt
│ └─◇ 0504 Summarizing scenarios.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗