Lynda Excel 2007 Financial Analysis | 237DA2013956BA1FFE8A8155E7CF51E4A4D3CD15

Lynda Excel 2007 Financial Analysis

Name	Lynda - Excel 2007 Financial Analysis	DOWNLOAD Copy Link
Total Size	307.7 MB
Total Files	98
Hash	237DA2013956BA1FFE8A8155E7CF51E4A4D3CD15

/
Reading a corporate financial statement-55978.mp4	16.0 MB
Welcome-55962.mp4	13.0 MB
Calculating interest and principal components of loan repayments-56013.mp4	12.6 MB
Avoiding common mistakes-55967.mp4	11.4 MB
Introducing common-sizing strategies for analyzing financial statements-55979.mp4	9.1 MB
Creating a Pivot Table from table data-55972.mp4	8.5 MB
Calculating the number of days between events-55998.mp4	8.2 MB
Adding Pivot Table columns to enhance data analysis-55975.mp4	7.9 MB
Filtering a Pivot Table-55974.mp4	7.7 MB
Tracking cash flow using a Pivot Chart-55976.mp4	7.4 MB
Tracking income and expenses using an Excel table-55971.mp4	7.2 MB
Calculating declining balance depreciation-56016.mp4	7.2 MB
Calculating simple interest and compound interest-55996.mp4	7.1 MB
Applying nominal versus effective interest rates (APR versus APY)-55997.mp4	7.0 MB
Creating common-sized income statements-55980.mp4	7.0 MB
Calculating gross profit margin and net profit margin-55986.mp4	7.0 MB
Calculating double declining balance depreciation-56017.mp4	6.9 MB
Calculating the value of zero coupon bonds-56021.mp4	6.8 MB
Computing the future value of an investment-56000.mp4	6.7 MB
Performing quick forecasts using the Fill handle-56007.mp4	6.5 MB
Creating common-sized balance sheets-55981.mp4	6.4 MB
Calculating percentage changes in financial statements-55982.mp4	6.3 MB
Calculating the debt ratio-55993.mp4	6.2 MB
Tracing formula precedents and dependents-55968.mp4	5.8 MB
Pivoting a Pivot Table-55973.mp4	5.7 MB
Calculating NPV and IRR for uneven input periods (XNPV and XIRR)-56004.mp4	5.6 MB
Evaluating Excel formulas step by step-55969.mp4	5.6 MB
Calculating the current ratio and quick ratio-55988.mp4	5.6 MB
Calculating return on equity and return on assets-55985.mp4	5.5 MB
Calculating net present value-56002.mp4	5.5 MB
Adding a trendline to a chart-56008.mp4	5.5 MB
Calculating internal rate of return-56003.mp4	4.9 MB
Pricing bonds to be offered to investors-56022.mp4	4.9 MB
Calculating present value-56001.mp4	4.8 MB
Introducing amortization-56010.mp4	4.7 MB
Calculating a bond's yield-56020.mp4	4.5 MB
Calculating payments on a fully amortized loan-56011.mp4	4.5 MB
Separating inputs and formulas-55966.mp4	4.4 MB
Projecting future results using the Forecast function-56006.mp4	4.3 MB
Introducing depreciation-56014.mp4	4.3 MB
Calculating payments on a partially amortized loan (balloon payments)-56012.mp4	4.1 MB
Calculating the average collection period-55989.mp4	3.9 MB
Calculating earnings per share-55984.mp4	3.8 MB
Calculating the times interest earned ratio-55994.mp4	3.7 MB
Calculating inventory turnover-55990.mp4	3.2 MB
Calculating straight line depreciation-56015.mp4	3.1 MB
Calculating the equity ratio-55992.mp4	2.8 MB
Introducing bonds and bond terminology-56019.mp4	2.5 MB
Using the exercise files-55963.mp4	782.0 KB
Goodbye-56024.mp4	588.4 KB
Disclaimer-55964.mp4	557.4 KB
/Exercise Files/Chapter03/
WashPost2008AnnualReport.htm	1.7 MB
Pctchange.xlsx	9.8 KB
Commonsizing.xlsx	9.8 KB
Csincome.xlsx	9.5 KB
Csbalance.xlsx	9.0 KB
/Exercise Files/Chapter03/WashPost2008AnnualReport_files/
g42267g19s85.jpg	47.7 KB
/Exercise Files/Chapter02/
Calculated.xlsx	15.6 KB
Filtering.xlsx	15.5 KB
PivotChart.xlsx	15.5 KB
Pivoting.xlsx	15.3 KB
CreatePivot_fixed.xlsx	10.2 KB
ExcelTables.xlsx	9.0 KB
/Exercise Files/Chapter07/
Dates.xlsx	11.8 KB
SimpleAndCompound.xlsx	9.9 KB
Nomeffect.xlsx	8.5 KB
/Exercise Files/Chapter01/
Mistakes.xlsx	11.7 KB
Separating.xlsx	10.5 KB
Tracing.xlsx	10.0 KB
Evaluating_fixed.xlsx	8.2 KB
/Exercise Files/Chapter05/
Acp.xlsx	11.6 KB
Current and Quick Ratios.xlsx	9.2 KB
Inventory.xlsx	8.7 KB
/Exercise Files/Chapter10/
Princint.xlsx	10.5 KB
Depreciation.xlsx	9.6 KB
Amortize.xlsx	9.3 KB
Doubledown.xlsx	9.0 KB
Declining.xlsx	9.0 KB
Straightline.xlsx	8.0 KB
Balloon.xlsx	7.9 KB
Fullyamort.xlsx	7.9 KB
/Exercise Files/Chapter09/
Trendline.xlsx	10.2 KB
Fillhandle.xlsx	8.1 KB
Forecast.xlsx	7.9 KB
/Exercise Files/Chapter11/
ZeroCoupon.xlsx	10.1 KB
Yield.xlsx	8.8 KB
Pricing.xlsx	8.8 KB
/Exercise Files/Chapter04/
Earnings.xlsx	9.4 KB
GrossProfit.xlsx	8.6 KB
ReturnOnAssetsAndEquity.xlsx	8.5 KB
/Exercise Files/Chapter08/
Xnpvandxirr.xlsx	9.1 KB
Irr.xlsx	8.9 KB
Futureval.xlsx	8.7 KB
Npv.xlsx	8.1 KB
Pv.xlsx	7.9 KB
/Exercise Files/Chapter06/
DebtRatio.xlsx	8.9 KB
Tieratio.xlsx	8.7 KB
Equityratio.xlsx	7.8 KB
Total files 98