Excel basics for financial modeling

What Will You Learn?

  • Understand Microsoft Excel
  • Understand How to use MS Excel
  • Excel formulas and functions
  • Excel tools
  • Dynamic tables
  • Pivot tables & charts
  • Using Excel in financial analysis
  • Cover Sheet Formatting & Hyperlinks

Course Content

A. Introduction and Guide

  • Course introduction
    05:42
  • Download PDF & Excel Files

B. Microsoft excel overview

C. Aggregation formulas

D. Valuation Formulas

E. Logical Formulas

F. Lookup Formulas

G. Scenarios

H. Text Functions

R. Date Functions

J. Finance Formulas

K. Excel Tools

L. Dynamic Tables

M. Pivot tables & Charts

N. Financial Ratios

O. Cover Sheet Formatting & Hyperlinks

Student Feedback

Want to receive push notifications for all major on-site activities?