The Development Pod

The Power of Microsoft Excel

What version of Excel do you need for this course?

For Mac users

(OPTIONAL): Review of VLOOKUP, MATCH, INDEX, and OFFSET functions

Two-way lookups in Excel

Two-way conditional lookups

Finding the location of a maximum

Conditional drop-down lists (data validation)

Conditional formatting based on formula

Example: Conditional formatting to identify errors

Comparing lists

Example: Who hasn't signed up?

Managing duplicates, Part 1

Managing duplicates, Part 2

Example: Expiry dates

Most frequent text

Customizing Excel for financial applications

Time value of money

Simple and compound interest, Part 1

Simple and compound interest, Part 2

Amortized loans

Using Excel to create an amortization schedule

Amortization schedule with extra payments

Effective vs. nominal interest rate

Savings accounts with payments and disbursements

Interest-only loans

Lines of credit

Depreciation

Common depreciation methods, Part 1

Common depreciation methods, Part 2

Cash flows and net present value, Part 1

Cash flows and net present value, Part 2

Comparing alternatives

Internal rate of return (IRR)

Introduction to case studies

One-way Data Tables, Part 1

One-way Data Tables, Part 2

Two-way Data Tables

Example: Two-way Data Table

Goal Seek and Solver for targeting problems, Part 1

Goal Seek and Solver for targeting problems, Part 2

Solver for optimization problems

Using the Solver with constraints, Part 1

Using Solver with constraints, Part 2

Trendlines, Part 1

Trendlines, Part 2

Linear interpolation

Model building, Part 1: Simple linear regression

Model building, Part 2: General linear regression

Model building, Part 3: Multilinear regression

(OPTIONAL) Why use adjusted R-squared and not R-squared?

Introduction to nonlinear regression (logisitic regression)