September 2, 2010 – 12:44 am
How to Convert Numbers to Currency Text for Mail Merge
August 19, 2010 – 2:09 pm
Calculate the number of Years, Months, Days between two dates
Microsoft Excel - Round numbers in the same cell without a formula
Micorsoft Excel has a neat feature called Precision As Displayed. Using this function automatically rounds all of the numbers in the spreadsheet to equal the number displayed. You can round without using the “=Round(number,round to number of digits)” formula.
For example, the number in cell C1 […]
Thanks to Rachelle for helping me figure this one out. In Excel 2007, pivot tables have a lot of new options, but some of the old functions seem to be missing.
For example, In the below table … I wanted to change the format so that the MRR and Term Values are stacked in the Pivot […]
How to use an inexact search in Excel, PowerPoint or Word
How to add an email to your safe recipients list in Outlook
Change Zeros to Dashes in Excel 2007
Unhide multiple Microsoft Excel worksheets with a simple macro
April 28, 2010 – 12:34 am
Highlight all of the Formulas in an Excel Spreadsheet
Add a stock market ticker to your PowerPoint slides