You are here: Home / Archives for Excel

Switching Gears: 6 Tips on Changing Views in Windows and Office

August 12, 2011 By

As the seasons change throughout the year, we must adapt to the frequent changes in temperature and weather conditions. This might mean turning off the heat and opening the windows on a warm day, only to have to close them again the following day. Or you may find yourself donning and removing your jacket several times throughout any given day. Maybe you even put away your snow shovel and woke up the next day in the midst of a snowfall.

With software, these types of changes also need to occur; not seasonally, but by task. We have gathered some tips to help you get your software application windows to behave the way you want so you can quickly switch gears.

Tips compiled by PC Helps staff.

What Is the Windows Key Used For?

Windows 2000, XP, Vista, 7

Have you ever wondered about that strange key between the Ctrl and Alt keys on the left side of your keyboard? It is commonly known as the Windows key, and can be used in conjunction with other keys to perform a variety of useful tasks.

First and foremost, it will open the Start menu; all you have to do is press it. Press it a second time to close the Start menu. Here are a few of its other uses: [Read more...]

Filed Under: How To Tagged With: , , ,

Productivity 201: Dealing with Damaged Files

March 24, 2011 By

They say March Madness is the great workplace productivity killer. There’s a worse one: corrupted files. Often, when our callers reach us, they are just about to begin the onerous task of recreating damaged files from scratch. To that we say: “Hold on a minute!”

Here are some of the methods our tech support folks recommend before you retype:

They say March Madness is the great workplace productivity killer. There’s a worse one: corrupted files.

Using Open and Repair in Excel (2002, 2003, 2007, 2010)

If you open a file and notice something is amiss, or you simply cannot open the file at all, there might be a problem with the structure of the file itself. This is known as “corruption.” It is a generic term used to describe files that are no longer working correctly. If you think your file is shot, give the Open and Repair utility a try. It might save you from having to recreate the entire file.

Starting the process is slightly different depending on your version of Excel. [Read more...]

Filed Under: How To Tagged With: , , , , , ,

From Here to Productivity: Hyperlinking How-To

February 25, 2011 By

Hyperlinks make the world go ’round. They get us where we’re going more quickly and they help us present information in less time. Here are a few linking tips from our tech support consultants. Enjoy!

4 top tips for adding hyperlinks.

Creating a Hyperlink to Another Presentation or Web Page (Microsoft PowerPoint 2003, 2007, 2010)

During a slide show, you may find you need to either launch another presentation or access a web page. Here’s how you do it:

PowerPoint 2003 and older:

  1. In your presentation, click an object or text that you want to use as the jumping off point or shortcut.
  2. Click on the Insert menu and choose Hyperlink, or press Ctrl+K.
  3. Enter the Web address or path and filename.
  4. Click OK. [Read more...]
Filed Under: How To, Time-Saving Tips Tagged With: , , ,

Avoiding Office 2010 Upgrade Pitfalls

January 21, 2011 By

In case you missed it, Forrester Research Group released a report in December warning of the pitfalls when upgrading to Microsoft Office 2010. And it’s what we here at PC Helps have been saying all along — as far back as Office 2007 upgrades.

We think the FAQ is a wonderful thing. But a FAQ cannot stand on its own.

As reported on recently by CIO.com’s Shane O’Neill, the Forrester report outlines four pitfalls to avoid during upgrades: underestimating compatibility issues, leaving workers to figure out the migration with no assistance, assuming workers will use the software’s new features, and neglecting to emphasize peer-to-peer learning.

Here’s what we’ve been saying: [Read more...]

Filed Under: Office 2010 Tagged With: , , , , , ,
« Older Posts
Newer Posts »