Application of Excel In Analytics and Finance

Application of Excel In Analytics and Finance, available at $19.99, with 11 lectures, and has 3 subscribers.

You will learn about Focus is on Excel Application Application of Excel in the field of Finance Creation of Dummy Data In Excel Application of Excel In the field of Analytics This course is ideal for individuals who are Early stage working professionals and college students It is particularly useful for Early stage working professionals and college students.

Enroll now: Application of Excel In Analytics and Finance

Summary

Title: Application of Excel In Analytics and Finance

Price: $19.99

Number of Lectures: 11

Number of Published Lectures: 11

Number of Curriculum Items: 11

Number of Published Curriculum Objects: 11

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Focus is on Excel Application
Application of Excel in the field of Finance
Creation of Dummy Data In Excel
Application of Excel In the field of Analytics

Who Should Attend

Early stage working professionals and college students

Target Audiences

Early stage working professionals and college students

The course focuses on Application of Excel in Predictive Analytics such as Data Table, Scenario Manager, Time Series Analysis, Histogram, Kurtosis and Skewness In Excel and Descriptive Analytics such as Waterfall Chart. In case of Financial applications, we are looking at computation of Net Present Value (NPV), Accrued Interest and Yield To Maturity (YTM) in Excel. The aim is to equip an excel professional with how to carry out business functionalities using excel tool. The course has a detailed step-by-step description of the process involved in the respective computations. The division of the course is into 11 lectures with a total duration of around 39 mins.

Predictive Analytics forms a very important focus area of the course as it has utility across various other business domains such as finance, sales etc. In the videos appropriate examples have been considered to explain the concepts with a use case. Any individual with a basic knowledge of excel will be able to follow the concepts explained in the lectures. For the ease of learning the course curriculum has been bifurcated into two headers wherein one header is focusing on the application of excel in analytics and the other focuses on the application of excel in the field of finance.

Course Curriculum

Chapter 1: Application of Excel In Analytics

Lecture 1: What-If Analysis In Excel

Lecture 2: Scenario Manager In Excel

Lecture 3: Random Data In Excel

Lecture 4: Time Series Analysis In Excel

Lecture 5: Histogram In Excel

Lecture 6: Kurtosis and Skewness In Excel

Lecture 7: Waterfall Chart In Excel

Chapter 2: Application of Excel in Finance

Lecture 1: NPV Function In Excel

Lecture 2: Accrued Interest In Excel

Lecture 3: Yield To Maturity (YTM) In Excel

Lecture 4: Loan Amortization Schedule In Excel

Instructors

Amit Khattar
Instructor in the field of Analytics and Finance

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu