the MOST

McCombs Office Solutions and Tips

Entries from October 2009

Use the Camera Tool in Excel

September 30th, 2009 · Filed under: Excel

Posted by Holly Green

When I’m working in Excel, I find that I sometimes want to view information from one worksheet while I’m working on another.  Jeff wrote a very useful post about viewing two Excel spreadsheets at once, but this limits how much you can see of each, and may not be ideal.  The other day I learned about [...]

[Read more →]

Tags:

Photoshop effects using PowerPoint

September 22nd, 2009 · Filed under: PowerPoint

Posted by Jeff Hauger

Don’t have Photoshop on your computer? Try using PowerPoint!

This is a great e-learning video tutorial made by David Anderson about giving your photos a Polaroid picture effect using the photo and shape editing features available in PowerPoint 2007. It demonstrates some quick picture editing tricks as well as a useful shape free transform feature.
Enjoy!

[Read more →]

Tags: ·

Select Cells and Navigate in Excel Using Keyboard Shortcuts

September 15th, 2009 · Filed under: Excel · Keyboard Shortcuts · Office 2007

Posted by Holly Green

In Excel 2003 and earlier versions, when I tried to select a large block of data using my mouse, I would often overshoot, and accidentally select more rows than I meant to.  Then I would go back, and select too few.  I often had the same problem scrolling within a spreadsheet.  I would go too fast, [...]

[Read more →]

Tags:

Print Area and Print Selected Cells in Excel

September 10th, 2009 · Filed under: Excel · Office 2007

Posted by Holly Green

More than once I’ve talked to people who clicked the Print Preview button before printing an Excel worksheet that should fit on one or two pages, only to discover that 100+ pages were slated to print, and all but the first few were going to be blank.
In my experience, this usually happens because you have [...]

[Read more →]

Tags:

Get Started in Office 2007

September 2nd, 2009 · Filed under: Excel · Office 2007 · PowerPoint · Word

Posted by Holly Green

If you’ve ever looked at Office 2007, then you know that things have changed significantly.  Most people I talk to are frustrated when they first switch to Office 2007, because they don’t know where to find the tools they used in earlier versions of Office.  Microsoft has put together videos, demos, and interactive guides to help [...]

[Read more →]

Tags: