Essential Excel Modelling

Essential Excel Modelling

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.

Excel Modelling for Analysts and Professionals

Url: View Details

What you will 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

Rating: 0

Level: Beginner Level

Duration: 1.5 hours

Instructor: Pramod Kesav N