In previous posts, I examined why corporate workers hesitate to call their help desks when stuck with a software quandary. I referred to the so-called stupidity factor, or fear of looking stupid, as one of the top reasons.
In an e-mail response, a reader pointed out an even greater obstacle, something he called the infuriation factor. [Read more...]
In a previous post (see Real-Life Help Desk Tales, Part 1), I touched upon why people don’t call the help desk when they need software assistance (fear of looking stupid, unpleasant past experience, assumed time investment). In this post, I will take a closer look at the stupidity factor. [Read more...]
Consider the following scenario: The entire staff of an elementary school was recently upgraded to Office 2007. When Teacher A began creating a new lesson in PowerPoint, which is something she does on a regular basis, she couldn’t figure out how to align her text.
After more than an hour of trial and error [Read more...]
The beauty of Excel is its simplicity: If you enter your data correctly, it works. However, it can be ugly, especially when it returns a mess of formula errors, which sometimes are as understandable as Sanskrit.
We have gathered some tips that will help you root out the potential problems in formulas. If you can identify the issue quickly, then we’ve done our job. As for helping you fix it, that’s for another post.
A circular reference sends Excel into an endless loop where it will never stop calculating the cell. Excel goes around and around, never stopping to give us a final number…
by David McQueary
If you’ve ever created a formula, you no doubt have come across a dreaded #N/A, #DIV/0 or other type of error. This can be frustrating, especially if the formula you entered is long and complex. Sometimes it is not easy to see what is causing the malfunction, and trying to read through the formula to spot the offender is not always a fruitful effort. Excel offers a Formula Evaluation tool, which assesses a formula step by step, showing each calculation and enabling you to view exactly where the error occurs. Here’s how:
Excel 2000, 2002, 2003:
1. Click Tools and move your mouse over Formula Auditing. [Read more...]
Get the latest updates right in your email inbox. Subscribe now.
This blog is written by PC Helps staff who report on, debate over and sometimes complain about the latest trends, research, technologies and standards in the IT service management industry. We aim to create a forum where IT leaders, techies and anyone else can share their opinions and ideas. What’s on your mind?
Improved features for managing email on the iPad.
Copyright © 2012 PC Helps Support, LLC
Recent Comments