Archive

Archive for the ‘Time-Saving Tips’ Category

Welcome to the 21st Century, Help Desk

February 2nd, 2012

The role of the help desk is shifting from fixing what’s broken to teaching users how to avoid problems in the first place.

In a feature in yesterday’s Computerworld (titled “The New Help Desk: Agile, Educational, Efficient”), writer John Brandon highlighted three IT departments and what they are doing to bring the help desk from where it’s stuck – the 1960s – to the present. One of the organizations featured, the University of Georgia, has put an emphasis on using calls to the help desk to educate users. We like that idea.

Creating charts in Excel

Click to see a video on creating charts in Excel.

The old way of working is myopic. If you keep fixing an issue that, with a little instruction, can be avoided, where is the long-term value? And, if you cannot – or do not — track where problem spots are, how can you plan for the future?

At PC Helps, we fix stuff too; we’re a help desk, after all. But we also teach customers how to resolve issues on their own, and how to avoid having them crop up again in the future.

In that spirit, today’s post offers tips for creating Excel charts, a topic we receive many calls about. Happy charting.

Creating Charts

By PC Helps Staff

Data (n.) – raw, unorganized facts.
Information (n.) – organized and processed data that can be useful in some way.

When working with a large amount of data, it often can become an overwhelming task to extract information from the data. Excel provides a great tool to facilitate converting data to visual information through the use of charts.

Follow these steps to create a chart: Read more…

Excel, Help Desk, How To, Time-Saving Tips , ,

Holiday How-To: Mail Merge

November 18th, 2011

The holidays are just about here. It’s the time of year when your productivity dips, your scale tips, and your to do list seems as if it will never be finished.

In the spirit of helping you get things done, we’re posting one of our favorite tips: How to create labels with mail merge. Whatever you use it for – holiday cards, end-of-year reports – it’s a time-saver and a headache-reducer. Plus, it’s the number one question our customers ask.

Mail merges make even the most nimble users shudder. That’s because they fail so often. 

Happy holidays.

Creating Labels with Mail Merge from a Data Source

Mail merges make even the most nimble users shudder. That’s because they fail so often. The most common type of merge involves taking data stored in Excel and bringing it into Word. 

If you are thinking of going beyond labels and writing full-on letters, this tip will still help you; the procedure for performing a mail merge to labels is similar to that of creating letters.

Word 2003:

  1. Click the Tools menu, move your mouse cursor over Letters and Mailings, and select Mail Merge. Read more…

How To, Time-Saving Tips , ,

Numbers Game: 4 Excel Tips that Promise Data-Crunching Greatness

July 22nd, 2011

Long before there were apps, there was Excel. It does almost everything, from calculating mortgage payments to finding out precisely how many days old your Great Aunt Mary is. Below are some of our top date calculation tips. Read more…

Excel, How To, Time-Saving Tips , ,

Holiday How-To: Tips for Mobile Working

July 1st, 2011

BlackBerrys, iPhones, iPads, Androids – they have altered the way we work. More than half of American workers do some work from home, and almost a quarter perform job-related tasks at home every day.

Are you the type who steps away from the grill for a sec to check your e-mail?

So why would work stop on a holiday like the Fourth of July? (It doesn’t.) If you are the type who steps away from the grill for a sec to check your e-mail, here are a few of our most popular tips that promise to make your holiday a little less work-infused:

iPhone

Easy punctuation

Inserting a period from the symbols box can become tedious. You want to send messages with proper punctuation, but deadlines get in the way. Here’s a quicker way: Double-tap the spacebar. Problem solved. Reputation saved. Read more…

Android, BlackBerry, How To, iPad, iPhone, Time-Saving Tips ,

iPad How-To: Email Edition

June 24th, 2011

One of the most used iPad features is email. What you may not know is that the app is customizable. Granted, not as much as Outlook or Entourage, but enough to make a difference. Below are a few tips for setting up iPad email the way you like it.

How to Mark an Email as Unread from Your iOS Device

Sometimes when you check your email on a mobile device, you might start reading a message and realize that it is better for you to deal with it later when you have more time. On a PC you can flag the message for follow-up in Outlook, but on a mobile device like an iPad, iPhone, or iPod Touch, that feature is not obvious. Here’s a way for you to flag a message for later.

3 tips for setting up iPad email the way you like it.

NOTE: Messages that are marked as unread are indicated by a blue dot to the left of the message preview in your message list.

How to Mark an Email as Unread

  1. Scroll to the top of your email message. If it is a long message, you can quickly do this by tapping on the time in the status bar at the top of your screen.
  2. If the only email header you see before the subject is From, tap on the word Details to the right of that line. This will reveal the To and CC fields (if completed). The word Details will also change to the word Hide. Read more…

How To, iPad, Time-Saving Tips , , ,

Office 2010: Tips, Tricks, and Pitfalls to Avoid

May 3rd, 2011

History has shown that a new software version usually takes a few years to catch on in business. Not so with Office 2010.

At PC Helps, we’ve helped dozens of companies upgrade from 2003 to 2010, and the call volume is steadily increasing.  Most calls are coming from customers whose IT departments skipped an Office 2007 migration and were holding out for 2010. As with 2003-to-2007 migrations, 2003-to-2010 promises a steep learning curve on the part of end users.

Here are a few sites we found with valuable tips and tricks for Office 2010:

Ultimate List of Office 2010 Tips & Tricks (Techie Buzz)

10 cool features to look forward to in Office 2010 (TechRepublic)

MS Office 2010: 10 Tips and Tricks (PC Mag)

And here are the top five challenges you can expect with an Office 2010 migration:

1. Adjusting to a materially different interface

The “ribbon” and other new aspects of the Office 2007 interface reflected major changes in the look and feel of the core Office applications. In Office 2010, these differences are carried forward and are combined with the incorporation of the ribbon into Outlook, impacting usability of this critical communications application.

User confusion and frustration is almost guaranteed when attempting to learn and work with the ribbon for the first time. Basic functions that were performed without effort in the past, such as opening and closing files, managing day-to-day calendar and meeting entries, and applying formats, require a relearning process with the new application versions. For some users, relearning these basic functions is fairly straightforward, and for others it takes a more effort and help. More complex tasks in PowerPoint, Excel, Word or Access often require a combination of training and support in the migration process.

2. Recreating and reformatting important documents

As with any new or changed software, incompatibility with prior versions may require users to manually rework documents. Compatibility of versions has been a focus for Microsoft over the years, and improves with every new release. But users don’t always follow the best practices when creating documents, and end up with versions which are not automatically converted with an upgrade.

Files received from outside the organization in older formats may not open properly and need some rework or, sometimes, may need to be resent. Files with links, Access databases (especially if they integrate with other systems or use extensive code), and custom animations in older PowerPoint versions may be corrupted or impacted by compatibility issues. In cases where users have documents they regularly use, often containing complex formulas or formatting, and which need to be updated to the new versions, there can be a significant amount of time spent on reformatting and recreating documents.

3. Dealing with deadlines and urgency

In reality, business cannot be put on hold while users adjust to a new software version. Critical deadlines loom, and day-to-day urgent matters still need to be handled. During a migration, end users may find themselves stymied by lack of familiarity with a new Office application just at a time when they are facing these deadlines.

Of particular note among these end users are administrative support staff, who are often managing calendars and communications for managers and executives. Downtime is not an option for them either. In these circumstances, self-help, training and tutorials often compound frustration.

4. Using Office across a range of mobile devices and computers

The proliferation of new and different mobile and computing devices is changing the corporate computing landscape. Employees now access standard Office applications across a range of devices and often from remote locations. Adapting to and syncing upgraded software and OS versions impacts end users in these mixed environments.

For example, to edit documents in the new Office 2007 file formats on a Windows Mobile device, an Office Mobile upgrade is required. Many users are not aware of this and don’t understand why they cannot successfully use the application. Another example, this one from the Apple side: The settings to sync an Entourage calendar to an iPad are not entirely obvious, and end users must also make sure they have the latest updates from Microsoft.

Many help desks have altered their policies to allow outside devices but are not able to offer support for these non-company issued devices. End users often search on their own for “how-to” support in online help communities and in-product menus. Even worse, they attempt workarounds that bypass updates and patches altogether, forgoing improved functionality or simply not making full use of the devices or applications.

5. Finding help when it’s needed

According to a Gartner report, one of the Windows 7/Office 2010 migration pitfalls to avoid is not seeking professional help early enough.

“Don’t underestimate the requirements for skills and services. It is often common to enlist an external service provider, especially for help with design and planning features,” writes Gartner researcher Michael Silver in Computerworld article about the report. “In addition to proper training for technical staff, make sure the service provider is contracted to transfer sufficient skills so staff can manage the new environment after the cutover.”

In addition to help with migration design and planning, help is needed on the end user side as well. As the migration process unfolds and users begin incorporating new or upgraded software into their everyday routines, it is essential that they quickly master tasks and processes relevant to their specific jobs in the new software environment. It is also important that they have access to additional help if they need it – which may be at points before, during or beyond the migration dates. Issues and causes users experience related to finding help include:

• Training was taken at the time of the upgrade, but a particular application or function has not been used since, and the user has forgotten how to use it. (Classic “use it or lose it” scenario.)

• Training and tutorials were planned by the user, but not completed due to limited time availability, and user now has an urgent need. Executives and higher level staff, or personnel who spend most of their time on the road, frequently experience this situation.

