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

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: 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 资源来自网络收集 未经过一一的质量 安全等检测 只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 ! 希望各位下载的驴友能多多参与分流保源