 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
Leo Laporte, Bill Jelen, and Kate Abraham on the set of The Lab on TechTV Canada. The tip in this show is from Special Edition Using Excel 2007.
There are 351 functions in Excel. Sure, everyone uses SUM or AVERAGE, but here are some unusual ones:
use CONVERT to convert from one unit of measurement to another.
Check out Excel help for the complete list of abbreviations, but here are several examples:
Use ROMAN to obscure bad financial news!
Figure out number of work days elapsedUse NetWorkdays to calculate the number of work days between two dates. This function can even factor in the company holidays (see G2:G10).
When does probationary employment end?Similar to NETWORKDAYS, the WORKDAYS function will find a date in the future.
Calculate a car payment with ExcelUse the PMT function:
While writing Special Edition Using Excel 2007, there were two obscure functions that didn't seem to have a use.
FactDouble turned out to be good for Texas Hold-em Probabilities:
You can find a complete list of functions and their uses in Special Edition Using Excel 2007.
To watch the segment:(segments are available 3-5 business days after the show airs)
This tip was originally published on June 18, 2007 and aired on TechTV in Canada and Australia on June 18, 2007. The permanent URL for this page is http://www.mrexcel.com/tip146.shtml. If you are looking for show notes from another episode, visit my complete list of TechTV appearances. Check out the home page for The Lab with Leo.
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.