Lynda - Excel 2007: Financial Analysis
- Type:
- Other > Other
- Files:
- 98
- Size:
- 293.46 MiB (307714139 Bytes)
- Tag(s):
- Business
- Uploaded:
- 2016-01-16 11:15:20 GMT
- By:
-
2boweb
- Seeders:
- 3
- Leechers:
- 0
- Comments
- 1
- Info Hash: 237DA2013956BA1FFE8A8155E7CF51E4A4D3CD15
(Problems with magnets links are fixed by upgrading your torrent client!)
Lynda - Excel 2007: Financial Analysis This Course will be good to the Best for DL within 30 days after has been posed, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive. 2h 18m Intermediate Aug 25, 2009 | Uploaded in Jan 16, 2016 by 2boweb Subject: Business Software: Excel Author: Curt Frye Numbers and financial data drives today's business world and Excel 2007: Financial Analysis can help decode this information. The proper understanding of these numbers, and the formulas behind them, can be the gateway to corporate and personal success. Microsoft MVP (Most Valuable Professional) Curt Frye teaches basic fluency in corporate finance, enabling users to see the meaning behind essential financial calculations. Curt explains how to review formulas to ensure they have the proper inputs, and shows how to interpret formula output. He also covers how to calculate leverage ratios and amortization and depreciation schedules, as well as forecast future growth. Exercise files accompany this course. Topics include: • Building a financial worksheet with Pivot Tables Reviewing financial statements through common-sized balance sheets Calculating percentage change over time in financial statements Determining profitability ratios and return on investments Studying liquidity and activity ratios through an average collection period Computing the future value of an investment ////////////////////////////////////////////////////////////////////
| Reading a corporate financial statement-55978.mp4 | 15.29 MiB |
| Welcome-55962.mp4 | 12.44 MiB |
| Calculating interest and principal components of loan repayments-56013.mp4 | 12 MiB |
| Avoiding common mistakes-55967.mp4 | 10.85 MiB |
| Introducing common-sizing strategies for analyzing financial statements-55979.mp4 | 8.63 MiB |
| Creating a Pivot Table from table data-55972.mp4 | 8.15 MiB |
| Calculating the number of days between events-55998.mp4 | 7.79 MiB |
| Adding Pivot Table columns to enhance data analysis-55975.mp4 | 7.53 MiB |
| Filtering a Pivot Table-55974.mp4 | 7.38 MiB |
| Tracking cash flow using a Pivot Chart-55976.mp4 | 7.1 MiB |
| Tracking income and expenses using an Excel table-55971.mp4 | 6.9 MiB |
| Calculating declining balance depreciation-56016.mp4 | 6.88 MiB |
| Calculating simple interest and compound interest-55996.mp4 | 6.73 MiB |
| Applying nominal versus effective interest rates (APR versus APY)-55997.mp4 | 6.72 MiB |
| Creating common-sized income statements-55980.mp4 | 6.7 MiB |
| Calculating gross profit margin and net profit margin-55986.mp4 | 6.7 MiB |
| Calculating double declining balance depreciation-56017.mp4 | 6.61 MiB |
| Calculating the value of zero coupon bonds-56021.mp4 | 6.49 MiB |
| Computing the future value of an investment-56000.mp4 | 6.39 MiB |
| Performing quick forecasts using the Fill handle-56007.mp4 | 6.19 MiB |
| Creating common-sized balance sheets-55981.mp4 | 6.1 MiB |
| Calculating percentage changes in financial statements-55982.mp4 | 5.99 MiB |
| Calculating the debt ratio-55993.mp4 | 5.96 MiB |
| Tracing formula precedents and dependents-55968.mp4 | 5.53 MiB |
| Pivoting a Pivot Table-55973.mp4 | 5.43 MiB |
| Calculating NPV and IRR for uneven input periods (XNPV and XIRR)-56004.mp4 | 5.36 MiB |
| Evaluating Excel formulas step by step-55969.mp4 | 5.34 MiB |
| Calculating the current ratio and quick ratio-55988.mp4 | 5.31 MiB |
| Calculating return on equity and return on assets-55985.mp4 | 5.29 MiB |
| Calculating net present value-56002.mp4 | 5.26 MiB |
| Adding a trendline to a chart-56008.mp4 | 5.23 MiB |
| Calculating internal rate of return-56003.mp4 | 4.67 MiB |
| Pricing bonds to be offered to investors-56022.mp4 | 4.64 MiB |
| Calculating present value-56001.mp4 | 4.56 MiB |
| Introducing amortization-56010.mp4 | 4.49 MiB |
| Calculating a bond's yield-56020.mp4 | 4.3 MiB |
| Calculating payments on a fully amortized loan-56011.mp4 | 4.29 MiB |
| Separating inputs and formulas-55966.mp4 | 4.16 MiB |
| Projecting future results using the Forecast function-56006.mp4 | 4.15 MiB |
| Introducing depreciation-56014.mp4 | 4.07 MiB |
| Calculating payments on a partially amortized loan (balloon payments)-56012.mp4 | 3.94 MiB |
| Calculating the average collection period-55989.mp4 | 3.72 MiB |
| Calculating earnings per share-55984.mp4 | 3.59 MiB |
| Calculating the times interest earned ratio-55994.mp4 | 3.53 MiB |
| Calculating inventory turnover-55990.mp4 | 3.05 MiB |
| Calculating straight line depreciation-56015.mp4 | 2.96 MiB |
| Calculating the equity ratio-55992.mp4 | 2.7 MiB |
| Introducing bonds and bond terminology-56019.mp4 | 2.43 MiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/WashPost2008AnnualReport.htm | 1.64 MiB |
| Using the exercise files-55963.mp4 | 763.65 KiB |
| Goodbye-56024.mp4 | 574.58 KiB |
| Disclaimer-55964.mp4 | 544.3 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/WashPost2008AnnualReport_files/g42267g19s85.jpg | 46.6 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Calculated.xlsx | 15.28 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Filtering.xlsx | 15.13 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/PivotChart.xlsx | 15.12 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/Pivoting.xlsx | 14.95 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/Dates.xlsx | 11.51 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Mistakes.xlsx | 11.47 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Acp.xlsx | 11.3 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Separating.xlsx | 10.25 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Princint.xlsx | 10.25 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/CreatePivot_fixed.xlsx | 1 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Trendline.xlsx | 9.99 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/ZeroCoupon.xlsx | 9.85 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Tracing.xlsx | 9.73 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/SimpleAndCompound.xlsx | 9.68 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Pctchange.xlsx | 9.6 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Commonsizing.xlsx | 9.55 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Depreciation.xlsx | 9.36 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Csincome.xlsx | 9.25 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/Earnings.xlsx | 9.21 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Amortize.xlsx | 9.07 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Current and Quick Ratios.xlsx | 9 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Xnpvandxirr.xlsx | 8.88 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Doubledown.xlsx | 8.84 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter02/ExcelTables.xlsx | 8.8 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter03/Csbalance.xlsx | 8.77 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Declining.xlsx | 8.77 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Irr.xlsx | 8.68 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/DebtRatio.xlsx | 8.67 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/Yield.xlsx | 8.63 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter11/Pricing.xlsx | 8.59 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/Tieratio.xlsx | 8.51 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Futureval.xlsx | 8.48 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter05/Inventory.xlsx | 8.47 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/GrossProfit.xlsx | 8.44 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter04/ReturnOnAssetsAndEquity.xlsx | 8.33 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter07/Nomeffect.xlsx | 8.27 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter01/Evaluating_fixed.xlsx | 8 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Npv.xlsx | 7.89 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Fillhandle.xlsx | 7.88 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Straightline.xlsx | 7.85 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter09/Forecast.xlsx | 7.72 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Balloon.xlsx | 7.71 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter08/Pv.xlsx | 7.67 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter10/Fullyamort.xlsx | 7.67 KiB |
| Ex_Files_Excel07_Fin_Ana/Exercise Files/Chapter06/Equityratio.xlsx | 7.64 KiB |
2boweb, thank you for your efforts... May I request "Swift 2.0 Essential Training with Scott Gardner" new to Lynda since Nov 5... thanks again!
Comments