Training The Street

Training the Street's Excel Short Cuts - VLookup Follow along as Daniel Hofstein explains how to use the VLookup formula to quickly find data in a table. Browse our other Excel Short Cuts here: https://lnkd.in/gNpwjStm

Equity Research | New Job-Based Bundle https://lnkd.in/gEhKPTvV This bundle equips you with the essential tools and expertise needed to thrive in the complex world of Equity Research. Enroll now to elevate your understanding of financial modeling, valuation techniques, market analysis, and strategic decision-making, empowering you to excel in equity investment.

Real Estate Fundamentals | London | Sept 25 - 26 https://lnkd.in/gVj5CR3B Learn the essentials of the Commercial Real Estate (CRE) industry from acquisition modeling to cash flow analysis. You’ll also learn fundamentals including occupancy/vacancy, absorption, and rent rolls with an overview of lease types and how to calculate rents based on leasable square footage. What you will learn: • Excel Best Practices and Efficiencies • CRE cash flow analysis • Acquisition modeling • How to calculate IRRs and NOI yield • Lease types

Thank you Adrien for your kind words: "Great instructors with lots of practical examples and real life cases examples, which greatly helped apply theory and reasoning method. Particularly appreciated the M&A course! Would definitely recommend!" Register for Core Comprehensive: https://lnkd.in/gZCu4ZkS

Core Comprehensive - Financial Modeling & Corporate Valuation | Seattle | August 26-30 - Last chance for early bird pricing! Register before July 27th to save up to $500. https://lnkd.in/g_7UCr3C Utilizing the same case-study-based approach delivered to our corporate clients, Core Comprehensive equips participants with the essential skills and practical knowledge crucial for success in the finance sector. What You'll Experience: Days 1 & 2: Mastering Financial Modeling & Advanced Sensitivity Analysis - Construction and Application of core statements - Troubleshooting the Model - Utilizing the Finished Product - Advanced Sensitivity Analysis Day 3: Valuation Techniques and Discounted Cash Flow Analysis - Public Comparables Analysis - Overview of Acquisition Comparables Analysis - Discounted Cash Flow Analysis - Analyzing Results Day 4: Merger Consequences Analysis - Overview: Merger Consequences Analysis - Building an M&A model for a potential acquisition of the case company Day 5: Leveraged Buyout Analysis - Overview: Leveraged Buyout Analysis - Constructing an LBO model for the case company

Training the Street Excel Short Cuts - The F1 Key If you find yourself accidentally opening the sidebar with the F1 Key, there's no need to rip it out of your keyboard - just hold down ctrl, press space, and C to close. Other lesser known uses for the F1 Key? Ctrl + F1 - Open and collapses the top ribbon. Alt + F1 - Inserts your default chart.

TTS Turbo Macros will boost your productivity in Excel and enhance your workflow. Download it today! https://lnkd.in/g263Kdev

Great feedback from our last Core Comprehensive session in NYC. "Alex was a great instructor. He explained concepts in a way everyone could understand, and was happy to answer any questions" Register today: https://lnkd.in/gJpjvApq

Fast Track: Financial Modeling | Atlanta | Sept 19-20 https://lnkd.in/g6Fj4HmB Join us for an intensive 2-day course and learn how to build an interactive three-statement financial model from scratch, blending accounting, finance, and Excel skills. Through a mixture of guided lectures and micro exercises, you'll learn hands-on, real-world, applications of financial modeling.

Training the Street Excel Short Cuts - Anchoring Follow along as Daniel Hofstein walks through how to use the F4 key to toggle through the various cell anchoring options within an Excel formula.