Excel Stuff
| Excel 2013 Quick Reference Guide |
| Excel 2010 Quick Reference Guide |
| Excel 2007 Quick Reference Guide |
| Excel FAQ |
| Function Stuff: |
| Function Basics |
| Insert Function Dialog Box |
| Using AutoSum |
| IF Function |
| PMT Function |
| Date Functions |
| DATEDIF Function |
| Lookup Functions |
| Round Functions |
| Time Functions |
| Text Functions |
| Statistical Functions |
| Other Functions |
| New in 2007 Functions |
| New in 2013 Functions |
| New in 2016 Functions |
| Examples and instruction for the following functions are in Excel workbooks: |
| SUBTOTAL (.xls) |
| SUMPRODUCT (.xls) |
| List of Excel functions with descriptions. |
| Functions available in Excel 2013 |
| Functions available in Excel 2007 |
| Workbooks containing function samples: |
| functionsamples07.xls (contains formatting and functions that will not display if opened in previous versions) |
| functionsamples.xls (2003) |
| (AutoSum, Round, DATEDIF, SUBTOTAL and SUMPRODUCT are separate files.) |
| Other Workbooks and Templates: |
| Loan Analysis Worksheet Template |
| Computing Easter Workbook |
