Showing posts with label Software. Show all posts
Showing posts with label Software. Show all posts

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

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

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

Is your download speed as fast as it should be? If you recall the days of the “speed demon” 56k dial-up modem, waiting on something as simple as a small digital picture file seemed to take eons. This is when you would get up from your computer and wander off to perform various other tasks to pass the time.

Now that more people have higher speed connections (Cable, DSL, Fiber), as of late, one would imagine that downloading a trial copy of Halo would be fast and steady. Well, not always. Instead of the person carefully watching their connectivity status while running their download, it is the group distributing the software, that is monitoring their bandwidth use.

Consider the possibility that greater bandwidth for the end user can mean greater amounts of requests for a target website. The chances that your download can be slowed down, or broken, increase. With larger websites, like Download.com, they take step to build infrastructure around maintaining the bandwidth necessary to support many thousands of active connections. However, for less frequented, or newer download or file sharing sites, the same environment may not be available.

To help you get the most out of your down stream speed on your Internet connection, tools like Download Accelerator Plus (found here) are available to boost your file grabbing speed and download connection quality. Download Accelerator Plus (also known as DAP) does more than simply make downloading files faster though. It also allows you to effectively pause a download and restart one, should a link set become broken.

Historically, this tool was an add-on for Internet Explorer, and now it has evolved into a suite of products. Included in Download Accelerator Plus is an FTP connection tool, a download dashboard, and a web browser. A simple tabbed interface allows the user to bounce between the three views.

The main draw behind this tool is the multiple download threads it utilizes when downloading a file. It does not simply get the download information from one site, and begin transferring the file. Download Accelerator Plus looks at other websites for the same file, and pulls from the as well. When you use DAP to get a file, it will display a multi-colored progress bar, showing several file connections.

When looking at Download tab, you can view the controls to Pause and Resume your downloads. You may select one or several streams for the purposes of stopping and starting the file transfers, or you may do all of them at once. One could see the practicality in this, because you could pause downloads that are taking longer then others, allowing DAP to focus on finishing certain transfers first.

When you pause an active download, a small icon pops up next to the selected transfer. This icon appears in the Status column and viewable while you are in the Download tab. The paused status remains until Resume is clicked.

For the purposes of downloading a file from a website, most people will navigate to the website, and locate the file on the site itself. This is tried and true method for finding file you wish to get at. That and the Google search engine covers most bases. However, if someone sends you a HTTP address link in an email, for instance, you can copy and paste the whole address into Download Accelerator Plus. All you have to do is click on the green Add icon in the Download tab, and a text box will appear for you to enter the website address of the download.

Please keep in mind that the version of Download Accelerator Plus reviewed here was the Free Version. There is a paid version of this software, and depending on what you click on within DAP, it will remind you frequently of this fact. The premium version does offer some nice privacy tools to help clean up Internet tracks with respect to downloaded files.

Is Download Accelerator Plus right for you? That is a determination that you will have to make for yourself. If you have a 265k DSL type connection, adding a tool like DAP will boost your file download time; whereas if you have a fiber connection of 20mb and upwards, DAP may not have the impact you want. Even if the speed is unattractive, the ability to effectively manage file downloads is reason enough to get this tool.

Posted By George September 30, 2009 0 comments

If you fear your closets, you are not alone. Many closets contain everything from shoes, clothing, sports equipment, and hangers, to jackets, forgotten winter jackets, and more hangers. The long and short of it is, behind that door lies a potential tidal wave of things that you may have no clue as to what they are.

While a little unnerving to think about, the same can be true of your hard drive. Over a period of years, you hard drive has had files added to it, some files removed, and other files tucked away, which you may not realize are still on your computer. These file are not malicious, or anything of that nature. They are just quietly, and unnecessarily, consuming hard drive space. And just like your closets, need cleaning every so often.

Of course, you are not going to fling open your closet door, and dash in, garbage bags akimbo, and get rid of most of the items. You just need to sort out what to keep and what to get rid of. In regards to your computer’s hard drive, it is in your best interest to know what you are getting rid of before you execute the plan.

In order to examine the file structure of your hard drive, a tool such as Space Sniffer is needed. Space Sniffer (found here) scans your hard drive, and sorts the results for you to review. Now, bear in mind that the results are not in the format you may expect. Space Sniffer does not bring up a Windows Explorer type window, as some other applications do. This program shows its scan results in a block type schematic on the screen.

