Excel math/finance functions for decision makers

This is the agenda for Table of Contents
Table of Contents
 
Introduction

Welcome

 
Basic math and formulas

• What We Will Cover
• Basic Math & Formula Evaluation - Part 1
• Basic Math & Formula Evaluation - Part 2
• What Have We Done

 
Statistics and aggregation formulas

• Aggregating Numbers
• Basic Statistics
• Using Math Functions
• Aggregation with SUBTOTAL()
• Calculating Basic Statistics - Part 1
• Calculating Basic Statistics - Part 2
• Calculating Most Recent Quarterly Averages
• What Have We Done

 
Rounding numbers

• Basic Rounding Functions
• Rounding to Significance - Part 1
• Rounding to Significance - Part 2
• Rounding to Even, Odd and Integer Numbers
• What Have We Done

 
Other interesting functions

• PI(), ABS(), and MOD() Functions
• RAND() and RANDBETWEEN() Functions
• What Have We Done

 
Forecasting in Excel

• Forecasting Water Consumption
• Using the FORECAST() Function
• Using Statistics to Evaluate Forecasting Options
• What Have We Done

 
Finance formulas

• Capital Budgeting in Excel
• Building a Net Present Value Table
• Using the PV() and NPV() Formulas - Part 1
• Using the PV() and NPV() Formulas - Part 2
• What Have We Done

 
Evaluating a capital purchase

• Calculating Cash Flows
• Adding Context and Scenario Planning
• What Have We Done

 
Conclusion

In Review

Conclusion

Final Quiz

Highlights

Update your knowledge and strengthen your network at this must-attend conference covering the most important issues and trends affecting audit committee members.

It’s probable that someone you know is deep in debt. If you are observant, you might see one of these seven signs.