Microsoft Excel for Finance

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

Learn Excel Skills from Beginner to Advance Level and apply it with your Finance knowledge

1. Excel Introduction

1. Excel Layout

2. Home Ribbon

3. Other Ribbons

4. Excel Layout Quiz.html

2. Excel - Cell Referencing

1.1 Excel- Relative Referencing.xlsx

1. Relative Referencing

2.1 One Dimentional Data Table.xlsx

2. One Dimensional Data Table

3. Relative Referencing Quiz.html

4. Relative Referencing Assignment.html

3. Excel Daily Functions

1.1 Daily Excel Operators.csv

1. Excel Functions

2.1 Daily Excel Operators quiz.csv

2. Daily Excel Function - Quiz.html

3. Daily Excel Functions Quiz.html

4.1 Daily Excel Operators Solution.xlsx

4. Solution File - Daily Excel Functions.html

4. Excel Logical Operators

1.1 Logical Operator (1).xlsx

1. The need for logical operators

2. IF Function

3. Nested IF Function

4. Logical Operator Quiz.html

5. Logical Operator - Assignment.html

5. Excel Conditional Operators

1. Conditional Operators

2.1 Conditional Operator Quiz.xlsx

2. Conditional Operator Quiz.html

3. Conditional Operator Quiz.html

6. Pivot Table and VlookUp

1.1 Pivot Table Template.xlsx

1. Pivot Table

2. Pivot Table Quiz.html

3.1 Vlook- Index Match Template (1).xlsx

3. VlookUp

4. VlokUp - Index & Match

5. VlookUp - Index & Match Quiz.html

7. Excel Data Visualization

1.1 Charts Template.xlsx

1. Excel Charts

2. Data Visualization - Best Practices

3. Data Analysis Assignment.html

8. Case Study 1 - Insurance Analysis Case Study

1.1 Insurance Analysis Case.xlsx

1. Case Study File.html

2. Analysis Questions.html

3.1 Insurance Analysis Case Solution.xlsx

3. Solution File.html

9. Case Study 2 - Market Crash Indicator

1.1 Market Crash Indicator Case.xlsx

1. Case Study File.html

2. Market Crash Indicator - Quiz.html

3.1 Market Crash Indicator Case Solution.xlsx

3. Solution FIle.html

10. Case Study 3 - Stock Recommender System

1.1 Stock Recommender System Case.xlsx

1. Case Study File.html

2. Stock Recommender System - Quiz.html

3.1 Stock Recommender System Solution.xlsx

3. Solution FIle.html

11. Time Value of Money

1.1 1-Introduction TVM.xlsx

1. What is Time Value of Money

2. TVM Quiz.html

12. Compounding and Discounting

1.1 2-Compounding Effect.xlsx

1. Introduction to Compounding

2.1 5- Frequency of Compounding.xlsx

2. Frequency of Compounding

3.1 6- Continous Compounding.xlsx

3. Continuous Compounding

4. Quiz on Compounding.html

5.1 TVM Complete Template.xlsx

5. What is Discounting

6. Quiz on Discounting.html

7.1 4-Defintions of Rate.xlsx

7. Introduction to Rate

13. Cashflows

1.1 7- Series of Cashflow.xlsx

1. Series of Cashflow

2.1 9- Beg and End Cashflow.xlsx

2. Beginning and Ending Cashflow

3. Quiz on Cashflow.html

14. TVM in Excel

1.1 10- IRR Problems.xlsx

1. Problems with IRR

2.1 11- Goal Seek.xlsx

2. Goal Seek Function

3.1 8- TVM Functions Excel.xlsx

3. TVM Functions

4. TVM Functions Quiz.html

5. Fund Selection Case Study.html

15. Introduction to Financial Statements

1. Introduction to Financial Statements

2. Introduction to Financial Reporting

3.1 2.1 Mechanics Template.xlsx

3. Building Financial Statements in Excel - Part 1

4. Building Financial Statements in Excel - Part 2

5. Building Financial Statements in Excel - Part 3

139,000 تومان

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

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

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

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