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

Earn a certificate

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

selected template

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