Register Account


Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Application of Excel In Analytics and Finance
#1
[Image: download-2.png]

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

[To see links please register or login]


DOWNLOAD

[To see links please register or login]

[Image: signature.png]
Reply


Download Now



Forum Jump:


Users browsing this thread:
1 Guest(s)

Download Now