Matthew Whitledge, Ph.D.

Excel: Substitute Replace and Concatenate (&)

Excel: Date and Time Functions 2

Excel: Date and Time Functions 1

Excel: Hyperlink with Yahoo! Finance and SEC EDGAR

Excel: IF Function

Excel: VLOOKUP Function

Excel: Formatting Cells Introduction

Excel Date and Time Functions (TODAY, NOW, DAY, MONTH, YEAR, DAYS, DATE)

BA II Plus: Capital Budgeting Calculator Net Present Value

BA II Plus: Bond Pricing Calculator

BA II Plus: TVM Calculator APR and EAR

BA II Plus: TVM Calculator Present Value and Future Value with Periodic Rates and Time

BA II Plus: TVM Calculator Number of Time Periods Calculations

BA II Plus TVM Calculator Present Value and Future Value of an Annuity

BA II Plus TVM Calculator Present Value and Future Value of a Single Payment

BA II Plus Calculator Basic Functions on a Texas Instruments BA II Plus

Excel: Data Validation

Excel: Conditional Formatting and Custom Colors

Excel: Charts Introduction

Excel: Cell References and Anchoring

Excel: VLOOKUP and Data Validation

Excel: IF Function with Text in the Formula for a Loan Amortization Schedule

Excel: Navigation, Shortcuts, and Editing Rows and Columns

Excel: Grouping Columns and Rows (Cells)

Excel: BLS Sort and Filter