• General training and help tools may not be specific enough to the users’ particular needs.

• For a number of reasons, in-product help and search tools do not provide the help needed, or are considered inadequate by certain user groups.

• Some personnel may rely on an assistant for support, and with that person unavailable, may not know how to access certain critical documents or handle certain tasks.

When employees find themselves in these situations, they often need help right away. They can’t afford the downtime associated with submitting a help desk ticket or waiting for next-day follow up. If they can’t get the application expertise needed from the help desk, they will seek out help from their co-workers, struggle with generic help menus, look to hand off the work to a delegate if they have one, or just not complete the task.

Office 2010, Time-Saving Tips

Spring Cleaning Part 2: Six Tips for Tidying Up Your Computer

April 15th, 2011

If you are going to clean your home or apartment, you know what you need to accomplish: Clear the clutter, clean the bathrooms, dust the shelves, wash the windows, etc. A fresh, clean space is more conducive to happiness and productivity. (We don’t know that scientifically; just anecdotally. But go with us on this one.)

Last week we offered tips for keeping email inboxes tidy. This week, we look at ways to keep the operating system clean.

At work, keeping a tidy space is just as important, and keeping a clean computer is even more so. Here are some cleanup tips compiled by our techs that will no doubt improve your computer’s performance, and possibly even your own.

Clearing Temporary Internet Files

Internet Explorer 6, 7, 8

We often get calls from people who want to know how to get rid of temporary Internet files, Read more…

How To, Time-Saving Tips, Worker Productivity , , , , ,

Productivity 101: Setting Up Excel Default Formatting

March 18th, 2011

It may seem a trivial matter, but getting your Office 2007 and 2010 applications set up correctly before you start working is a smart move. Think about all the times you have had to change formatting options on existing workbooks and tally up that time — it adds up.

Tech tips: 3 ways to make life easier in Excel.

Here are three tips that will enable you to reset Excel 2010’s default formatting. Set them once, and never again.

1. Setting Formatting Options for Workbooks, Part 1

Excel does not offer many options that allow you to set formatting defaults for your workbooks. However, you can work around this by modifying the formatting in a blank workbook, then saving it as the default template.

Excel 2007:

  1. Open Excel to a blank workbook. Read more…

Excel, Office 2007, Office 2010, Time-Saving Tips , , ,

From Here to Productivity: Hyperlinking How-To

February 25th, 2011

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…

How To, Time-Saving Tips , , ,

All About the iPad: Tips & Tricks

February 4th, 2011

Although I truly cherish the Martha Stewart Makes Cookies app for iPad, it’s not quite up there on the list of top apps for business productivity. If you are using your iPad for work, you are more likely to need software like Keynote and Pages. The Tips and trickskey to using these apps is knowing how to get your documents from Point A to Point B; that is, from iPad to main computer or vice versa.

Here are some tips:

Export Keynote for iPad presentations to your Mac or PC

  1. Connect your iPad to your PC or Mac. In iTunes, select your iPad from the Devices list.
  2. Select the Apps tab from your iPad Settings window.
  3. Scroll down to the File Sharing section. Select Keynote from the apps list. You will now see a list of all the Keynote presentations on your iPad. Select the one you want to transfer to your computer, and click the Save To button.
  4. Browse to the folder on your hard drive where you want to save the presentation. Select it and then click the Choose button.
  5. Your file will be copied.

Import presentations to Keynote on iPad

  1. Connect your iPad to your PC or Mac. In iTunes, select your iPad from the Devices list.
  2. Select the Apps tab from your iPad Settings window.
  3. Scroll down to the File Sharing section, and select Keynote from apps list. In the Keynote Documents section you’ll see a list of presentations available in Keynote on the iPad.
  4. Select the Add button.
  5. Navigate to the presentation you want to copy to your iPad to edit or view in Keynote for the iPad. Keep in mind that with Keynote for iPad, you can edit only Keynote 2009 or PowerPoint presentations.
  6. Select your file and click Choose.
  7. Your presentation will now appear in the Keynote Documents section.
  8. Launch Keynote on your iPad and tap the icon that looks like a down-pointing arrow and a square bracket (it should be at the bottom of the screen in the center). Choose “Copy from iTunes.”
  9. Select the PowerPoint presentation you just uploaded to your iPad.
  10. Keynote will now import your uploaded presentation.
  11. Depending on the presentation, you may get a warning about incompatible fonts or other features that will slightly change the look of the presentation. Click “Done” to get past the screen, and check your presentation to be sure.

Import documents to Pages on iPad Read more…

How To, iPad, Time-Saving Tips , , , , ,

football streaming live streaming live football football tv live football streaming free football streaming live football stream free football stream watch football online football