Introduction to Spreadsheet- Functions of Spreadsheet- Spreadsheet Uses and Limitations- Entering Formulas into Excel- Control-Flow Statements-Charts in Excel- Dash Board- Sensitivity Analysis- Creating Tornado Diagrams- Pivot Tables and Charts- Modeling with IFPS and VBA- Matrix Operations - Regression Analysis- Macros - Recording and Editing- Lookup and Reference Functions- DCF-NPV and IRR Functions- Data Tables- Database Manipulation- Workbook Sharing & Merging- Customizing Toolbars And Menus- User-Defined Functions- Matrix Operations In Excel- Auditing Tools