Discover Classes. Earn 10% Rewards.

Advanced Excel for Financial Modeling

Master the advanced Excel tricks, techniques, and tools financial analysts use to build and audit financial models in this comprehensive course. Learn efficient formula writing, sensitivity analysis, and financial functions for NPV, IRR, Bond Yields, and Mortgage Payments. Take your Excel skills to the next level and enhance your financial modeling capabilities.

  • Advanced
  • 18 and older
  • $350
  • Earn 10% Rewards
  • Price Lock
  • Interactive Online Classroom
  • 7 hours

Start Dates (1)

  • $350
  • 7 hours
20 seats left
Book
Showing 11 of 1

Class Description

Description

What you'll learn in this excel class:

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

This course does not require or cover corporate valuation or financial accounting concepts. The goal of this course is to master Excel's features. For in-depth analysis on financial modeling concepts as well as building comprehensive financial models on real-world companies, see our Financial Modeling Bootcamp. 

This course is included as the first day of our Financial Modeling Bootcamp. In our Bootcamp, you will build a valuation model on a public company while learning how to analyze its financial statements and create meaningful projections. The Bootcamp reviews financial accounting, corporate finance, and corporate valuation concepts, and includes smaller projects in LBO modeling and integrated 3-statement modeling. 

This course has a 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.

Course Overview

  • 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

Full 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 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


Learn more about Advanced Excel for Financial Modeling at NYC Career Centers.

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Also available in-person in NYC

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 NYC Career Centers (680)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

NYC Career Centers

Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD.

Our courses are instructor-led in small class sizes, located in our state-of-the-art training...

Read more about NYC Career Centers

CourseHorse Approved

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

NYC Career Centers

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 Excel Group Events

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

  • Price Lock Guarantee

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Earn 10% Reward Points

    Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!

  • No Added Fees

    Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!

  • Curated Courses

    Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!

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...