Financial Analyst Training Program

Excel & Financial Modeling Courses NYC

In this 5-day financial analyst program, you'll master Excel, review corporate finance and financial accounting concepts, and build a comprehensive valuation model on a public company. This bootcamp is the most effective and affordable course to gain the skills you need to succeed at a top financial firm. 

  • Core Excel Skills: Build a strong foundation in Excel with formulas, functions, Pivot Tables, shortcuts, and more.
  • Advanced Excel for Financial Modeling: Learn advanced techniques including Goal Seek, financial functions, shortcuts, and cash flow projection tools. 
  • Accounting, Corporate Finance & Valuation: Review corporate finance and accounting concepts, including enterprise value, the financial statement analysis, DCF modeling techniques, and corporate valuation principles.
  • Financial Modeling: Build an integrated 3-statement financial model. Create a DCF model on a public restaurant company using current financial data. Review company presentations, earnings releases, and financial reports to determine the model drivers and assumptions. Using valuation principles, you will derive a value per share and evaluate the equity as a potential investment.

Want to discuss this class further? Email the program director directly and find out if this is the right course for you.

Related Courses

Looking for a comprehensive Summer Program to prepare for an internship, full-time position, or interviews? Check out our Summer Financial Modeling Bootcamp.

Those with a strong background in Excel can attend our 3-day Financial Modeling Bootcamp or our 1-day Advanced Excel for Financial Modeling course. 

Prerequisites

Since this program covers core Excel the first two days, there are no prerequisites. Prior knowledge of finance and accounting is helpful but not required as these topics are covered throughout the program. Attendees will receive a short pre-learning guide one week prior to the start of the course. 

Register for a Package  help-solid

tag-solid $1313$1195 clock-solid 35 Hours map-marker-solid 185 Madison Avenue, NYC

Corporate training available

Email us for information

  • Custom Schedule

  • Dec 30–Jan 9

    • Excel for Business Fundamentals

      Monday, Dec 30, 10am–5pm

    • Intermediate Excel for Business

      Thursday, Jan 2, 10am–5pm

    • Financial Modeling Bootcamp

      Tue–Thu, Jan 7–9, 10am–5pm

  • Mar 6–18

    • Excel for Business Fundamentals

      Friday, Mar 6, 10am–5pm

    • Intermediate Excel for Business

      Friday, Mar 13, 10am–5pm

    • Financial Modeling Bootcamp

      Mon–Wed, Mar 16–18, 10am–5pm

  • Mar 12–18

    • Excel for Business Fundamentals

      Thursday, Mar 12, 10am–5pm

    • Intermediate Excel for Business

      Friday, Mar 13, 10am–5pm

    • Financial Modeling Bootcamp

      Mon–Wed, Mar 16–18, 10am–5pm

  • video-gallery-solid

    Video Training and Workbook Included

    Students get a workbook and lifetime access to self-paced training videos, a $95 value.

  • display-solid

    Computer Provided

    Modern computer classroom with a PC for each student to work on.

  • users-solid

    Small In-Person Classes

    Get personalized attention in small groups with an expert instructor in the classroom.

  • redo-line

    Free Retake

    Refresh the course materials within six months for free as long as there's space in the class.

The Financial Analyst Training Program includes

Excel for Business Fundamentals

Master the core Microsoft Excel functions in this one-day course. Automate calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.

Intermediate Excel for Business

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Use tools and formulas to format text. Manipulate data visuals with advanced charting skills. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of intermediate Excel, you'll unlock powerful techniques that will help you complete tasks more quickly.

Financial Modeling Bootcamp

Learn the skills you need to become a top financial analyst: advanced Excel, financial modeling, corporate finance, and accounting. Build a financial model to value a public company, and learn industry best practices from experienced investment bankers and analysts.

“I can honestly say I learned more useful modeling and excel skills from the Financial Modeling Bootcamp then I have through one and a half years of business school. The course effectively conveys key finance, corporate finance, and financial accounting concepts while also offering students the opportunity to build real financial models with real-time data. The 7:1 student to teacher ratio along with the experience and modeling expertise of Mourad offers a unique opportunity for a personalized learning experience. Whether you are a student looking to pursue a career in finance or a current professional simply looking to brush up on your Excel skills, I would highly recommend this course.”

— Noam L.

Full Course Syllabus

Download PDF Outline

Excel for Business Fundamentals

Introduction

  • Interface
  • Data Entry

Formulas

  • Autofill
  • Calculations
  • True or False
  • AutoSum Functions
  • Text Functions
  • Multi-Input Functions
  • Absolute Cell References

Formatting

  • Formatting
  • Format Painter
  • Conditional Format

Charts & Tables

  • Line Chart
  • Column Chart
  • Pie Chart
  • Tables

Workbook Management

  • Printing
  • Worksheets
  • Repeat Action
  • Shortcuts

End of Class Project

  • Project
  • Save and Close

Intermediate Excel for Business

Worksheet Management

  • Navigation
  • Paste Special

Working with Text

  • Splitting Text
  • Joining Text
  • Named Ranges
  • Data Validation
  • Sort & Filter
  • Remove Duplicates

Database Functions

  • VLOOKUP
  • HLOOKUP
  • VLOOKUP - Closet Match

Logical Functions

  • AND, OR
  • IF statements

Pivot Tables

  • Pivot Tables
  • Pivot Tables & Grouping
  • Multiple Pivot Tables

Statistical Functions

  • Ranking
  • COUNTIFS
  • SUMIFS

Advanced Charts

  • Combo Charts

End of Class Project

  • Project

Financial Modeling Bootcamp

Day I: Advanced Excel for Financial Modeling

  • Advanced techniques to Expedite Workflow
  • Advanced Analytical Tools & Sensitivity Analysis
  • Database Functions for Finance
  • Functions for Financial Modeling

Day II: Intro to Corporate Finance, Accounting, & Modeling

  • Intro to Corporate Finance
  • Enterprise value
  • Financial Accounting & Statement Analysis
  • Integrated Financial Modeling
  • Intro to DCF Modeling
  • Sensitivity Analysis
  • Intro to LBO Modeling

Day III: In-depth Financial Modeling & Valuation

  • Company Analysis
  • Financial projections
  • Terminal Value
  • Discounting Cash Flows
  • Corporate Valuation
  • Final Analysis & Reasonability Testing
help-solid

Frequently Asked Questions

  • Do I need to bring a computer?

    No. We provide a computer with the necessary software for each attendee. This course is available on Windows PC only.

  • Are discounts available for this course?

    This program is a discounted package of classes that is 15–25% off the individual class prices.

  • Does this course come with a book?

    Yes. This course includes a complimentary book or manual at no additional cost.

  • What if I need to retake this course? May I retake it for free?

    Most of our courses can be taken again for free. However, this course is not available to retake for free.

Excel & Financial Modeling Courses for Financial Analysts

Training Program for Investment Banking, Hedge Funds, Private Equity, Real Estate & Finance Professionals

To become a successful financial analyst, you'll need several skills, including a strong comfort level in Excel, a background in accounting, finance, and valuation, and financial modeling capabilities. This training program is geared toward current or aspiring financial analysts, including investment banking, private equity, hedge funds, asset management, real estate, and venture capital.

After completing this program, you will:

  • Go from beginner to advanced in your  Excel capabilities
  • Learn accounting concepts: Financial statements, working capital, and footnotes
  • Learn financial concepts: Enterprise value, corporate valuation, Discounted Cash Flow Modeling, LBO Modeling
  • Build financial modeling skills: Learn how to project cash flows for companies in Excel