This first screen may not look like much, but it illustrates the top level of the diagram, the C: drive. At the C: drive level, you will see blocks of what is directly underneath the C: root directory. This would include items like Windows, Program Files, Documents and Settings, and the page file.

Should you be one that desires more detail in what they are looking at, this is easily accomplished. There are two blue boxes towards the top of the Space Sniffer program. The icon on the left reduces the amount of detail on screen, where the right icon increases the level of detail.

Granted, the icon that increases detail will only go down so many levels, before you are expected to click open the container. At some point, there would just not be enough of your screen’s real estate to properly display everything.

This is a view a few folders down. This is a section of what is under the My Documents folder. You can navigate within Space Sniffer in similar fashion to Windows Explorer. Instead of jumping through folders though, the main interface stays in place, while you dig further into a particular set of files or folders.

If you want to, you can click on the green star shaped icon in the icon bar within Space Sniffer. Doing so will show the free space available on your hard drive, in Space Sniffer. Free space is represented, color wise, by green.

Though it would seem that a simple program like this does not have the need for extra options, there are some available to you. Clicking on Edit, on the menu bar, then Configure, opens up an options window. Here you may alter the geometric and coloring effects of Space Sniffer. You can also modify the initial detail level, if the first set of results was visually too much for your tastes.

Space Sniffer may not be the only program you use for file management on your computer, but it is one that is worth looking at. It is very light on system resources and does not have to recalculate something every time you go one level deeper into your file structure.

Additionally, it is not installed on your hard drive, and can be used with a portable utility set (like programs on a USB thumb drive). If nothing else, it is fun to play around with and serve as a visual interpretation of how many files you have crammed into your My Pictures of My Documents folder.

Thanks and good luck!

Posted By George September 29, 2009 0 comments

If you have a damaged CD or DVD which you need to recover data on and trying to copy data from Windows Explorer is not yielding successful results, a tool you might want to try is IsoPuzzle.

Short Description:
The goal of this program is to recover as much as possible data of damaged, bad burned or scratched CDs or DVDs.
This version supports only data CDs and DVDs with sectorsize of 2048 byte – Audio CD, VCD and SVCD are not supported.

IsoPuzzle reads the disc in the drive and creates an ISO file with any data it can recover. This resulting ISO file can either be loaded into a virtual drive or burned to a disc to copy any recovered data.

The product’s website does look dated to say the least, but the tool may be worth a try in a disaster recovery situation. Do take note of the author’s disclaimer that this program makes no guarantee that it can recover any data from a damaged disk.

Posted By George 0 comments

Have you ever changed the priority of a process in the Task Manager?
Do you have to do it often?
Do you want your database server or media player to know the priority it should work with?

If so, you have two choices: do it manually every time or automate/manage the process. If you prefer the latter then a tool you should check out is Prio Process Priority Saver.

Once installed, you just set the priority preferences of the processes you want to modify and then make sure the option to save is checked. Then the next time the program starts your saved settings will be applied automatically. This utility is ideal for power users or system admins who are looking to get more control over their server processes.

Posted By George September 28, 2009 0 comments

I often go to torrent search engines like mininova.org or isohunt.com to look for torrent files that I want to download. Sometimes the torrent files on one site are not available, but are on another site and I’ve found it necessary to visit multiple torrent sites – Google and Bing are just not that good when it comes to indexing torrents.

Lately, I discovered a great site that searches multiple torrent search engines so users can search on only one page. Before going further, also read my previous posts on how to make your own torrent and how to use uTorrent, my favorite torrent downloader.

The Scrapetorrent.com engine searches popular torrent trackers when you query a keyword. Users can also suggest trackers that they want to be added on the engine. As of this writing, there are about 280 torrent trackers added on the list and about 200 of them are active – some are probably shut down by the enemies of P2P sharing like RIA.

The site offers two types of search; the basic and TV mode. With basic mode you can search for music, software, video, and other types. You can also filter out torrents with no more seeds and duplicates:

The search results are presented with necessary torrent statistics like file size, seed and downloader counts.

The bottom of the page contains how many torrents are found on each portal:

The other mode, searching by TV episodes lets you enter a title of the show and choose a specific season and episode to search. There is also a link for the recent episode of the show.

If you love downloading content from torrents, Scrapetorrent.com is a good first place to search. Since it can search multiple torrent sites at once, you can optimize your search time and get the best torrent file with the most number of seeds.

