Excel Stuff
| 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 |
*Until the server sets the MIME types for '07, they will download with a zip extension. To get around that, right click and choose Save target as... In the Save as dialog box, change the .zip extension to .xlsx and then save. Sorry for the inconvenience!