Lynda - Microsoft Excel 2007 Financial Analysis

کاربرد : آموزش جامع نرم افزار Excel 2007
نوع فایل : فیلم آموزشی
زبان : انگلیسی
سیستم عامل : Windows-Mac-Linux-Android-iOS
تولید کننده : Lynda
سال تولید : 2009

توضیحات

آموزش ارزیای و تحلیل داده های تجاری و مالی توسط نرم افزار اکسل 2007

Description

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

بخش های فایل

این فایل شامل 52 بخش می باشد که بخش های آن به صورت جداگانه در زیر آمده است.

Row	Title	Size
00. Introduction
1	00 01. Welcome	3.61 MB
2	00 02. Using the exercise files	412.18 KB
3	00 03. Disclaimer	302.46 KB
01. Designing a Financial Worksheet
4	01 01. Separating inputs and formulas	1.74 MB
5	01 02. Avoiding common mistakes	4.72 MB
6	01 03. Tracing formula precedents and dependents	2.47 MB
7	01 04. Evaluating Excel formulas step by step	2.32 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables
8	02 01. Tracking income and expenses using an Excel table	3.09 MB
9	02 02. Creating a Pivot Table from table data	3.51 MB
10	02 03. Pivoting a Pivot Table	2.14 MB
11	02 04. Filtering a Pivot Table	2.99 MB
12	02 05. Adding Pivot Table columns to enhance data analysis	2.99 MB
13	02 06. Tracking cash flow using a Pivot Chart	2.92 MB
03. Analyzing Financial Statements
14	03 01. Reading a corporate financial statement	5.88 MB
15	03 02. Introducing common-sizing strategies for analyzing financial statements	3.39 MB
16	03 03. Creating common-sized income statements	2.62 MB
17	03 04. Creating common-sized balance sheets	2.42 MB
18	03 05. Calculating percentage changes in financial statements	2.40 MB
04. Calculating Profitability Ratios
19	04 01. Calculating earnings per share	1.53 MB
20	04 02. Calculating return on equity and return on assets	2.29 MB
21	04 03. Calculating gross profit margin and net profit margin	2.82 MB
05. Calculating Liquidity and Activity Ratios
22	05 01. Calculating the current ratio and quick ratio	3.15 MB
23	05 02. Calculating the average collection period	1.59 MB
24	05 03. Calculating inventory turnover	1.29 MB
06. Calculating Leverage Ratios
25	06 01. Calculating the equity ratio	1.18 MB
26	06 02. Calculating the debt ratio	2.44 MB
27	06 03. Calculating the times interest earned ratio	1.49 MB
07. Calculating the Effect of Interest Rates on Loan Repayment
28	07 01. Calculating simple interest and compound interest	2.91 MB
29	07 02. Applying nominal versus effective interest rates (APR versus APY)	2.75 MB
30	07 03. Calculating the number of days between events	3.26 MB
08. Determining Future Cash Flows
31	08 01. Computing the future value of an investment	2.68 MB
32	08 02. Calculating present value	1.90 MB
33	08 03. Calculating net present value	2.20 MB
34	08 04. Calculating internal rate of return	1.98 MB
35	08 05. Calculating NPV and IRR for uneven input periods (XNPV and XIRR)	2.12 MB
09. Forecasting Future Growth
36	09 01. Projecting future results using the Forecast function	1.73 MB
37	09 02. Performing quick forecasts using the Fill handle	2.61 MB
38	09 03. Adding a trendline to a chart	2.17 MB
10. Determining Amortization and Depreciation Schedules
39	10 01. Introducing amortization	1.83 MB
40	10 02. Calculating payments on a fully amortized loan	1.88 MB
41	10 03. Calculating payments on a partially amortized loan (balloon payments)	1.64 MB
42	10 04. Calculating interest and principal components of loan repayments	4.72 MB
43	10 05. Introducing depreciation	1.64 MB
44	10 06. Calculating straight line depreciation	1.27 MB
45	10 07. Calculating declining balance depreciation	2.87 MB
46	10 08. Calculating double declining balance depreciation	2.69 MB
11. Analyzing Bond Investments
47	11 01. Introducing bonds and bond terminology	1.29 MB
48	11 02. Calculating a bonds yield	1.88 MB
49	11 03. Calculating the value of zero coupon bonds	2.64 MB
50	11 04. Pricing bonds to be offered to investors	1.95 MB
12. Conclusion
51	12 01. Goodbye	293.42 KB
13. ZZZ - فایلهای تمرینی
52	Ex_Files_Excel07_Fin_Ana	536.50 KB

شما می توانید مجموعه کامل بخش های این فابل را نیز به صورت مجموعه کامل دریافت نمایید.

اگر شما نسبت به این اثر یا عنوان محق هستید، لطفا از طریق "بخش تماس با ما" با ما تماس بگیرید و برای اطلاعات بیشتر، صفحه قوانین و مقررات را مطالعه نمایید.

دیدگاه کاربران

لطفا در این قسمت فقط نظر شخصی در مورد این عنوان را وارد نمایید و در صورتیکه مشکلی با دانلود یا استفاده از این فایل دارید در صفحه کاربری تیکت ثبت کنید.

(اختیاری)

تعداد کاراکتر مجاز: 1000