headermask image

Business Tools Blog

category archive listing Category Archives: Microsoft

Convert Numbers to Currency for MS Word Mail Merge

How to Convert Numbers to Currency Text for Mail Merge

Calculate the number of Years, Months, Days between two dates

Calculate the number of Years, Months, Days between two dates

Microsoft Excel - How to round numbers in the same cell without a formula

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 […]

Pivot Tables in 2007 - How to Stack Values vs. Displaying Side by Side

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 […]

Inexact searches in Excel, Word or PowerPoint

How to use an inexact search in Excel, PowerPoint or Word

How to add an email to your safe recipients list in Outlook

How to add an email to your safe recipients list in Outlook

Change Zeros to Dashes in Excel 2007

Change Zeros to Dashes in Excel 2007

Unhide All Hidden Sheets in Excel with one Mouse Click

Unhide multiple Microsoft Excel worksheets with a simple macro

Highlight all of the Formulas in an Excel Spreadsheet

Highlight all of the Formulas in an Excel Spreadsheet

Stock Market Ticker Effect for PowerPoint

Add a stock market ticker to your PowerPoint slides