Financial Modeling with Excel Training

  • ID: 4471207
  • Training
  • 6 Days
  • KnowledgeHut Solutions
  • Training Dates: May 14-21, 2018
1 of 4
Microsoft Excel is one of the most popular tools to integrate financial models in an effective and secure manner. It is a primary financial management tool that has the ability to identify and track all the connecting points that help to manage enormous volumes of calculations involved in building a durable financial model.

Financial Modeling skills are essential for finance and commerce professionals, particularly for seasoned executives. It helps users gain a firm understanding of financial modeling techniques to succeed in today’s competitive environment.

Learn, apply and analyse financial models with Excel with competency and expertise after our three day course in FME. Get practical, hands-on training in powerful Excel tools that will help create financial models facilitating greater analytical accuracy. Build a solid foundation in Excel techniques that can be used to manipulate large datasets of financial information.

Delivered using a combination of lectures and practice problems and online training, our course will enable you to apply your learning to build useful, accurate, and robust financial models with ease.

On successful completion of the course, you will receive a Course Completion Certificate from KnowledgeHut with Credits (1 credit per hour of training).

What you will learn:
  • Learn to build a case study model
  • Understand the approach to be used for all your financial modeling projects
  • Create the skeleton structure, table of contents, calculations and error check pages
  • Learn how to use time series, checks, assumption, calculations and outputs
  • Differences between the three primary financial statements
  • Balance the balance sheet in seconds
  • Avoid the most common mistakes and pitfalls in model design
  • Use key functions and functionalities for financial modeling
  • Work around risk - Model sensitivities and scenarios, incorporating breakeven, what-if and payback analysis
  • Document, summarize and present results
  • Tips and techniques gained from experience
You will also get:
  • 24 hours training led by industry expert
  • Downloadable e-book
  • End to end support via phone, mail and chat
  • Individual workshop deliverables may be subject to change
Note: Product cover images may vary from those shown
2 of 4
2pm-6pm GMT

This is a basic introductory course
  • Accounting Boot Camp
  • Modeling Architecture
  • Sample Detailed Case
  • Time Line Modeling
  • Revenue & Capex
  • Depreciation
  • Financial Structure
  • Debt Schedule
  • Costs Drivers
  • Dividend & Tax
  • Integrating the Financials
  • Valuation
  • Ratio Analysis
  • Extra Excel Applications
  • Circularity Switch & Iteration
  • Simple Macros
  • Bond Valuation
Note: Product cover images may vary from those shown
3 of 4


4 of 4
Jochen Siepmann - Director
Note: Product cover images may vary from those shown
5 of 4
Note: Product cover images may vary from those shown
6 of 4
This course is for anybody involved in financial decision making/ planning related to large corporates. Financial modeling is a mandatory activity for investment bankers, bankers, project finance persons, equity research folks, PE & VCs.

This training is ideal for:
  • Financial analysts
  • CFOs
  • Financial controllers
  • Analysts
  • Credit managers
  • Risk managers
  • Mergers, acquisitions and buyout specialists
  • Corporate finance staff
  • Ideal for candidates who are Graduates, Post Graduates, Post Doctoral, or have completed courses in Engineering and Commerce who want to have a career in finance
Note: Product cover images may vary from those shown