Microsoft Excel for Finance, Accounting & Financial Analysis

سرفصل های دوره

Excel tips & tricks for Accounting, Finance and Financial Analysis. Learn from the Bestselling Accounting Instructor

1 - Getting to know Excel

1 - Getting started with Excel

2 - Understanding and working with Cell

3 - Understanding and working with Column

4 - Understanding and working with Row

5 - Mastering Copy Paste

6 - Mastering Autofill

7 - Intelligent Navigation with Excel data

8 - Basic Mathematical functions

9 - Unlocking Keyboard shortcuts with Masterkey

10 - Homework Entering 10 records in Excel

11 - Best practices entering data in Excel

2 - Depreciation with Excel

12 - Revising the Accounting concept of deprecation

13 - Depreciation-notes.pptx

13 - Depreciation-with-Excel-solved.xlsx

13 - Depreciation-with-Excel-unsolved.xlsx

13 - Section Resources.html

14 - SLN Straight Line Method

15 - DB Declining Balance Method

16 - DDB Double Declining Balance

17 - SYD Sum of Years Digits Method

18 - VDB Variable Declining Balance

19 - Depreciation-with-Excel-Homework-Answers.xlsx

19 - Depreciation-with-Excel-unsolved-Homework.xlsx

19 - Homework Practice of Depreciation with Excel formulas.html

3 - Present Value Future Value

20 - Introduction to PV and FV

21 - PV-and-FV.xlsx

21 - PV-and-FV-Unsolved.xlsx

21 - PV-and-FV-notes.pdf

21 - Section Resources.html

22 - Calculating Future Value from Present Value Present Value from Future Value

23 - Revising Annuity Concept

24 - Calculating PV of Annuity

25 - Calculating FV of Annuity

26 - Calculating FV with changing interest rates

27 - Homework Calculating PV FV.html

27 - PV-and-FV-Homework.xlsx

27 - PV-and-FV-Homework-Unsolved.xlsx

28 - Calculating Discount Rate RATE

29 - Calculating Number of Periods NPER

4 - Net Present Value and IRR

30 - NPV-and-IRR-notes.pptx

30 - NPV-and-IRR-solved.xlsx

30 - NPV-and-IRR-unsolved.xlsx

30 - Section Outline and Practice files.html

31 - NPV Revising the NPV Concept

32 - Net Present Value NPV

33 - XNPV

34 - Revising the concept of IRR

35 - IRR Internal Rate of Return

36 - XIRR

37 - Homework Calculate NPV and IRR.html

37 - Homework-NPV-and-IRR.xlsx

37 - Homework-answers-NPV-and-IRR.xlsx

38 - MIRR

39 - PDURATION

40 - RRI

5 - Loan Mortgage Repayment

41 - Loan-and-mortgage-payment-Solved.xlsx

41 - Loan-and-mortgage-payment-Unsolved.xlsx

41 - Resource files for the Section.html

42 - PMT

42 - PMT-PPMT-IPMT-ISPMT.xlsx

43 - PPMT

44 - IPMT

45 - CUMIPMT

46 - CUMPRINC

47 - ISPMT

6 - Nominal and Effective Rate of Interest

48 - Converting Nominal Rate to Effective Rate

48 - Nominal-and-Effective-Rate.xlsx

49 - Converting Effective rate to the nominal rate

7 - Bond Valuation

50 - Price Market Value

50 - Price-and-Yield-Redeemable-Bond-with-Periodic-Interest.xlsx

51 - Yield Investors required rate or kd

8 - Whatif Analysis

52 - Data-Analysis.xlsx

52 - Goal Seek

53 - Goal Seek Example

54 - Data Table

55 - Two Way Data Table

56 - Scanerio Manager

9 - Financial Statement Preparation with Pivot Tables

57 - 1.Data-file-for-students-Merging-data-into-1-sheet-Data-file.xlsx

57 - Simplifying Financial Data extracted from a Financial System

58 - Preparing Profit Loss Statement with Pivot Tables

59 - 1.Data-file-for-students-Merging-data-into-1-sheet.xlsx

59 - Preparing Balance Sheet with Pivot Tables

10 - Financial Statement Vertical and Horizontal Analysis

60 - Apple-Inc-P-L-BS-lectures.xlsx

60 - Profit Loss Statement Horizontal Analysis

61 - Profit Loss Statement Trendlines

62 - Balance Sheet Trendlines and Horizontal Analysis

63 - Profit Loss Statement Vertical Analysis

64 - Balance Sheet Vertical Analysis

11 - Other miscellaneous

65 - Extracting month number as per FY

65 - FY-dates.xlsx

66 - Extracting Quarter number as per FY

67 - Calculating Quarter Number

68 - Handling wrong date format

68 - Handling-wrong-date-format.xlsx

69 - Handling wrong date format Part 2

70 - Preparing GL for Reporting Analysis

12 - Bonus Section

71 - Bonus lecture.html

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

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

تولید کننده: Udemy