This article was written by MysticGeek, a tech blogger at the How-To Geek Blogs.
Microsoft Excel is used by companies and individuals to keep track of and compute virtually anything that requires numbers. If you are computing financial symbols, did you know there’s a way to have Excel automatically update those values online?
You can use smart tags in Excel to keep track of your stock quotes. (Keep in mind you do need an Internet connection for this). With this feature Excel will connect to MSN Money Central to download the information.
First we need to enable the smart cell feature by clicking the Office Button \ Excel Options \ Proofing \ AutoCorrect Options and click on the Smart Tags tab. Make sure and place a check next to Financial Symbol. Click OK twice to get back to your worksheet.
Now that smart tags are enabled all we need to do is enter in our favorite stock symbol using all capital letters (in this instance I am using Microsoft). Now hover the mouse over the lower left corner of the cell until the smart tag appears and click. Select Insert refreshable stock price.
Now select where you would like the starting cell or you can also choose a new work sheet. Click OK.
Excel will go retrieve the information regarding the stock from MSN Money Central. This will also include hyperlinks to additional information which will open in a separate browser.
Is this a feature you’d actually use?
Although I am not a Keyboard Ninja I still like to navigate quickly through Windows. You can make your mousing more efficient using the snap to option which is inherent to XP. This also works with Vista although getting to this setting is obviously different.
If your mouse pointer seems to constantly get in the way while you are typing, you aren’t alone… you click in the middle of some text and start typing to insert more, but the cursor stays in the way. There’s a tiny utility called MouseAway that will solve this problem for you… it’s not new, but it
I’ve found that this dramatically speeds up the remote connection. Note that you should probably re-enable the old setting after you are done.
I have heard and seen many funny situations in my IT career but today was the best one I have heard in a long time. A person referred to the asterisk key on their keyboard as “The Snowflake Key”. LMAO doesn’t do the 20 minutes of laughing I did justice.
I spend an enormous amount of time browsing the web looking for new ideas to write about, so one of the biggest problems for me is tagging articles for more careful reading later. Also, I’m sure any moment I’m going to reach a page that says “You’ve reached the end of the internet, now go outside”.
Anybody who has ever tried to change the theme in Windows will already know that you have to hack the uxtheme file in order to install themes into XP that aren’t digitally signed by Microsoft. If you would rather not or are unable to patch your system you might be interested in these unofficial
Let’s face it … CRT monitors are still out there in the office environment. Where I work we are slowly phasing them out as our budget allows. The other day I was troubleshooting an issue with an older computer with a CRT monitor and when I looked at it I almost got sick from the flickering
If you are reading this article you are probably annoyed that every single time you add a bookmark in Firefox you have to click on the expand button to show the folder list before you can actually locate the folder to put the bookmark in.
How many times have you been watching a long video on your computer and had the screensaver come on? Then you play the game of trying to jiggle the mouse every certain number of minutes to make sure it doesn’t happen again… seems like it would be easier to have a really quick way to disable the
After a buddy of mine pestered me enough about Winamp I finally decided to take the 10th Anniversary Edition for a test run. Previous versions of Winamp never impressed me much. I hate having to configure tons of worthless features in a player. Also, I have never liked inviting intrusive