Why take this course
  • Provides a solid foundation in applied corporate valuation in a condensed, practical manner (for both finance and
    non-finance job functions)
  • Essential foundation before interviews and internships
  • Enhances the learning experience in finance and financial statement analysis classes

COMPREHENSIVE MODELING

COMPREHENSIVE MODELING
$250
add to cart
DESCRIPTION

This package gives you everything you need to know to be fast and efficient in Excel and how to build a model from scratch by combining our Excel Best Practices and Financial Modeling courses. While this will not provide you a corporate finance foundation like the Valuation and Modeling package or the complete package, this will give you the practical Excel and modeling skills. The skills and speed you’ll gain from this course will be valuable regardless of your prior Excel background or Excel skill level and whether you’re in finance, consulting, technology, or at any business. This course is the self-study version of one of our most popular live training programs at the top investment banks, consulting firms, and other Fortune 500 companies, as well as the top MBA programs.

KEY FEATURES

Excel Best Practices: Learn how to quickly and efficiently use shortcuts to navigate, format, and build formulas and projections so you can model without touching the mouse.

  • Flip Chart book with shortcut keys and techniques
  • Excel drills and exercises
  • Over 4 hours of online video instruction
  • Estimated time to complete is 6 hours
  • 6 months free access to Online Companion
  • Compatible with PC Excel 2007 / 2010 / 2013 / 2016
  • Note: This course is not optimized for Mac Versions of Excel

Financial Modeling: Learn the actual hands-on step by step process of constructing of a dynamic model with 5 years of projections from scratch.

  • 180 page book, Excel models (template + solutions) and over 4 hours of online videos
  • Estimated time to complete is 12-15 hours
  • Case study with real-world disclosure
  • 6 months free access to Online Companion
  • Optimized for PC Excel 2007 / 2010 / 2013 / 2016
  • Note: The Excel shortcuts in this course are not optimized for Mac Versions of Excel, but this will not detract substantially from the course experience

TOPICS COVERED

Excel Best Practices

  • Navigating in Excel
  • Optimizing your modeling environment
  • Modeling standards used by practitioners
  • Modeling and Excel efficiencies
  • Advanced modeling techniques
  • Data table analysis
  • Conditional formatting
  • TTS’ famous shortcut keys and function keys
  • TTS’ popular macro toolkit (TTS Turbo Macros)

Financial Modeling

  • Income statement, balance sheet and cash flow statement relationships
  • Working capital, depreciation and capital expenditure schedules
  • Intangibles amortization schedule
  • Shareholders’ equity schedule with a share repurchase table
  • Debt and interest schedule with a “cash sweep”
  • Understanding and controlling circular references
  • Strategies for balancing a model
  • Sensitivity analysis to match expected financial performance
  • How to build a quick discounted cash flow analysis (DCF)

PREREQUISITES

  • This course assumes basic accounting knowledge. The Fundamentals of Financial Accounting & Analysis book will give you a good foundation if you don’t have any accounting knowledge
  • Corporate finance knowledge is helpful but not absolutely required. If you want a solid foundation on how companies are valued, the Fundamentals of Corporate Valuation book is perfect

TESTIMONIALS

Excel Best Practices

  • “Nothing is more key to becoming a successful investment banking analyst or associate than speed and proficiency. Becoming fast is achieved by becoming efficient. In Excel, program setup and the associated shortcuts can make you incredibly efficient. This course is extremely practical and honed in on the best way to become efficient navigating Excel. As a living testament to the benefits of this program, every analyst at the bulge bracket investment bank where I work has the TTS list of excel shortcuts printed out and posted on his/her cube wall.”
  • “I took a TTS Excel course this past year during my MBA program and found the course immediately useful both on the job and during class. Currently, I am using the online refresher to prepare for job interviews.”
  • “I have always considered myself to have a high proficiency in Excel through my experiences in Finance and Data Management. This course still proved to be invaluable.”

Financial Modeling

  • “As someone who has passed all three CFA exams and worked in private equity, this course is a great tool in applying acquired knowledge.”
  • “Love it. My usage is actually for use in nonprofits and small business - but I got plenty of tips and methods I can use to do my financial projections and analysis more efficiently. Lessons easy to follow at least at my level”
  • “TTS is the best on the Street. I've had training with them through a bulge bracket investment bank for summer internship and through business school classes. Their courses deliver a simple to follow natural progression to building a model. It’s all based on real world application and not just theoretical. After going through the course, you will have the flexibility of building a bare bones model in 30 minutes or a much more elaborate model with additional add-ons that are company specific. Due to the strong foundation TTS develops, it’s easy to add additional complexity. The time saved from learning all the shortcuts is necessary to survive banking and worth the class itself (would recommend doing the excel best practices course for this as well).”
  • “Mastering financial modeling is becoming an essential part of business career even as a management consultant, not even working in a finance role/ within the financial industry. Perhaps just knowing the advanced features of Excel USED to be sufficient. But even then you still don’t have an understanding of how to organize the data from financial statements and 10-Ks in the most efficient manner that delivers the maximum insights. The TTS online course takes a comprehensive, soup to nuts approach and walks you through the entire process through the lens of Excel. Definitely the most practical and comprehensive training I’ve seen. Highly recommended!!!”