Excel Stuff
| Excel 2010 Quick Reference Guide |
| Excel 2007 Quick Reference Guide |
| Excel FAQ |
| New Stuff in Excel 2007 |
| 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 07 Functions |
| Examples and instruction for the following functions are in Excel workbooks: |
| SUBTOTAL (.xls) |
| SUMPRODUCT (.xls) |
| List of Excel functions available in 2007, with description and basic syntax. Available in two formats: |
| functions.xlsx* (2007) |
| functions.xls (2003) |
| 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 |