Posted By George September 27, 2009 0 comments

Here is an interesting and clever use of Twitter: remotely controlling your computer. In a couple of articles recently posted on Lifehacker, you can use TweetMyPC and TweetMyMac (respectively) to send commands to your computer from anywhere you have Internet access.

The commands are limited (obviously) but you are able to do useful things like send a shutdown command or create your own custom commands which can do anything you like such as launch automated tasks. Of course there are dangers with using something like this as you will want to protect your account so not just anyone can send your computer commands.

Personally, I do not use Twitter so I am curious if any of our readers out there would try something like this.

Posted By George September 26, 2009 0 comments

Whenever you have a large number of folders, inevitably some will be more important than others such that you want them to stand out in the list. Typically, you accomplish this by using special characters, caps or punctuation in the folder name. An alternate way to do this would be to change the color and/or icon of the folder. A free tool to make this process simple is Folder Marker.

Folder icons can be customized using the standard Windows method, but with Folder Marker Free you can do this on the fly from the right-click menu of a folder. So there is no need to go through additional dialogs or run Folder Marker Free itself! Simply select the folder you want to mark, right-click on its icon and select a color-coded icon from the drop-down menu. The icon will be assigned to the folder at once.

This tool makes the required folder changes a simple one or two click process. A tool like this is a quick way to organize all your folders.

Posted By George 0 comments

Windows Explorer does just about anything you would need it to with respect to file management, however one complaint you may see people have is that it lacks speed when doing file copies. If this is something you have noticed, a utility you should try is TeraCopy. TeraCopy is a program optimized for doing one thing- copying files fast.

Personally, I do a lot of work with virtual machines (copying, moving, etc.) which have a file size of at least 8 GB so this looks like something I am going to give a try. Does anyone already use TeraCopy or another similar program? If so, what is your experience?

Posted By George 0 comments

If you are a Windows XP user but really like the visual glass effects of Windows Vista, then Border Skin is for you.

Border Skin is a new free program that skins the windows
borders by skins composed of png images with the support
of 2 famous windows vista & 7 effects ( Blur and reflection )

Nothing much to really add here. When you run Border Skin, there is a control panel available in your system tray which allows you to control the settings. Additionally, you can set program exclusions in the event this effect causes problems on certain applications.

While this does not work 100% the way Vista does, it is an easy way to get the same eye candy effects.

Posted By George 0 comments

Cain & Abel 4.9.32 free programs regain the password stored in Windows. The program is in addition to recovering passwords, tracking network packets, and the breaking of passwords and security. The program can not be used for illegal purposes.

Cain & Abel 4.9.32 is a tool designed especially for administrators d networks with which you can check the security level of a home or office LAN.

The program allows you to recover passwords for a wide variety of protocols including FTP, SMTP, POP3, HTTP, MySQL, ICQ, Telnet and others and also to retrieve the keys hidden under the typical Windows line of asterisks.

The program includes other tools designed to manage and control networks.

Size: 7.24 MB
Publisher: Visit Website
Release Date: 2009-9-26
OS: Win 9x/ME/2K/NT/XP/Vista

Download

Posted By George 0 comments

RegRun Reanimator 6.5.6.54 is a free program to remove trojans, Adware, Spyware, and some rootkits. The program is compatible with all known antivirus programs.

RegRun Reanimator 6.5.6.54 is a free security solution with which we can scan your computer for viruses, Trojans, spyware and other malicious code variants. The program is very simple to use and very reliable, just need to pick the team where he will run the analysis (local PC or peripheral) and follow the steps shown in the interface.

In a few minutes you will get a detailed report about the threats found and can send that report to an official testing center from a contact form (recommended for beginners) or fix the problems manually.

RegRun Reanimator 6.5.6.54 may not conform to traditional techniques implemented by today's antivirus disinfect when our computers, but is equally effective and, above all, useful for the less experienced.

Size: 5.73 MB
Publisher: Visit Website
Release Date: 2009-9-26
OS: Win 9x/ME/2K/NT/XP/Vista

Download

Posted By George 0 comments

Personally, I am a big fan of the command line. From it I can get to just about everything I need pretty fast and I have an extensive set of utilities available at my disposal. One of the things, however, that isn’t so quick is navigating to different directories. If they have long names you have to type them exactly or they won’t take.

If this sounds familiar, here is a quick tip: pressing the TAB key will cycle through all the directory names in your current directory. For example, if you go to the command line and type “cd ” and then the tab key repeatedly, you will see the directory names are dropped in.

