Discover Classes. Earn Rewards.

Advanced Excel for Financial Modeling

Unlock the full potential of Excel for financial analysts with this advanced course. Learn how to build and audit financial models, create sensitivity analyses, and master Excel's features for finance. Take your financial modeling skills to the next level with the tricks and techniques taught in this course.

  • Advanced
  • 18 and older
  • $350
  • 185 Madison Ave, New York, NY & Virtually Online
  • 7 hours

Start Dates (2)

  • $350
  • NYIM @ 185 Madison Ave 3rd Floor, New York, NY 10016
  • 7 hours
20 seats left
Book
20 seats left
Book
Showing 12 of 2

Class Description

Description

What you'll learn in this finance training:

Learn the tricks and techniques in Excel needed for financial analysts to build financial models, create sensitivity analyses, and more.

Master the advanced Excel tricks, techniques, and tools financial analysts use to build and audit financial models. By the end of this course, you will know how to write efficient and flexible formulas, create sensitivity analysis, and master Excel's features for finance.

  • Get started with cash flow modeling and projections in Excel
  • Master Excel shortcuts and techniques for financial modeling, including navigation, formula writing, and working without the mouse
  • Audit financial models and write efficient, flexible formulas
  • Learn advanced analytical tools for sensitivity analysis
  • Learn financial functions for NPV, IRR, Bond Yields, & Mortgage Payments
  • Conquer advanced functions financial analysts need: Nested functions, VLOOKUP-MATCH, INDEX-MATCH

Prerequisite:

  • Prior financial experience is helpful, but not required.
  • Excel proficiency equivalent to Intermediate Excel for Business is required, including VLOOKUP, Pivot Tables, and IF statements.

What You’ll Learn at a Glance

  • Financial functions: NPV, IRR, XNPV, and XIRR
  • Advanced database functions: VLOOKUP-MATCH, & INDEX-MATCH
  • Create Data Tables to show outputs based on various scenarios
  • Use Goal Seek's powerful calculation tools
  • Create financial projections based on historical data
  • Learn Hot Keys to work in Excel without the mouse
  • Master Excel with a variety of shortcuts finance professionals need

Course Syllabus

  • Advanced techniques to Expedite Workflow
    • Efficient formula writing
    • Formula & model auditing
    • Advanced cell locking
    • Hot Keys to work without the mouse
    • Windows & work with multiple applications
    • Go To Special
    • Paste Special
  • Project #1: Revenue build-up by store count and same store sales growth
    • Learn different methods for projecting company revenues
    • Apply advanced Excel techniques to quickly build out projections
  • Advanced Analytical Tools & Sensitivity Analysis
    • Goal Seek
    • Data Tables
    • Scenario Manager
  • Project #2: Cash flow modeling & sensitivity analysis
    • Project revenues and expenses
    • Discount cash flows to the present value
    • Run a sensitivity analysis for valuation based on revenue growth and gross margin
  • Database Functions for Finance
    • Advanced SUMIFS
    • VLOOKUP-MATCH
    • INDEX-MATCH
  • Functions for Financial Modeling
    • Financial functions
    • Date functions
    • Nested IF statements
    • IF Statements with AND/OR
    • CHOOSE function
    • Weighted average calculations
    • IFERROR
  • Projects #3: Loan amortization model
    • Model cash flows from an amortizing loan
    • Use advanced functions to aggregate the data

Learn more about Advanced Excel for Financial Modeling at NYIM Training

Syllabus

Advanced techniques to Expedite Workflow

Efficient formula writing

Formula & model auditing

Advanced cell locking

Hot Keys to work without the mouse

Windows & work with multiple applications

Go To Special

Paste Special

Project #1: Revenue build-up by store count and same store sales growth

Learn different methods for projecting company revenues

Apply advanced Excel techiques to quickly build out projections

Advanced Analytical Tools & Sensitivity Analysis

Goal Seek

Data Tables

Scenario Manager

Project #2: Cash flow modeling & sensitivity analysis

Project revenues and expenses

Discount cash flows to the present value

Run a sensitivity analysis for valuation based on revenue growth and gross margin

Database Functions for Finance

Advanced SUMIFS

VLOOKUP-MATCH

INDEX-MATCH

Functions for Financial Modeling

Financial functions

Date functions

Nested IF statements

IF Statements with AND/OR

CHOOSE function

Weighted average calculations

IFERROR

Projects #3: Loan amortization model

Model cash flows from an amortizing loan

Use advanced functions to aggregate the data

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYIM Training (742)

(4.5-star rating across 742 reviews)
  • Advanced Excel for Financial Modeling

    Reviewed by Emily M. on 12/1/2017
    It was a lot of fun, and the way it was taught really helped me relate the topics to how they would be useful in my day to day at work
  • Advanced Excel for Financial Modeling

    Reviewed by karen l. on 11/9/2017
    Very thorough and exercises were easy to follow. Small classes make it easy to learn and ask questions.
  • Advanced Excel for Financial Modeling

    Anonymous review on 10/27/2017
    Garfield is a great teacher. Really learned a lot
  • Advanced Excel for Financial Modeling

    Reviewed by Douglas K. on 12/14/2017
  • Advanced Excel for Financial Modeling

    Reviewed by Matthew B. on 11/17/2017
  • Advanced Excel for Financial Modeling

    Reviewed by Erich B. on 7/3/2017
See reviews for other classes at NYIM Training
loading...
Hide Reviews

Review Summary by CourseHorse

Students who have taken classes at Advanced Excel for Financial Modeling have found them to be informative, practical, and enjoyable. The teaching style used in the classes allows students to easily relate the topics to their work responsibilities, making the learning experience more valuable. The classes are also praised for their thoroughness and the accessibility of the exercises. The small class sizes enable students to comfortably ask questions and engage in active learning. One standout aspect of the classes is the instructor, Garfield, who is highly regarded as a great teacher. Quotes: 1. "The way it was taught really helped me relate the topics to how they would be useful in my day to day at work." 2. "Very thorough and exercises were easy to follow." 3. "Garfield is a great teacher. Really learned a lot."

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

NYIM Training

For nearly two decades, NYIM has trained thousands of business professionals in the latest computer software programs, including Excel, Financial Modeling, Microsoft Office, Adobe, SQL, AutoCAD, QuickBooks, and many more.

The company is known for its practical and hands-on approach to its instructor-led...

Read more about NYIM Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

NYIM Training

NYIM Training

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Finance Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...