Key Information
Advanced Excel & Financial Modeling Intensive
Financial Modeling Bootcamp
FinTech Bootcamp Certificate
$1495 24 Hours
$895 21 Hours
$2695 54 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. 
Gain advanced skills in Excel for data analytics and financial modeling in this immersive bootcamp. Likewise, learn Python for data science and become an asset to any company. This course is intended for individuals looking to gain technical and financial experience for positions as financial analysts.
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
Not currently scheduled
Next Start Date
Not currently scheduled
View schedule at training-nyc.com
Not currently scheduled
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
  • 24 HoursAdvanced Excel & Financial Modeling Intensive
  • 30 HoursPython for Data Science Bootcamp
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
  • Excel analytics: Formulas, functions, Pivot Tables, Scenario Analysis
  • Advanced Excel: Goal Seek, financial functions, shortcuts, and cash flow projection tools. 
  • Finance, accounting, and corporate valuation concepts
  • Financial Modeling: Build Discounted Cash Flow models to value public companies
  • Python: Handling different types of data, such as integers, floats, and strings
  • Python: Analyze tabular data with Numpy and Pandas
  • Python: Make predictions with linear regression, using scikit-learn