589689.xyz

Lynda - Excel 2007 Financial Analysis

  • 收录时间:2018-04-21 06:27:00
  • 文件大小:293MB
  • 下载次数:178
  • 最近下载:2020-12-23 04:47:59
  • 磁力链接:

文件列表

  1. Reading a corporate financial statement-55978.mp4 15MB
  2. Welcome-55962.mp4 12MB
  3. Calculating interest and principal components of loan repayments-56013.mp4 12MB
  4. Avoiding common mistakes-55967.mp4 11MB
  5. Introducing common-sizing strategies for analyzing financial statements-55979.mp4 9MB
  6. Creating a Pivot Table from table data-55972.mp4 8MB
  7. Calculating the number of days between events-55998.mp4 8MB
  8. Adding Pivot Table columns to enhance data analysis-55975.mp4 8MB
  9. Filtering a Pivot Table-55974.mp4 7MB
  10. Tracking cash flow using a Pivot Chart-55976.mp4 7MB
  11. Tracking income and expenses using an Excel table-55971.mp4 7MB
  12. Calculating declining balance depreciation-56016.mp4 7MB
  13. Calculating simple interest and compound interest-55996.mp4 7MB
  14. Applying nominal versus effective interest rates (APR versus APY)-55997.mp4 7MB
  15. Creating common-sized income statements-55980.mp4 7MB
  16. Calculating gross profit margin and net profit margin-55986.mp4 7MB
  17. Calculating double declining balance depreciation-56017.mp4 7MB
  18. Calculating the value of zero coupon bonds-56021.mp4 6MB
  19. Computing the future value of an investment-56000.mp4 6MB
  20. Performing quick forecasts using the Fill handle-56007.mp4 6MB
  21. Creating common-sized balance sheets-55981.mp4 6MB
  22. Calculating percentage changes in financial statements-55982.mp4 6MB
  23. Calculating the debt ratio-55993.mp4 6MB
  24. Tracing formula precedents and dependents-55968.mp4 6MB
  25. Pivoting a Pivot Table-55973.mp4 5MB
  26. Calculating NPV and IRR for uneven input periods (XNPV and XIRR)-56004.mp4 5MB
  27. Evaluating Excel formulas step by step-55969.mp4 5MB
  28. Calculating the current ratio and quick ratio-55988.mp4 5MB
  29. Calculating return on equity and return on assets-55985.mp4 5MB
  30. Calculating net present value-56002.mp4 5MB
  31. Adding a trendline to a chart-56008.mp4 5MB
  32. Calculating internal rate of return-56003.mp4 5MB
  33. Pricing bonds to be offered to investors-56022.mp4 5MB
  34. Calculating present value-56001.mp4 5MB
  35. Introducing amortization-56010.mp4 4MB
  36. Calculating a bond's yield-56020.mp4 4MB
  37. Calculating payments on a fully amortized loan-56011.mp4 4MB
  38. Separating inputs and formulas-55966.mp4 4MB
  39. Projecting future results using the Forecast function-56006.mp4 4MB
  40. Introducing depreciation-56014.mp4 4MB
  41. Calculating payments on a partially amortized loan (balloon payments)-56012.mp4 4MB
  42. Calculating the average collection period-55989.mp4 4MB
  43. Calculating earnings per share-55984.mp4 4MB
  44. Calculating the times interest earned ratio-55994.mp4 4MB
  45. Calculating inventory turnover-55990.mp4 3MB
  46. Calculating straight line depreciation-56015.mp4 3MB
  47. Calculating the equity ratio-55992.mp4 3MB
  48. Introducing bonds and bond terminology-56019.mp4 2MB
  49. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/WashPost2008AnnualReport.htm 2MB
  50. Using the exercise files-55963.mp4 764KB
  51. Goodbye-56024.mp4 575KB
  52. Disclaimer-55964.mp4 544KB
  53. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/WashPost2008AnnualReport_files/g42267g19s85.jpg 47KB
  54. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Calculated.xlsx 15KB
  55. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Filtering.xlsx 15KB
  56. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/PivotChart.xlsx 15KB
  57. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Pivoting.xlsx 15KB
  58. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/Dates.xlsx 12KB
  59. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Mistakes.xlsx 11KB
  60. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Acp.xlsx 11KB
  61. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Separating.xlsx 10KB
  62. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Princint.xlsx 10KB
  63. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/CreatePivot_fixed.xlsx 10KB
  64. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Trendline.xlsx 10KB
  65. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/ZeroCoupon.xlsx 10KB
  66. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Tracing.xlsx 10KB
  67. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/SimpleAndCompound.xlsx 10KB
  68. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Pctchange.xlsx 10KB
  69. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Commonsizing.xlsx 10KB
  70. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Depreciation.xlsx 9KB
  71. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Csincome.xlsx 9KB
  72. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/Earnings.xlsx 9KB
  73. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Amortize.xlsx 9KB
  74. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Current and Quick Ratios.xlsx 9KB
  75. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Xnpvandxirr.xlsx 9KB
  76. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Doubledown.xlsx 9KB
  77. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/ExcelTables.xlsx 9KB
  78. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Csbalance.xlsx 9KB
  79. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Declining.xlsx 9KB
  80. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Irr.xlsx 9KB
  81. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/DebtRatio.xlsx 9KB
  82. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/Yield.xlsx 9KB
  83. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/Pricing.xlsx 9KB
  84. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/Tieratio.xlsx 9KB
  85. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Futureval.xlsx 8KB
  86. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Inventory.xlsx 8KB
  87. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/GrossProfit.xlsx 8KB
  88. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/ReturnOnAssetsAndEquity.xlsx 8KB
  89. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/Nomeffect.xlsx 8KB
  90. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Evaluating_fixed.xlsx 8KB
  91. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Npv.xlsx 8KB
  92. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Fillhandle.xlsx 8KB
  93. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Straightline.xlsx 8KB
  94. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Forecast.xlsx 8KB
  95. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Balloon.xlsx 8KB
  96. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Pv.xlsx 8KB
  97. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Fullyamort.xlsx 8KB
  98. Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/Equityratio.xlsx 8KB