the MOST

McCombs Office Solutions and Tips

Entries from October 2009

The Mail Merge

November 25th, 2008 · Filed under: Office 2007 · Word

Posted by Jeff Hauger

It’s that time of year again. The Holidays are here and we are all going to be sending out cards and emails. At McCombs we’ll be sending all kinds of things during this last month of the semester. Many of us will be doing some Mail Merging and some of us for the first time [...]

[Read more →]

Tags:

Key Tips and Keyboard Shortcuts in Office 2007

November 21st, 2008 · Filed under: General · Keyboard Shortcuts · Office 2007

Posted by Holly Green

This post is for all of you out there who love keyboard shortcuts.  This is also for anyone who thinks they might love keyboard shortcuts, if only they knew some.  Also for laptop users who hate the track pad and little button in the middle of the keyboard (I particularly dislike the button).  For those [...]

[Read more →]

Tags:

Zeros values and Blank Spaces ( Part 2 )

November 11th, 2008 · Filed under: Excel

Posted by Jeff Hauger

Another no value cell issue came up last week. This time about how to reference a blank cell when making a formula. This is done by using open and close quotes with nothing between them. No space, no 0, no nothing. It is just “”. 
Example: You have values assigned to groups one, two, and three, [...]

[Read more →]

Tags:

Zero Values and Blank Spaces

November 5th, 2008 · Filed under: Excel

Posted by Jeff Hauger

Recently, I helped a staff member figure out how to deal with a spreadsheet full of zeros in Excel.
If you have a bunch of zero values on a work sheet and don’t want endless “0”s appearing all over your spread sheets and reports you can go into the Excel Options on the Office Button and [...]

[Read more →]

Tags: