Essential Excel Modelling
Learn the fundamentals of Microsoft Excel and its application in financial modeling. This course covers basic functions, pivot tables, and financial model types. Perfect for beginners and intermediate users. Save time and money with good modeling practices.
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
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
User Reviews
Be the first to review “Essential Excel Modelling”
You must be logged in to post a review.
There are no reviews yet.