Microsoft Excel for Financial Analysts

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

Learn How to Perform Financial Modeling and Analysis using Microsoft Excel

1. Introduction to Financial Analysis

1. What is Financial Analysis

2. Role of Microsoft Excel as a Tool for Financial Analysis

2. Essential Excel Functions for Financial Analysis

1.1 Excel Functions 1.xlsx

1. Excel Functions for Financial Analysis (Part 1)

2.1 Part 2.xlsx

2. Excel Functions for Financial Analysis (Part 2)

3.1 Assignment 1.xlsx

3. Assignment 1

3. Pivot Tables for Financial Analysis

1.1 Pivot Table for Financial Analysis.xlsx

1. Preparing Profit and Loss Statement with Pivot Tables

2.1 Assignment 2.xlsx

2. Assignment 2

3.1 Balanced Sheet with Pivot Tables.xlsx

3. Preparing a Balance Sheet with Pivot Tables

4. Introduction to Financial Modeling

1. What is Financial Modeling

2.1 Revenue Forecast Modeling.xlsx

2. How to Create a Revenue Forecast Model

5. What-if Analysis for Building Financial Models

1.1 Scenario Analysis 1.xlsx

1. Creating a Sales Forecast Model with Scenario Analysis

2. Goal Seek for Financial Analysis

3. Data Table

4.1 Assignment 3.xlsx

4. Assignment 3

6. Time Value of Money (TVM) Analysis

1. Time Value of Money Analysis

2.1 Present Value.xlsx

2. Calculating Present Value (PV)

3.1 Future Value.xlsx

3. Calculating Future Value

189,000 تومان

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

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

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

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