Key Information
Advanced Excel & Financial Modeling Intensive
Financial Modeling Bootcamp
FinTech Bootcamp
$1495 24 Hours
$895 21 Hours
$2995 60 Hours
Overview
In this one-week program, you'll learn core and advanced Excel, financial accounting, corporate finance, and financial modeling. 
Learn essential finance & accounting concepts while building a comprehensive discounted cash flow (DCF) model in Excel. This financial modeling class blends finance, accounting and Excel concepts into an intensive 3-day course. 
Learn Python for financial analysis, machine learning, and algorithmic trading from experienced finance & engineering professionals in this 60-hour immersive.
Prerequisite
Prior knowledge of beginner Excel concepts, including basic formulas, functions, formatting, and charts is required. Tuition to this course includes free entry into our Excel Fundamentals course. See course dates and email us after you register for the program to enroll in Excel Fundamentals for free.
Prior financial experience is helpful, but not required. Those without a finance or accounting background will receive a short guide prior to the course (request upon registration) to acclimate themselves to terminology. Excel proficiency equivalent to Intermediate Excel for Business is required, including VLOOKUP, Pivot Tables, and IF statements. Our Financial Analyst Training Program includes beginner and intermediate Excel along with this 3-day bootcamp.
Open to Beginners
Location
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
Scheduling Options
Not currently scheduled
View schedule at training-nyc.com
Weekends & weekdays
Next Start Date
Not currently scheduled
View schedule at training-nyc.com
Oct 10–Dec 19, Saturdays
Certification
Receive a Certificate of Completion
Receive a Certificate of Completion
New York-licensed Certificate Program
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Courses Included (Certificates only)
N/A
N/A
  • 30 HoursPython for Finance Bootcamp
  • 18 HoursMachine Learning & Automation for Finance
  • 12 HoursAlgorithmic Trading with Python
Discounts See our discounts policies for more details
  • Take 10% off this course if you’ve previously taken any 12+ hour course.
  • Take $100 off this course if you’re an individual paying for yourself (not reimbursed by a company).
  • Take 10% off this course if you’ve previously taken any 12+ hour course.
  • Take $100 off this course if you’re an individual paying for yourself (not reimbursed by a company).
  • This is a discounted package of classes that is 15–25% off the individual class prices. Other discounts do not apply.
Payment Plan See our payment plan FAQ for more details
This program is eligible for our “pay-as-you-go” payment plan.
Target Audience
Anyone

Participants with prior knowledge of Excel looking to add fluency in financial and accounting concepts and financial modeling skills, including:

  • Those working in or seeking a position in finance, including investment banking, hedge funds, private equity, real estate, and FP&A
  • College and graduate students looking to supplement academic coursework with practical applications of financial modeling and prepare for technical interviews 
  • Those working in or seeking a position in the finance division of a non-financial company to gain skills in advanced Excel, corporate finance, accounting, and cash flow modeling
Anyone
What You’ll Learn
  • Financial Concepts, Market Capitalization, & Enterprise Value
  • Financial Accounting including accrual versus cash accounting
  • Discount Cash Flow (DCF) Modeling: Assumptions, Projecting Cash Flows, Sensitivities, Auditing
  • Excel Techniques including Data Validation, CHOOSE, Data Tables, Goal Seek and more
  • Leveraged Buyouts (LBO) Modeling
  • Real Company Analysis
  • Setup the Financial Model and model projections
  • Corporate Valuation and derive a value per share
  • Analyze the Model Output
  • Financial Concepts, Market Capitalization, & Enterprise Value
  • Financial Accounting including accrual versus cash accounting
  • Discount Cash Flow (DCF) Modeling: Assumptions, Projecting Cash Flows, Sensitivities, Auditing
  • Excel Techniques including Data Validation, CHOOSE, Data Tables, Goal Seek and more
  • Leveraged Buyouts (LBO) Modeling
  • Real Company Analysis
  • Setup the Financial Model and model projections
  • Corporate Valuation and derive a value per share
  • Analyze the Model Output
  • Python: Handling different types of data, such as integers, floats, and strings
  • Python: Analyze tabular data with Numpy and Pandas and graph the results using Matplotlib
  • Python: Learn how to pull data from multiple sources 
  • Machine Learning: Learn how to analyze a financial statement  using Python 
  • Machine Learning: Learn financial topics such as WACC, NPV, IRR
  • Machine Learning: Learn how to build predictive models for internal budgeting 
  • Algorithmic Trading: Learn how to use Pyhton to automate trading 
  • Algorithmic Trading: Learn commonly used trading strategies