headermask image

Business Tools Blog

Author Archives: Sandi Mays

PowerPoint tries to open linked files when printing

A big thanks to Jason Tibbs for finding the answer to this question!
I was going crazy when trying to print a PowerPoint that had links to external files.  When I opened the file, I clicked Cancel when the MicroSoft PowerPoint Security Notice asked if I wanted to update links.
Then, after clicking print, I would have […]

Why are Euros showing up in Excel 2010?

Amit is trying to figure out a fix …
Apparently it is a Microsoft glitch, after you put a pivot table into a file Microsoft will then default to Euros.  Microsoft needs to develop an update for us download!  In the meantime, hopefully Amit can help!
Update - Amit found this fix:
To fix the Euro problem in Excel 2010 […]

I don’t want to view pictures in Picasa!

Question: I installed Picasa and now every picture or fax that I open, opens in Picasa.  How do I change my settings so that Picasa is not the default picture viewer?
In Picasa go to Tools  > Configure Photo Viewer and ‘check’ the button at the bottom that says “Don’t Use Photo Viewer”. Then press OK.

Add manual data labels in PowerPoint graphs/charts

automate adding manual labels to PowerPoint graphs/charts

Help, my spreadsheets are showing Euros instead of dollars

Why would excel default to Euros when you are sitting in Colorado, USA?
The setting for Microsoft Office default currency, dates, times, currency values, and numbers is controlled by in the Regional and Language Options section of your Control Panel.
To open the Regional and Language Options tool:
Click Start, and then click Control Panel.
Click Date, Time, Language, […]

Excel: Insert decimal places into a number string

Is there a way in Microsoft Excel to insert a decimal place 5 places from the right side (i.e. the last 5 digits are decimals and everything left of that is a whole number) of a series of numbers with different lengths? I need to figure out how to insert the decimal so I can sum the totals for a check figure.

New Pivot Table Slicer Function in Excel 2010

In Excel 2010, Microsoft added a friendly visual interface for pivot tables

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

Top 5 Corporate Gifts

“What should we give to say thanks to our loyal customers and employees?

Tickets - Who doesn’t appreciate taking a little time for themselves or time with friends?  consider giving tickets to a local event, the theater, zoo,  or if you live in Colorado, consider ski lift tickets.
A luxurious pen - We use pen’s all the time […]