【Lynda】Excel 2007: Financial Analysis【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2007: Financial Analysis
作者：Curt Frye
主题：Business, Data Analysis, Finance
使用软件：Excel 2007
难度等级：中级
时长： 2h 18m
发布日期： Aug 25, 2009
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2007- Financial Analysis[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
│ └─◇ 0003 Disclaimer.srt
├─◆1. Designing a Financial Worksheet
│ └─◇ 0101 Separating inputs and formulas.srt
│ └─◇ 0102 Avoiding common mistakes.srt
│ └─◇ 0103 Tracing formula precedents and dependents.srt
│ └─◇ 0104 Evaluating Excel formulas step by step.srt
├─◆2. Analyzing Cash Flows Using Excel Tables and Pivot Tables
│ └─◇ 0201 Tracking income and expenses using an Excel table.srt
│ └─◇ 0202 Creating a Pivot Table from table data.srt
│ └─◇ 0203 Pivoting a Pivot Table.srt
│ └─◇ 0204 Filtering a Pivot Table.srt
│ └─◇ 0205 Adding Pivot Table columns to enhance data analysis.srt
│ └─◇ 0206 Tracking cash flow using a Pivot Chart.srt
├─◆3. Analyzing Financial Statements
│ └─◇ 0301 Reading a corporate financial statement.srt
│ └─◇ 0302 Introducing common-sizing strategies for analyzing financial statements.srt
│ └─◇ 0303 Creating common-sized income statements.srt
│ └─◇ 0304 Creating common-sized balance sheets.srt
│ └─◇ 0305 Calculating percentage changes in financial statements.srt
├─◆4. Calculating Profitability Ratios
│ └─◇ 0401 Calculating earnings per share.srt
│ └─◇ 0402 Calculating return on equity and return on assets.srt
├─◆5. Calculating Liquidity and Activity Ratios
│ └─◇ 0501 Calculating the current ratio and quick ratio.srt
│ └─◇ 0502 Calculating the average collection period.srt
│ └─◇ 0503 Calculating inventory turnover.srt
├─◆6. Calculating Leverage Ratios
│ └─◇ 0601 Calculating the equity ratio.srt
│ └─◇ 0602 Calculating the debt ratio.srt
│ └─◇ 0603 Calculating the times interest earned ratio.srt
├─◆7. Calculating the Effect of Interest Rates on Loan Repayment
│ └─◇ 0701 Calculating simple interest and compound interest.srt
│ └─◇ 0702 Applying nominal versus effective interest rates (APR versus APY).srt
│ └─◇ 0703 Calculating the number of days between events.srt
├─◆8. Determining Future Cash Flows
│ └─◇ 0801 Computing the future value of an investment.srt
│ └─◇ 0802 Calculating present value.srt
│ └─◇ 0803 Calculating net present value.srt
│ └─◇ 0804 Calculating internal rate of return.srt
│ └─◇ 0805 Calculating NPV and IRR for uneven input periods (XNPV and XIRR).srt
├─◆9. Forecasting Future Growth
│ └─◇ 0901 Projecting future results using the Forecast function.srt
│ └─◇ 0902 Performing quick forecasts using the Fill handle.srt
│ └─◇ 0903 Adding a trendline to a chart.srt
├─◆10. Determining Amortization and Depreciation Schedules
│ └─◇ 1001 Introducing amortization.srt
│ └─◇ 1002 Calculating payments on a fully amortized loan.srt
│ └─◇ 1003 Calculating payments on a partially amortized loan (balloon payments).srt
│ └─◇ 1004 Calculating interest and principal components of loan repayments.srt
│ └─◇ 1005 Introducing depreciation.srt
│ └─◇ 1006 Calculating straight line depreciation.srt
│ └─◇ 1007 Calculating declining balance depreciation.srt
│ └─◇ 1008 Calculating double declining balance depreciation.srt
├─◆11. Analyzing Bond Investments
│ └─◇ 1101 Introducing bonds and bond terminology.srt
│ └─◇ 1102 Calculating a bond’s yield.srt
│ └─◇ 1103 Calculating the value of zero coupon bonds.srt
│ └─◇ 1104 Pricing bonds to be offered to investors.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