TMCnet - World's Largest Communications and Technology Community



6 Day Course: Financial Modeling with Excel Training (May 12-13, 19-20, and 26-27, 2018) -
[April 16, 2018]

6 Day Course: Financial Modeling with Excel Training (May 12-13, 19-20, and 26-27, 2018) -

The "Financial Modeling with Excel Training" training has been added to's offering.

Learn, apply and analyse financial models with Excel with competency and expertise after this 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, this 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 b 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

Key Topics Covered

  1. Accounting Boot Camp
  2. Modeling Architecture
  3. Sample Detailed Case
  4. Time Line Modeling
  5. Revenue & Capex
  6. Depreciation
  7. Financial Structure
  8. Debt Schedule
  9. Costs Drivers
  10. Dividend & Tax
  11. Integrating the Financials
  12. Valuation
  13. Ratio Analysis
  14. Extra Excel Applications
  15. Circularity Switch & Iteration
  16. Simple Macros
  17. Bond Valuation

For more information about this training visit

[ Back To's Homepage ]

Technology Marketing Corporation

35 Nutmeg Drive Suite 340, Trumbull, Connecticut 06611 USA
Ph: 800-243-6002, 203-852-6800
Fx: 203-866-3326

General comments:
Comments about this site:


© 2018 Technology Marketing Corporation. All rights reserved | Privacy Policy