Computer Tips and Help Guides

-
I receive a weekly email from ZDNet called Download Digest (which I read about every 4th one). It is their weekly recommendation of software; much of it is useless, but occasionally there are some nuggets. In addition, there is a section on recommended TechRepublic articles. These are recycled over time, but again there are some nuggets. For example, if you're not real Internet savvy, you might be interested in 10 things you should do to a new PC before connecting it to the Internet. (Note that you must sign-up for a free account to access TechRepublic.)

Here are some TechRepublic tips and guides that I believe people may find valuable:
  1. Powerful PowerPoint Presentations: This wont teach you how to make better presentations, but it will teach you how to use PowerPoint to its fullest capability.
  2. How do I...Migrate from Outlook Express to Mozilla's Thunderbird?: If you haven't yet switched to Thunderbird for email, this article is helpful in getting you through the process.
  3. Creating a bootable USB flash drive for Windows XP: Just what you need when you're troubleshooting your friends PC.
  4. Create a bootable WinXP CD slipstreamed with SP2 and hotfixes: The perfect companion for your bootable USB flash drive when you need to reinstall XP.
  5. How do I... Uninstall Microsoft Internet Explorer 7?: This will only roll you back to IE6, but if you are having problems with some web apps using IE7, this is a great help. (Of course you should have been using Firefox anyway.)

While you're visiting TechRepublic, also be sure to read The 10 worst geek gift ideas for the holidays.

As with the Download Digest, if you are willing to put the effort into sifting through for the nuggets, TechRepublic does contain some practical articles.

Comments

Post a Comment

Popular posts from this blog

Digital Signatures in PDF Do Not Print

-
Image
Trouble getting the digital signature in a PDF to print? The solution is actually simpler than you might think. With your document open in Adobe Acrobat Reader, click File >> Print. When the Print dialog box opens, look for the "Comments and Forms:" drop-down below the Properties button, located in the upper-right. Click the drop-down and select "Document and Markups." Now print. That's all there is to it.
Read more

Referencing the value of a cell, not its formula

-
Image
In Excel, I will use formulas quite frequently for my analysis. At times I want to reference the resulting value of the formula for comparison or to feed another formula. Unfortunately, if you are doing a comparison, Excel will try to compare the formula instead of the formulas results. Well, turns out there is an easy way to correct this. If you want your formula result to be a number, then use the VALUE function. If you want the formula result to be text, use the TEXT function. Here is the syntax for each: VALUE(text) TEXT(value,format_text) -- The format_text value can be any format from the Category box on the Number tab (in the Format Cells dialog box) except General. Here is an example of each: =VALUE(MID(A2,46,FIND("&",A2)-46)) -- this actually finds a number beginning with the 46th character of a string, and continues until it finds the ampersand character. By wrapping the formula with VALUE, I can now compare the number to other numbers in my looku
Read more

CorelDRAW X4 Crash on Startup

-
I had a fresh install of CorelDRAW X4, and each time I tried to start it, it would crash. After some searching through Google, I found the following fix. Open the folder C:\Program Files\Corel\CorelDRAW Graphics Suite X4\Programs\UIConfig\CorelDRAW Edit DrawUI.xml Find the line <dockpage guidref="bc1e2f70-3b58-41cd-8406-aaa550482972" visible="true" selected="true"> Change visible="false" and remove selected="true" <dockpage guidref="bc1e2f70-3b58-41cd-8406-aaa550482972" visible="false"> Save and close DrawUI.xml Fold down F8 and restart CorelDRAW X4 When prompted to update settings, select OK That did the trick for me. Apparently it is caused by a conflict with MFC dlls that are installed (version 1833) with SQL2008.
Read more