Tracing Excel formula errors is tedious, if not guided by the built-in formula auditing tools. The formula bar itself is a good starting place to debug formula errors but when the formula gets longer and more complicated, a visual guide to trace the dependents is a great help.

You can use the Trace Precedents button on the Formula Auditing toolbar to trace all the generations of cells that contribute to the formula in the selected cell (something like tracing all the ancestors in your family tree). Many times, finding the original source of the formula leads you right to the source of all the error values in your spreadsheet.

To activate the tool, click Formulas on the ribbon and then Trace Precedents under the Formula Auditing panel:

In the Fibonacci sequence below, you would see the blue arrows showing the precedents of the result of the formula:

Another example is shown below where the B1 cell is a result of summing A1 and A2:

Now to see the dependents of a value, click a cell that you want to audit then click the Trace Dependents value. If the cell is used by other cells in formula, the arrows will point the to cells that depend on the cell.

To clear the arrows, click the Remove Arrows button and you should see the arrows disappear.

Use the Formula Auditing tools to trace dependents and precedents of your Excel formulas. They are very handy when the cell formulas get very complicated. As of Office 2007, the arrows don’t get automatically refreshed when you change the formula (they get cleared out) so you will need to click the trace buttons again to generate the arrows.

Posted By George October 2, 2009 0 comments

Supernatural Brasil XP Theme

Posted By George 1 comments

I make it a practice to purposely seek out refurbished tech items because I save a ton of money doing so, and the majority of the time the whatever-it-is I buy works just as well as a new item.

There are some people who believe refurbished and used mean the same thing. This is incorrect; there are several differences.

Difference 1: Warranty

All refurbished items come with a warranty. Some used items come with one but most don’t.

Difference 2: Physical condition

Refurbished items are supposed to look exactly like a new item and do most of the time. This usually involves the replacement of things, such as the chassis, faceplates, buttons/knobs, and so on. A used item has had nothing changed on it. It is the same as when it was new, worn and all.

Difference 3: Vendor

It is rare that an OEM will sell anything used. The closest match to this is "off-lease," meaning a corporate customer leased a ton of the whatever-it-is from the OEM, sent them back when the lease expired and then the OEM resells the items. But even this is a rare instance these days because if the items are too old (and therefore cannot be supported directly,) the OEM won’t bother reselling them and instead find other means of liquidating that inventory.

Third-party vendors will sell used items, do so routinely and at times label these items as refurbished when in fact they’re not.

The general rule of thumb is that if you purchase a refurb item direct from an OEM or a large third-party vendor (like NewEgg or TigerDirect,) it is truly refurbished. With smaller vendors you get used. This is especially true if a vendor is selling something labeled as refurbished but there is no warranty and/or is stated to be sold as-is.

Difference 4: Age of item

As noted in #3 above, if there is something in the inventory that is simply too old for an OEM to support, they will find a way to liquidate the inventory otherwise.

If a particular item is still available from the OEM as new, you will find legitimate refurbished versions of it, warranty and all.

If on the other hand the item is discontinued and isn’t available as new any longer, what you will usually find are used versions of that item with no warranty.

The easiest way to check if something is discontinued or not is to go to the OEM’s web site. If you see the item still sold as new, it’s obviously not discontinued. But if it’s not there, it is. Some OEMs are nice enough to tell you this information up front and give you a complete list of what’s discontinued (like Garmin for example.) Others however don’t do this, so you’ll have to go look item-by-item and see for yourself.

Special note on this: There is a period of time right after an item is discontinued where it "rides the fence" for a few months and can still be supported by the OEM, but after that it goes into used-only territory. This all depends on how the OEM handles discontinued product support for newly discontinued items.

Difference 5: Support

This directly relates to #3 and #4 above. Current-model items from the OEM are supported and therefore are available as refurbs. These refurb items have support, so if there’s any issue with it you can call the OEM for help.

Used items have third-party-only support or no support at all. Once you buy it, you’re on your own.

Are refurb items better now compared to before?

Yes. When refurbished items first appeared years ago they were admittedly pretty crappy. This soured a lot of people on the idea of buying anything other than new.

Today the OEMs understand that there is legitimate profit to be made by selling refurbished items. As such, refurb now is a whole lot better compared to yesteryear. These items are good enough to where you get the exact same warranty as you would new. This shows confidence in the refurbished product by the OEM and proves that yes, it will work.

I do recommend people to go refurb instead of new. If the refurbished item has all the features you want, comes with everything the same new product would and is supported by the OEM (which it is,) you can buy with confidence.

Obviously you should exercise common sense when shopping refurbished, because some items are still better new than refurb or "recertified" (I wouldn’t buy a recertified hard drive,) but most of the time the refurb items you buy will serve you just as well as new would.

Posted By George 1 comments

