Application of Excel In Analytics and Finance
Free Download Application of Excel In Analytics and Finance
Published 6/2023
Created by Amit Khattar
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 11 Lectures ( 38m ) | Size: 286 MB
Focus is on use cases in case of Analytics and Finance such as Data Table, NPV Computation etc.
What you'll 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
Requirements
Basic knowledge of Excel
Description
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.
Who this course is for
Early stage working professionals and college students
Homepage
https://www.udemy.com/course/application-of-excel-in-analytics-and-finance/Links are Interchangeable - Single Extraction
