: 
Published 06/2022
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 583 MB | Duration: 15 lectures • 1h 22m
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/
Links are Interchangeable - No Password - Single Extraction