Part 6:  Excel Background

These chapters cover the Excel basics necessary for Principles of Finance with Excel

Chapter 24
Introduction to Excel

Getting started
Formatting numbers
Absolute versus relative references
Saving the spreadsheet
Your first Excel graph
Initial Excel settings
Using functions
Printing

PPT for Chapter 24

Chapter 25
Graphs and charts in Excel

Basics of Excel charts
Creative use of legends
Graphing noncontiguous data
Line charts with titles on the x-axis
Graph titles that update

PPT for Chapter 25

Chapter 26
Excel functions

Financial functions
Math functions
Conditional functions
Statistical functions
Match and Index

PPT for Chapter 26

Chapter 27
Data tables

One-dimensional data tables
Two-dimensional data tables

PPT for Chapter 27

Chapter 28
Goal Seek and Solver

Installing Solver
Using Goal Seek and Solver
What’s the difference between Goal Seek and Solver?
Setting the accuracy levels for Goal Seek and Solver

PPT for Chapter 28

Chapter 29
Dates in Excel

Dates and times in a spreadsheet
Time and date functions
XIRR, XNPV
Example:  Computing option expiration dates

PPT for Chapter 29