We have shown you a couple of cool free photo editing tools like Irfanview and Google Picasa. Let me show you another freeware that could become part of your essential photo editing toolbox. The freeware is called PhotoScape from www.photoscape.org.

Like Irfanview and Picasa, this software packs a lot of functionality: picture viewer, editor, animated gif creator, color picker, raw format converter, picture frame maker and others. The first thing a user will see on the GUI is an arranged shortcut to these functions.

The tool covers the basics of a photo editing app like the capability to zoom in/out, rotate, crop, level, contrast, midtone adjustments and others. It has auto level and auto contrast capabilities – something similar to Microsoft Office’s auto-enhance image feature.

You can also add decorative frames built-in from the tool:

The tool also makes collage frames easy to create. You can choose from a lot of frame designs and then just drag and drop pictures to each section of the frame.

Arranging pictures for printing to a single photo paper is also easy.

This tool offers a lot of goodies. For users who want to combine pictures into frames – this might be the best freeware for them.

Posted By George October 1, 2009 3 comments

Another set contains some Flowers doodle brushes for Photoshop.

Download

Posted By George 0 comments

This set contains some Flowers doodle brushes for Photoshop.

Download

Posted By George 0 comments

This set contains Fashion Girls Silhouettes brushes for Photoshop with high-resolution. There are a total of 15 brushes, made in Photoshop CS3.

Download

Posted By George 0 comments

Luna ported to Windows 7 Aero and Basic.

The original Luna is © Microsoft.
I claim no ownership over the original theme and I am not affiliated with Microsoft.
Also, it would be kind of nice for Win7 to have it’s own category.

*note* satukoro is branded into the preview for watermark purposes, it’s not in the actual image. Also, the startbutton will come soon if I can get it to look right.

Download

Posted By George 1 comments

Many unfortunately remember the infamous "Vista Capable" logo disaster. A whole bunch of new computers at the time Windows Vista was launched had a little logo that was supposed to indicate yes, they were capable of running Vista. But as we all found out, many of those new computers were barely "capable." Instead computer owners were treated to a less-than-pleasant computing experience – putting it very nicely.

One of the best things Microsoft ever did was release Windows 7 RC to the general public for testing. A ton of people, including myself, use this OS. I use it as my primary right now. This allowed everybody on both sides (corporate and consumer) to do the best live field testing of Windows since the product came into existence; this has served everybody very well.

Microsoft will be using a logo program again for Windows 7, so you will see those little stickers on new computers if you haven’t already. This time around the requirements to get the sticker are far more stringent compared to the Vista logo debacle.

The logo means the product must work with both 32 and 64-bit editions. This is particularly important for peripheral devices, because it means the driver disc included will have 32 and 64-bit versions included. It also means more rigorous testing has been performed to ensure that yes, it will work.

Part of this program includes "Ready. Set. 7." You can check out right now what developers are building 7-compatible items at www.readyset7.com. The list is extensive, and that’s great because it means that many of the products on store shelves will be compatible right out of the box.

In the end however, what has mattered most concerning 7’s readiness has been end-user testing from Win 7 RC use. I use 7 RC, and this OS proved its worth beyond any doubt by running nearly flawlessly on my Dell Inspiron Mini 10v netbook, which houses only a single core 1.6GHz Intel Atom CPU, 1GB of RAM, shared video memory and a 160GB 5400rpm HDD.

As far as I’m concerned, if Win 7 can run on this smoothly (which it does,) it can run on just about any computer made in the last 5 years without the need to upgrade.

The logo program is good and is being far better managed, granted, but it’s been the users of this OS that have had the most influence on people. If I thought Win 7 sucked, I would say so without hesitation. If other people thought it sucked, they would say so as well. We’ve all been nothing but honest in our reviews of this OS. And it’s the general consensus that Win 7 doesn’t suck. Not in the slightest. In fact, we all really like it. That’s why we dare to run an RC as our primary operating system. Ordinarily that’s considered computer suicide, but the blunt honest truth is that 7 really is that good.

Posted By George 0 comments

You may have seen in tech news articles in the past that Microsoft was working on it’s own release of an anti-virus product to compliment Windows Defender. A couple of days ago their solution, Security Essentials, was released (from beta).

Microsoft Security Essentials provides real-time protection for your home PC that guards against viruses, spyware, and other malicious software.

Microsoft Security Essentials is a free* download from Microsoft that is simple to install, easy to use, and always kept up to date so you can be assured your PC is protected by the latest technology. It’s easy to tell if your PC is secure — when you’re green, you’re good. It’s that simple.

Microsoft Security Essentials runs quietly and efficiently in the background so that you are free to use your Windows-based PC the way you want—without interruptions or long computer wait times.

If you google Security Essentials, you will see it gets a mixed bag of reviews. Although the sites I tend to frequent have given it more positive evalutations.

Posted By George 0 comments

Get updates via email