v

您的位置:VeryCD教育计算机


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

  • 状态: 精华资源
  • 摘要:
    发行日期2010年06月16日
    对白语言英语
    文字语言英文
  • 时间: 2010/08/28 01:40:35 发布 | 2010/08/28 11:05:57 更新
  • 分类: 教育  计算机 

xiaochenjia

精华资源: 673

全部资源: 675

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名Excel 2007企业预算教程
英文名Excel 2007: Creating Business Budgets
资源格式光盘镜像
发行日期2010年06月16日
地区美国
对白语言英语
文字语言英文
简介

IPB Image

资源简介:

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

截图预览:

IPB Image



目录

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

引用
资源来自网络收集 未经过一一的质量 安全等检测
只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 !
希望各位下载的驴友能多多参与分流保源 happy.gif

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有40网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。