Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Essential Excel Modelling
1 students

Essential Excel Modelling

Excel Modelling for Analysts and Professionals
Created byPramod Kesav N
Last updated 6/2022
English
English [Auto],

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

Course content

7 sections • 15 lectures • 1h 22m total length

  • Financial Model - Types and Purposes8:03

    Explore essential Excel modeling by examining financial model types and purposes, inputs and outputs, sensitivity and scenario analysis, and dashboards and non-financial models.

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,

  1. Financial Model-Types and Purposes,

  2. Excel Functions,

  3. Pivot Tables,

  4. Financial Modelling Functions and

  5. 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

Report abuse