请选择 进入手机版 | 继续访问电脑版
楼主: 車樹森
1223 6

[学习分享] Excel Finance Class, Intro To Excel 2007 & 2010 [推广有奖]

  • 4关注
  • 32粉丝

学科带头人

91%

还不是VIP/贵宾

-

TA的文库  其他...

Excel 各版本经典电子书

威望
1
论坛币
-13533 个
通用积分
5486.9630
学术水平
94 点
热心指数
107 点
信用等级
49 点
经验
107063 点
帖子
2289
精华
0
在线时间
2455 小时
注册时间
2014-3-4
最后登录
2023-10-7

車樹森 学生认证  发表于 2017-4-11 08:39:37 |显示全部楼层 |坛友微信交流群
相似文件 换一批

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

感谢您参与论坛问题回答

经管之家送您两个论坛币!

+2 论坛币

txt 文本中为百度云盘链接,两个月后,不一定有效。
有问题可以留言,便于沟通,云盘链接容易失效。
另外,优酷上 可google: Excel Finance Class也能看到
Excel Finance Class.txt (49 Bytes, 需要: 20 个论坛币)
名称        大小       
Excel Finance Class 01- Intro To Excel 2007 & 2010.mp4        20.3 MB
Excel Finance Class 02- Getting Started with Formulas, Functions, Formula Inputs and Cell References.mp4        29.6 MB
Excel Finance Class 03- Math Operators and Order of Operations.mp4        32.3 MB
Excel Finance Class 04- The Importance Of Number Formatting In Financial Calculations.mp4        19.1 MB
Excel Finance Class 05- Percent, Percent Change - Increase - Decrease Percentage Number Formatting.mp4        15.4 MB
Excel Finance Class 06- Relative and Absolute Cell References in Copied Formulas.mp4        11.7 MB
Excel Finance Class 07- Stylistic Formatting.mp4        5.5 MB
Excel Finance Class 08- Intro To Corporate Financial Management.mp4        56.4 MB
Excel Finance Class 09- Balance Sheet, Working Capital, Liquidity, Debt, Equity, Market Value.mp4        38.7 MB
Excel Finance Class 10- Income Statement, Non Cash Depreciation Expense, Matching Principal.mp4        26.0 MB
Excel Finance Class 100- Real Rate and Inflation or Deflation For T-bills..mp4        14.3 MB
Excel Finance Class 101- Average Real Return For A Stock Based On Historical Data.mp4        12.3 MB
Excel Finance Class 102- In The Short Run Financial Markets Can Be Inefficient Mispriced Assets.mp4        20.5 MB
Excel Finance Class 103- 2 Ways To Calculate Geometric Mean.mp4        21.7 MB
Excel Finance Class 105- Expected Return & Standard Deviation For Portfolio -- Estimating Future.mp4        13.8 MB
Excel Finance Class 106- Unexpected Information, Market & Asset Specific Risk, Diversification, Beta.mp4        42.9 MB
Excel Finance Class 107- Calculating Beta (2 Methods) & Chart Beta, SLOPE CORREL & STDEV functions.mp4        52.0 MB
Excel Finance Class 108- Reward To Risk Ratio - Treynor Index.mp4        7.4 MB
Excel Finance Class 109- Beta For Portfolio.mp4        14.2 MB
Excel Finance Class 11- Finance Cash Flow From Accounting Information.mp4        48.1 MB
Excel Finance Class 110- Security Market Line (SML) & Capital Asset Pricing Model (CAPM).mp4        10.8 MB
Excel Finance Class 111- Treynor Index & CAPM.mp4        3.7 MB
Excel Finance Class 12- Cash Flow Advantage To Debt & Average and Marginal Tax Rates.mp4        16.4 MB
Excel Finance Class 13- Banks, Fundamental Problem With Banks, & The Big Short (1).mp4        22.9 MB
Excel Finance Class 14- Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis.mp4        38.8 MB
Excel Finance Class 15- Common Sized Financial Statements.mp4        16.0 MB
Excel Finance Class 16- Liquidity, Current Ratio and How Current Ratio Can Be Manipulated.mp4        19.1 MB
Excel Finance Class 17- Leverage & Solvency Ratios- Debt To Equity, Equity Multiplier, more....mp4        25.6 MB
Excel Finance Class 18- Asset Efficiency Ratio and Cash Cycle In Days.mp4        23.8 MB
Excel Finance Class 18.5- Ratios For Cash Cycle In Days..mp4        11.3 MB
Excel Finance Class 19-Profitablility Rations- Return On Equity & Return On Assets & DuPont Analysis.mp4        20.1 MB
Excel Finance Class 20- Growth Ratios and Market Value Ratios.mp4        55.3 MB
Excel Finance Class 21- Future Value Lump Sum Calculations, Simple & Compound Interest.mp4        36.7 MB
Excel Finance Class 22- Present Value Lump Sum Calculations and PV Function.mp4        20.4 MB
Excel Finance Class 23- Solve For Total Number Of Periods When You Know PV, FV and Period Rate.mp4        6.4 MB
Excel Finance Class 24- Solve For Period Rate & Annual Rate When You Know PV, FV and # of Periods.mp4        14.5 MB
Excel Finance Class 25- Future Value For Lender Or Borrower.mp4        9.8 MB
Excel Finance Class 26- Multiple Cash Flow Valuation Future Value and Present Value FV PV Functions.mp4        24.6 MB
Excel Finance Class 27- Asset Valuation Using Discounted Cash Flow Analysis and PV Function.mp4        8.8 MB
Excel Finance Class 28- Relationship Between APR, Period Rate and Effective Annual Rate.mp4        45.0 MB
Excel Finance Class 29- Calculate Future Value Of An Annuity (FV Function).mp4        21.6 MB
Excel Finance Class 30- Future Value For Interest Paid Daily, But Deposits Made Monthly.mp4        19.6 MB
Excel Finance Class 31- Calculate PMT for Future Value of Annuity (PMT Function).mp4        27.7 MB
Excel Finance Class 32- Calculate Present Value of Annuity (PV Function).mp4        12.8 MB
Excel Finance Class 33- Full Life Retirement Plan PV Annuity & FV Annuity PV & PMT Functions.mp4        11.8 MB
Excel Finance Class 34- Present Value Of Annuity For Asset Valuation.mp4        7.8 MB
Excel Finance Class 35- Calculate PMT for Present Value of Annuity PMT Function for Loan Payment.mp4        5.6 MB
Excel Finance Class 36- PMT Function 7 Examples & Adjusted APR with Points and RATE function.mp4        17.3 MB
Excel Finance Class 37- How Much Do I Get Each Month During Retirement.mp4        8.0 MB
Excel Finance Class 38- Calculate APR and EAR Given Cash Flows From Annuity.mp4        8.4 MB
Excel Finance Class 39- How Long To Pay Off Credit Card With Minimum Payment.mp4        6.0 MB
Excel Finance Class 40- Perpetuity (consol) Preferred Stock Valuation Formula.mp4        3.1 MB
Excel Finance Class 41- Interest Only Loan Schedule..mp4        5.9 MB
Excel Finance Class 42- Consumer Amortized Loans.mp4        21.1 MB
Excel Finance Class 43- Business Amortized Loans.mp4        8.1 MB
Excel Finance Class 44- Deep Discount Loans.mp4        22.9 MB
Excel Finance Class 45- Interest Rates- Real, Nominal, Inflation and the Fisher Effect.mp4        21.7 MB
Excel Finance Class 46- Bonds- Just Set Of Cash Flows Discounted At Market Rate, Coupon or Zero.mp4        31.3 MB
Excel Finance Class 47- Selling Bond When Coupon Rate Is Different Than Discount Rate (YTM Rate).mp4        8.6 MB
Excel Finance Class 48- Calculate YTM and Effective Annual Yield From Bond Cash Flows RATE & EFFECT.mp4        11.8 MB
Excel Finance Class 49- Bond Quoted Price & Yield To Market.mp4        5.4 MB
Excel Finance Class 50- Bond Rates Are Inversely Related To Bond Price (Scatter Diagram Excel Chart).mp4        9.5 MB
Excel Finance Class 51- Par - Discount - Premium Bonds.mp4        11.9 MB
Excel Finance Class 52- Bond Discount Or Premium Amortization Table..mp4        24.6 MB
Excel Finance Class 54- Bonds & Interest Rate Risk.mp4        11.1 MB
Excel Finance Class 55- Tax Advantage of Muni Bond.mp4        3.9 MB
Excel Finance Class 56- Tax Implications For Zero Coupon Bonds..mp4        31.2 MB
Excel Finance Class 57- Compare Cash Flows For a Coupon & A Zero Coupon Bond.mp4        12.6 MB
Excel Finance Class 58- After Tax Cash Flows & After Tax Interest Rates.mp4        8.5 MB
Excel Finance Class 59- Common & Preferred Stock.mp4        19.6 MB
Excel Finance Class 60- Basics Of Financial Markets.mp4        24.3 MB
Excel Finance Class 61- Stock Value Based on Present Value of Future Dividend Cash Flows..mp4        32.2 MB
Excel Finance Class 62- Preferred Stock Valuation as A Perpetuity.mp4        12.4 MB
Excel Finance Class 63- Stock Valuation with Dividend Growth Model.mp4        17.2 MB
Excel Finance Class 64- Chart How Stock Value Changes for Dividend Growth Model as Inputs Change.mp4        31.1 MB
Excel Finance Class 65- Calculate Stock Price at Time t using Dividend Growth Model.mp4        7.5 MB
Excel Finance Class 66- Calculate Implied Return using Dividend Growth Model.mp4        14.3 MB
Excel Finance Class 67- Irregular Dividend Payments, Followed by Constant Growth -- Stock Valuation..mp4        16.1 MB
Excel Finance Class 68- Net Present Value, NPV Excel Function & Capital Budgeting.mp4        64.0 MB
Excel Finance Class 69- Net Present Value Profile -- Build Table and Chart in Excel NPV Function.mp4        26.3 MB
Excel Finance Class 70- Investment Criteria- Net Present Value.mp4        3.3 MB
Excel Finance Class 71- Investment Criteria- Payback Rule.mp4        10.1 MB
Excel Finance Class 72- Investment Criteria- Average Accounting Return.mp4        32.2 MB
Excel Finance Class 73- Investment Criteria- Internal Rate Of Return IRR Function Plot Chart.mp4        79.2 MB
Excel Finance Class 74- IRR and Non-conventional Cash Flows, Plot Chart To See Multiple IRR.mp4        29.3 MB
Excel Finance Class 75- IRR and Mutually Exclusive Projects - Plot Chart To See Cross Over Rate.mp4        13.8 MB
Excel Finance Class 76- Investment Criteria- MIRR - Modified Internal Rate of Return.mp4        33.5 MB
Excel Finance Class 77- Investment Criteria- Profitability Index.mp4        8.2 MB
Excel Finance Class 78- NPV For Irregular Cash Flows and Time Periods XNPV, NPV and PV functions..mp4        28.1 MB
Excel Finance Class 79- Investment Criteria- NPV, IRR, Payback, AAR, Profitability Index.mp4        32.0 MB
Excel Finance Class 80- Recognizing Patterns of Cash Flows For Discounted Cash Flow Analysis.mp4        29.4 MB
Excel Finance Class 81- XNPV Function XIRR Function - See Algorithm That XNPV uses.mp4        17.9 MB
Excel Finance Class 82- Relevant Costs For Discounted Cash Flow Analysis Incremental Cash Flows.mp4        22.2 MB
Excel Finance Class 83- Estimating Cash Flows For NPV calculation.mp4        64.7 MB
Excel Finance Class 84- Undoing Accrual Accounting to Discover Cash Flows For Estimating NPV.mp4        9.1 MB
Excel Finance Class 85- MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows.mp4        14.3 MB
Excel Finance Class 86- Estimating Cash Flows For NPV calculation Comprehensive Example..mp4        32.2 MB
Excel Finance Class 87- Cost Savings Example Estimating Cash Flows For NPV calculation.mp4        9.4 MB
Excel Finance Class 88- Scenario Analysis For Cash Flow & NPV Calculations.mp4        64.5 MB
Excel Finance Class 89- Sensitivity Analysis For Cash Flow & NPV Calculations.mp4        15.2 MB
Excel Finance Class 90- Period (Holding) Returns For Stock.mp4        7.5 MB
Excel Finance Class 91- Period (Holding) Nominal, Real & Dollar Returns For Coupon Bond.mp4        15.7 MB
Excel Finance Class 92- Period (Holding) Returns For Zero Bond.mp4        13.5 MB
Excel Finance Class 93- Period (Holding) Returns For Preferred Stock.mp4        7.3 MB
Excel Finance Class 94- Period (Holding) Returns For Less Than 1 Year, APR and EAR.mp4        13.9 MB
Excel Finance Class 95- Using Past Period Holding Returns to Estimate Future Returns Arithmetic Mean.mp4        11.8 MB
Excel Finance Class 96- Comparing Geometric Mean with Arithmetic Mean For Average Stock Returns.mp4        19.8 MB
Excel Finance Class 97- Using Geometric Mean & Arithmetic Mean to Estimate Future Returns.mp4        14.5 MB
Excel Finance Class 99- US Capital Market History 5 Types Investments (2 Good Lessons).mp4        29.2 MB
Excel Magic Trick 1121- Excel 2013 RRI Function- Calculate Compounding Rate-Geometric Mean.mp4        27.6 MB
Excel Magic Trick 1128- Aging Accounts Receivable Reports On Multiple Sheets With Array Formula.mp4        151 MB
videoplayback.mp4        11.1 MB


二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

关键词:Excel

MOS Master
青年良品 学生认证  发表于 2017-4-11 10:27:37 来自手机 |显示全部楼层 |坛友微信交流群
先记一下哈哈哈

使用道具

fdwang 发表于 2017-4-11 16:21:27 |显示全部楼层 |坛友微信交流群

使用道具

車樹森 学生认证  发表于 2017-4-11 17:57:44 |显示全部楼层 |坛友微信交流群
fdwang 发表于 2017-4-11 16:21
[shy][shy]

使用道具

車樹森 学生认证  发表于 2017-4-11 17:59:09 |显示全部楼层 |坛友微信交流群
青年良品 发表于 2017-4-11 10:27
先记一下哈哈哈
[victory]

使用道具

tryityet 发表于 2017-4-15 22:34:17 |显示全部楼层 |坛友微信交流群
谢谢分享,正在学习

使用道具

車樹森 学生认证  发表于 2017-4-16 16:00:36 |显示全部楼层 |坛友微信交流群
tryityet 发表于 2017-4-15 22:34
谢谢分享,正在学习
可以提高英语,

使用道具

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注cda
拉您进交流群

京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2024-4-16 15:36