This shortcut can be an good time and keystroke saver, especially if you are navigating through the Windows or Program Files directory.

Posted By George 0 comments

Mozilla Thunderbird 3.0 Beta 4 mail client is being developed by the Mozilla Foundation in parallel with the popular Mozilla Firefox browser and is a wonderful complement to it. It is secure and fast, has a spam filter, supported protocols IMAP / POP, SMTP, NNTP (newsgroups); supports encryption and signing of letters. The program can be used as an RSS reader, in which articles are presented as letters in folders. Mozilla Thunderbird is a mail manager of the factory Mozilla, very well-known makers of the Firefox browser.

Among its features include its powerful mail filters, RSS reader and integrated newsgroups, message classification by tags, search history of messages

Security is also very important in Mozilla Thunderbird 3.0 Beta 4, with anti-fraud protection, spam detection and automatic updates.

And like Firefox, Mozilla Thunderbird 3.0 Beta 4 supports themes and additions, which improve their appearance and add more functions that already exist, and can be easily customized.

Size: 7.87 MB
Publisher: Visit Website
Release Date: 2009-9-22
OS: Win 9x/ME/2K/NT/XP/Vista

Download

Posted By George September 23, 2009 0 comments

Norman Malware Cleaner 2009.09.22 - a program to detect and remove malicious software (malware). Programos should not be used as a substitute for normal virus protection, but rather as a tool to treat systems that are already infected.

Norman Malware Cleaner 2009.09.22 is a free application developed to detect and remove a considerable amount of specific malware on your computer.

That yes, Norman Malware Cleaner 2009.09.22 has no access protection, so you can only use it to solve problems, not preventing them.

To use Norman Malware Cleaner 2009.09.22 is entirely to do this in Safe Mode, because their effectiveness is much greater. The program can stop and delete infected processes, eliminate infections disks, system files or ActiveX components, you can find and remove rootkits, correct and restore Windows registry values, and eliminate all malware insertions no longer on our computer.

The program can:
• running and kill infected processes,
• remove an infection from the disk (including ActiveX components and Browser Helper Objects),
• to detect and remove rootkits,
• restore correct registry values changed by malicious software
• remove references created by malware in the HOSTS file
• clear rules for malicious programs from Windows Firewall.

Size: 44.55 MB
Publisher: Visit Website
Release Date: 2009-9-22
OS: Win 9x/ME/2K/NT/XP/Vista

Download

Posted By George 0 comments

PicPick 2.1.2 Portable e free program that can "shoot" your working area, a window or just part of it. With built-in editor program you can easily and quickly edit what you've "shot". The program features an extremely easy and simple interface.

PicPick 2.1.2 Portable capture the screen image and then load into your editor to retouch. The program can capture full screen, active window, sections, a box, etc.. These operations can be made very comfortable thanks to the keyboard shortcuts that the user can configure as you like.

Once captured, the editor can improve brightness, contrast, draw with the brush, writing, rotate the image, and so on.

Size: 2.11 MB
Publisher: Visit Website
Release Date: 2009-9-21
OS: Win 9x/ME/2K/NT/XP/Vista

Download

Posted By George September 21, 2009 0 comments

PicPick 2.1.2 e free program that can "shoot" your working area, a window or just part of it. With built-in editor program you can easily and quickly edit what you've "shot". The program features an extremely easy and simple interface.

PicPick 2.1.2 is a digital image editing and editors focused on designers who need to make screen shots and retouch quickly and efficiently.

The program offers several capture modes, so you can choose to capture the entire screen or just a particular area. For the latter you can choose between capturing an active window, rectangular area, a free zone or Internet Explorer browser window.

Once you capture the window PicPick 2.1.2 can apply effects to retouch or conventional editing tools (brush, lines, geometric shapes, color selection tool, insert letters, etc.).. Some effects are available for focus and blur the image, apply grayscale, mirror the image horizontally or vertically, adjust the properties of brightness, saturation, contrast and color, etc..

Finally, PicPick 2.1.2 lets you work with multiple images simultaneously through an interface divided into tabs, and also has several fully configurable keyboard shortcuts with which you can shorten the screen capture process.

Size: 2.11 MB
Publisher: Visit Website
Release Date: 2009-9-21
OS: Win 9x/ME/2K/NT/XP/Vista

Download

Posted By George 0 comments

Get updates via email