Lynda - Excel 2007 Financial Analysis
File List
| File | Size |
|---|---|
| Reading a corporate financial statement-55978.mp4 | 15.29 MB |
| Welcome-55962.mp4 | 12.44 MB |
| Calculating interest and principal components of loan repayments-56013.mp4 | 12 MB |
| Avoiding common mistakes-55967.mp4 | 10.85 MB |
| Introducing common-sizing strategies for analyzing financial statements-55979.mp4 | 8.63 MB |
| Creating a Pivot Table from table data-55972.mp4 | 8.15 MB |
| Calculating the number of days between events-55998.mp4 | 7.79 MB |
| Adding Pivot Table columns to enhance data analysis-55975.mp4 | 7.53 MB |
| Filtering a Pivot Table-55974.mp4 | 7.38 MB |
| Tracking cash flow using a Pivot Chart-55976.mp4 | 7.1 MB |
| Tracking income and expenses using an Excel table-55971.mp4 | 6.9 MB |
| Calculating declining balance depreciation-56016.mp4 | 6.88 MB |
| Calculating simple interest and compound interest-55996.mp4 | 6.73 MB |
| Applying nominal versus effective interest rates (APR versus APY)-55997.mp4 | 6.72 MB |
| Creating common-sized income statements-55980.mp4 | 6.7 MB |
| Calculating gross profit margin and net profit margin-55986.mp4 | 6.7 MB |
| Calculating double declining balance depreciation-56017.mp4 | 6.61 MB |
| Calculating the value of zero coupon bonds-56021.mp4 | 6.49 MB |
| Computing the future value of an investment-56000.mp4 | 6.39 MB |
| Performing quick forecasts using the Fill handle-56007.mp4 | 6.19 MB |
| Creating common-sized balance sheets-55981.mp4 | 6.1 MB |
| Calculating percentage changes in financial statements-55982.mp4 | 5.99 MB |
| Calculating the debt ratio-55993.mp4 | 5.96 MB |
| Tracing formula precedents and dependents-55968.mp4 | 5.53 MB |
| Pivoting a Pivot Table-55973.mp4 | 5.43 MB |
| Calculating NPV and IRR for uneven input periods (XNPV and XIRR)-56004.mp4 | 5.36 MB |
| Evaluating Excel formulas step by step-55969.mp4 | 5.34 MB |
| Calculating the current ratio and quick ratio-55988.mp4 | 5.31 MB |
| Calculating return on equity and return on assets-55985.mp4 | 5.29 MB |
| Calculating net present value-56002.mp4 | 5.26 MB |
| Adding a trendline to a chart-56008.mp4 | 5.23 MB |
| Calculating internal rate of return-56003.mp4 | 4.67 MB |
| Pricing bonds to be offered to investors-56022.mp4 | 4.64 MB |
| Calculating present value-56001.mp4 | 4.56 MB |
| Introducing amortization-56010.mp4 | 4.49 MB |
| Calculating a bond's yield-56020.mp4 | 4.3 MB |
| Calculating payments on a fully amortized loan-56011.mp4 | 4.29 MB |
| Separating inputs and formulas-55966.mp4 | 4.16 MB |
| Projecting future results using the Forecast function-56006.mp4 | 4.15 MB |
| Introducing depreciation-56014.mp4 | 4.07 MB |
| Calculating payments on a partially amortized loan (balloon payments)-56012.mp4 | 3.94 MB |
| Calculating the average collection period-55989.mp4 | 3.72 MB |
| Calculating earnings per share-55984.mp4 | 3.59 MB |
| Calculating the times interest earned ratio-55994.mp4 | 3.53 MB |
| Calculating inventory turnover-55990.mp4 | 3.05 MB |
| Calculating straight line depreciation-56015.mp4 | 2.96 MB |
| Calculating the equity ratio-55992.mp4 | 2.7 MB |
| Introducing bonds and bond terminology-56019.mp4 | 2.43 MB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/WashPost2008AnnualReport.htm | 1.64 MB |
| Using the exercise files-55963.mp4 | 763.65 KB |
| Goodbye-56024.mp4 | 574.58 KB |
| Disclaimer-55964.mp4 | 544.3 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/WashPost2008AnnualReport_files/g42267g19s85.jpg | 46.6 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Calculated.xlsx | 15.28 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Filtering.xlsx | 15.13 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/PivotChart.xlsx | 15.12 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Pivoting.xlsx | 14.95 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/Dates.xlsx | 11.51 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Mistakes.xlsx | 11.47 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Acp.xlsx | 11.3 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Separating.xlsx | 10.25 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Princint.xlsx | 10.25 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/CreatePivot_fixed.xlsx | 10 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Trendline.xlsx | 9.99 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/ZeroCoupon.xlsx | 9.85 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Tracing.xlsx | 9.73 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/SimpleAndCompound.xlsx | 9.68 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Pctchange.xlsx | 9.6 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Commonsizing.xlsx | 9.55 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Depreciation.xlsx | 9.36 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Csincome.xlsx | 9.25 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/Earnings.xlsx | 9.21 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Amortize.xlsx | 9.07 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Current and Quick Ratios.xlsx | 9 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Xnpvandxirr.xlsx | 8.88 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Doubledown.xlsx | 8.84 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/ExcelTables.xlsx | 8.8 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Csbalance.xlsx | 8.77 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Declining.xlsx | 8.77 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Irr.xlsx | 8.68 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/DebtRatio.xlsx | 8.67 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/Yield.xlsx | 8.63 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/Pricing.xlsx | 8.59 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/Tieratio.xlsx | 8.51 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Futureval.xlsx | 8.48 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Inventory.xlsx | 8.47 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/GrossProfit.xlsx | 8.44 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/ReturnOnAssetsAndEquity.xlsx | 8.33 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/Nomeffect.xlsx | 8.27 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Evaluating_fixed.xlsx | 8 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Npv.xlsx | 7.89 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Fillhandle.xlsx | 7.88 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Straightline.xlsx | 7.85 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Forecast.xlsx | 7.72 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Balloon.xlsx | 7.71 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Pv.xlsx | 7.67 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Fullyamort.xlsx | 7.67 KB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/Equityratio.xlsx | 7.64 KB |
Trackers
No trackers found.