• views: 152
• date: 17 June 2022
• posted by: voska89

Excel Modelling for Analysts and Professionals
What you'll learn
Students learn about Microsoft Excel fundamentals
Learns about basic Excel based Data Modelling concepts
Learns about Basic Functions, Logical Functions and Pivot Tables in Excel
Learns about Financial Model Functions and Concepts in Excel
Requirements
No Programming skills are required to take this course.
Description
Financial Modelling has come a long way in Office Productivity and has gained a lot of following in its own right especially in the large and complex Office Productivity landscape.
After taking this course, the student understands good modelling practices that saves time, money and efforts that is usually needed in putting together a financial model.
The comprehensive nature of this course lets the student understand the basic concepts in Microsoft Excel and the day to day problems that it strives to solve in the toughest landscape of Financial Modelling exercises.
It addresses technical model of Financial topics such as tools selection, best practices and model selection.
It gives a practical hands-on approach to all forms of problem solving and does cover some of the most interesting topics under the Excel Landscape.
This is mostly a basic level course on Excel Modelling and helps Analysts and Professional achieve a basic understanding on Excel and the problems that it is supposed to solve in the Financial World.
In this course the following topics are covered, namely,
Financial Model-Types and Purposes,
Excel Functions,
Pivot Tables,
Financial Modelling Functions and
Financial Models and Concepts.
In Financial Model-Types and Purposes, Financial Models are explained that does not require a lot of Financial Information in its model.
In Excel Functions, Basic Functions, Logical Functions, Cell References and Named Ranges are covered.
In Pivot Tables, advantages of Pivot Tables are explained and disadvantages are discussed with respect to SUMIF functions.
In Financial Modelling Functions, Aggregate Functions, Lookup functions, Nesting Index and Match and Offset functions are explained.
In Financial Models and Concepts, Regression Analysis, Financial Project Evaluation functions as well as Amortization Schedules are explained.
Who this course is for
Beginner Level for Microsoft Excel Data Modelling Functions
Intermediate level on Microsoft Excel Modelling Concepts

Homepage

https://www.udemy.com/course/essential-excel-modelling/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.