Lynda - Excel 2007 Financial Analysis 收录时间:2018-04-21 06:27:00 文件大小:293MB 下载次数:178 最近下载:2020-12-23 04:47:59 磁力链接: magnet:?xt=urn:btih:237da2013956ba1ffe8a8155e7cf51e4a4d3cd15 立即下载 复制链接 文件列表 Reading a corporate financial statement-55978.mp4 15MB Welcome-55962.mp4 12MB Calculating interest and principal components of loan repayments-56013.mp4 12MB Avoiding common mistakes-55967.mp4 11MB Introducing common-sizing strategies for analyzing financial statements-55979.mp4 9MB Creating a Pivot Table from table data-55972.mp4 8MB Calculating the number of days between events-55998.mp4 8MB Adding Pivot Table columns to enhance data analysis-55975.mp4 8MB Filtering a Pivot Table-55974.mp4 7MB Tracking cash flow using a Pivot Chart-55976.mp4 7MB Tracking income and expenses using an Excel table-55971.mp4 7MB Calculating declining balance depreciation-56016.mp4 7MB Calculating simple interest and compound interest-55996.mp4 7MB Applying nominal versus effective interest rates (APR versus APY)-55997.mp4 7MB Creating common-sized income statements-55980.mp4 7MB Calculating gross profit margin and net profit margin-55986.mp4 7MB Calculating double declining balance depreciation-56017.mp4 7MB Calculating the value of zero coupon bonds-56021.mp4 6MB Computing the future value of an investment-56000.mp4 6MB Performing quick forecasts using the Fill handle-56007.mp4 6MB Creating common-sized balance sheets-55981.mp4 6MB Calculating percentage changes in financial statements-55982.mp4 6MB Calculating the debt ratio-55993.mp4 6MB Tracing formula precedents and dependents-55968.mp4 6MB Pivoting a Pivot Table-55973.mp4 5MB Calculating NPV and IRR for uneven input periods (XNPV and XIRR)-56004.mp4 5MB Evaluating Excel formulas step by step-55969.mp4 5MB Calculating the current ratio and quick ratio-55988.mp4 5MB Calculating return on equity and return on assets-55985.mp4 5MB Calculating net present value-56002.mp4 5MB Adding a trendline to a chart-56008.mp4 5MB Calculating internal rate of return-56003.mp4 5MB Pricing bonds to be offered to investors-56022.mp4 5MB Calculating present value-56001.mp4 5MB Introducing amortization-56010.mp4 4MB Calculating a bond's yield-56020.mp4 4MB Calculating payments on a fully amortized loan-56011.mp4 4MB Separating inputs and formulas-55966.mp4 4MB Projecting future results using the Forecast function-56006.mp4 4MB Introducing depreciation-56014.mp4 4MB Calculating payments on a partially amortized loan (balloon payments)-56012.mp4 4MB Calculating the average collection period-55989.mp4 4MB Calculating earnings per share-55984.mp4 4MB Calculating the times interest earned ratio-55994.mp4 4MB Calculating inventory turnover-55990.mp4 3MB Calculating straight line depreciation-56015.mp4 3MB Calculating the equity ratio-55992.mp4 3MB Introducing bonds and bond terminology-56019.mp4 2MB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/WashPost2008AnnualReport.htm 2MB Using the exercise files-55963.mp4 764KB Goodbye-56024.mp4 575KB Disclaimer-55964.mp4 544KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/WashPost2008AnnualReport_files/g42267g19s85.jpg 47KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Calculated.xlsx 15KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Filtering.xlsx 15KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/PivotChart.xlsx 15KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Pivoting.xlsx 15KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/Dates.xlsx 12KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Mistakes.xlsx 11KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Acp.xlsx 11KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Separating.xlsx 10KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Princint.xlsx 10KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/CreatePivot_fixed.xlsx 10KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Trendline.xlsx 10KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/ZeroCoupon.xlsx 10KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Tracing.xlsx 10KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/SimpleAndCompound.xlsx 10KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Pctchange.xlsx 10KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Commonsizing.xlsx 10KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Depreciation.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Csincome.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/Earnings.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Amortize.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Current and Quick Ratios.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Xnpvandxirr.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Doubledown.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/ExcelTables.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Csbalance.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Declining.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Irr.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/DebtRatio.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/Yield.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/Pricing.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/Tieratio.xlsx 9KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Futureval.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Inventory.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/GrossProfit.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/ReturnOnAssetsAndEquity.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/Nomeffect.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Evaluating_fixed.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Npv.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Fillhandle.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Straightline.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Forecast.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Balloon.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Pv.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Fullyamort.xlsx 8KB Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/Equityratio.xlsx 8KB