Microsoft Excel for Finance

Focused View

Allen Aravindan

6:29:21

206 View

1. Excel Introduction

1. Excel Layout.mp4

02:45

2. Home Ribbon.mp4

06:09

3. Other Ribbons.mp4

07:13

4. Excel Layout Quiz.html

2. Excel - Cell Referencing

1.1 Excel- Relative Referencing.xlsx

1. Relative Referencing.mp4

19:42

2.1 One Dimentional Data Table.xlsx

2. One Dimensional Data Table.mp4

05:11

3. Relative Referencing Quiz.html

4. Relative Referencing Assignment.html

3. Excel Daily Functions

1.1 Daily Excel Operators.csv

1. Excel Functions.mp4

06:40

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.mp4

04:06

2. IF Function.mp4

09:46

3. Nested IF Function.mp4

09:55

4. Logical Operator Quiz.html

5. Logical Operator - Assignment.html

5. Excel Conditional Operators

1. Conditional Operators.mp4

07:57

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.mp4

20:24

2. Pivot Table Quiz.html

3.1 Vlook- Index Match Template (1).xlsx

3. VlookUp.mp4

12:27

4. VlokUp - Index & Match.mp4

09:42

5. VlookUp - Index & Match Quiz.html

7. Excel Data Visualization

1.1 Charts Template.xlsx

1. Excel Charts.mp4

35:45

2. Data Visualization - Best Practices.mp4

19:49

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.mp4

07:32

2. TVM Quiz.html

12. Compounding and Discounting

1.1 2-Compounding Effect.xlsx

1. Introduction to Compounding.mp4

16:36

2.1 5- Frequency of Compounding.xlsx

2. Frequency of Compounding.mp4

19:35

3.1 6- Continous Compounding.xlsx

3. Continuous Compounding.mp4

06:10

4. Quiz on Compounding.html

5.1 TVM Complete Template.xlsx

5. What is Discounting.mp4

06:50

6. Quiz on Discounting.html

7.1 4-Defintions of Rate.xlsx

7. Introduction to Rate.mp4

10:28

13. Cashflows

1.1 7- Series of Cashflow.xlsx

1. Series of Cashflow.mp4

20:58

2.1 9- Beg and End Cashflow.xlsx

2. Beginning and Ending Cashflow.mp4

13:18

3. Quiz on Cashflow.html

14. TVM in Excel

1.1 10- IRR Problems.xlsx

1. Problems with IRR.mp4

09:16

2.1 11- Goal Seek.xlsx

2. Goal Seek Function.mp4

03:48

3.1 8- TVM Functions Excel.xlsx

3. TVM Functions.mp4

07:33

4. TVM Functions Quiz.html

5. Fund Selection Case Study.html

15. Introduction to Financial Statements

1. Introduction to Financial Statements.mp4

34:13

2. Introduction to Financial Reporting.mp4

13:46

3.1 2.1 Mechanics Template.xlsx

3. Building Financial Statements in Excel - Part 1.mp4

21:21

4. Building Financial Statements in Excel - Part 2.mp4

16:08

5. Building Financial Statements in Excel - Part 3.mp4

04:18

Description

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

What You'll Learn?

Understand inner working of Microsoft Excel
Make use of functions such as SumIfs, CountIfs and AverageIfs for your analysis
Work with logical and conditional operators along with functions to analyze data based on certain criterias
Create beautiful and easy to understand Charts in Excel for Data Visualization
Understand importance of Time Value of Money and simulate it in Excel
Make use of Goal Seek Functions
Learn about Income Statement, Balance Sheet and Cash Flow Statements
Create Financial Statements in Excel and Analyse it

Who is this for?

For Undergraduates and Post Graduates who are about to complete college and start with their interviews.

MBA students who is appearing for interviews

Finance Professionals who want to learn Excel in Detail

All of them who have an interest in learning Microsoft Excel and upskilling

What You Need to Know?

You need a laptop and Microsoft Excel. We will take care of the rest.

No prior knowledge or skills required.

More details

Description
Are you looking to learn Excel, but finding it very difficult with all the technical jargons and concepts been thrown around?
Are you looking to make your life easier and make Excel work for you and save time?
Are you giving interviews but are not able to clear because of your Excel skills?
Donâ€™t worry, we have got you covered here. We will teach you Excel right from beginners level, (Really, we will start right from what is Excel), and go on all the way till advance level.

This course does not require you to have any pre-requisite knowledge or skills. This course will teach everything from beginning. This course has got you covered for everything.

In this course, you will learn the following:
Excel Introduction: Here you will learn how excel is structured. You will learn about Excel Worksheets, cells, and tabs. You will learn about Cell Referencing and its importance.
Excel Operators: In this section, how to write a function in Excel and make use of different functions and operators, such as logical operators and conditional operators, which are available in Excel.
Excel Data Analysis: Excel is widely used to analyse data and build models. Here you will learn how you can analyse data using Pivot, VlookUp and create various charts and dashboards for Data Visualization.
Time Value of Money: Here we will delve into Finance concept of Time Value of Money. We will learn its importance and we will apply it in Excel.
Financial Statement Analysis: Finally, in this section we will learn about Financial Statements, and we will create these financial statements and build a 3-statement Financial Model in Excel.

Learn from the best:
The Trainer of this course is an Ex-fund manager, Equity research analyst and CFA charter holder
Â· Extensive experience with fund management in alternative investments
Â· Lead Trainer at â€“ Mentor Me Careers
Â· Vast 11 Years of Experience in Fund Management, Product Management & Entrepreneurship.
Â· Trained 3000+ students in premier institutions
Â· Renowned Visiting Faculty in top tier 1 MBA colleges
Â· Ex-Partner- Ennovate Research Investment and Capital, Hedge Fund

What do you get:
Â· Well-designed focussed content on explaining concepts and building skills
Â· Extensive question bank and case studies for practice
Â· Downloadable course materials
Â· Regular course updates
Â· Forum doubt-solving answers quickly

After this course, you will be able to:
Â· Master Microsoft Excel for daily work
Â· Make your own personal Financial Plan
Â· Analyse Finances of a company from their Financial Statements
Â· Build 3 statements Financial Model and forecast values

About this Course
Â· This course has 30-day Money Back guarantee. We believe in providing value to the student. So, you get to explore the course and make an informed choice.
Â· You will get 24x7 doubt solving access.
Â· All concepts covered with practical application

We always strive to put studentâ€™s learning experience over everything else. So, we do look-out for your feedback on how we can improve our course and give our students a better learning experience. So, any suggestions for improving the learning experience is always welcomed.
Who this course is for:
For Undergraduates and Post Graduates who are about to complete college and start with their interviews.
MBA students who is appearing for interviews
Finance Professionals who want to learn Excel in Detail
All of them who have an interest in learning Microsoft Excel and upskilling

User Reviews

Rating

average 0

Total votes0

Focused display

My experience is similar to a wild voyage exploration with domains ranging from sales to algorithm trading and then product management. Mostly these wild adventure is a result of keeping an open mind to learning and accepting uncertainty.However, every experience and these willful risks taken have been proven priceless.Hoping to share some of that with you guys.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.