The Office Tips and Hints blog regulary has some great tips (hence the name). I thought one mentioned the other day was fascinating. It shows how to read all the forumalas in your worksheet and put them inside comment bubbles.
You can read all about it at http://www.klippert.com/TCC/Blog/2005/03/excel-show-formulas-in-cell-comments.html
Monthly Archive for March, 2005
I’m sure many of you have heard of this before, but I was just reminded of it recently. Martin Aignesberger has written a bunch of utilities, one of them being software that checks your bookmarks:
AM-DeadLink detects dead links and duplicates in your Browser Bookmarks. If a Bookmark has become unavailable you can delete it from your Browser. AM-DeadLink checks Bookmarks from Internet Explorer, Opera, Mozilla and Netscape.
I just ran it and I have 276 bookmarks, and 18 of them are bad. Of course I probably haven’t visited over 200 of them in last year, but that is a different problem entirely.
Check it out at http://www.aignes.com/deadlink.htm
Someone at work asked how they can get an entire path name in the footer of their Excel spreadsheet. Excel 2000 only allows you to put the filename is. There is a Microsoft Knowledgebase article that explains how to create a very simple macro that will do this. Check it out at http://support.microsoft.com/default.aspx?scid=kb;en-us;213615
From InfoWorld:
“As computers appeared on the public scene in the ’50s, psychologists marveled at the parallels between data-processing technology and the workings of the human mind. A handful of scientists of the day believed that the functional structure of the human mind was fully analogous to that of the computer. Considering that computers in the ’50s were slow, noisy, and unreliable, those scientists apparently didn’t think much of their warm-blooded subjects. I happen to be old-fashioned enough to think that some things will always be beyond man’s understanding, with or without a supercomputer in every garage.”
We’ve mentioned this before, but subscriber and co-worker Louise passed it along again. In particular, she thought the calendar section was interesting. You can pull up yearly calendars for any country, show local holidays, show moon phases, or not show anything.
Check it out at http://www.timeanddate.com/calendar/
“Clean house Cut clutter Get organized Simplify life at home!”
http://organizedhome.com/
Subscriber and good friend Alex sent this:
I’m not sure if this is of any interest, but I ran into it and thought it may be a fun site to include in your PCIN newsletter. It allows you to enter a year and an amount of money and tells you how much money that would be worth by today’s standards. It also allows you to compare two arbitrary years.
http://eh.net/hmit/ppowerusd/
From the site:
“Comparing the purchasing power of money in the United States (or colonies) from 1665 to 2003.”
From USA Today:
“Searching for an answer to the music download revolution, automakers and audio suppliers are preparing a new wave of car stereos with enough built-in memory for hours of recorded music.
Chevrolet will introduce an entertainment-system option on its Uplander minivan this spring that has hard-drive memory capable of storing 40 movies, 10,000 song tracks or basic video games. It will be offered in General Motors’ other minivans by the year’s end.
Storing music and movies on the hard drive cuts clutter. ‘As the mother of two kids, you have CDs and DVDs floating around the vehicle. It’s nice to consolidate,’ GM spokeswoman Lynda Messina says.”
I blogged awhile ago about Yahoo!’s 10 annivertsary. The latest Search Engine Watch links to a neat page where they have thumbnails of 100 web moments. Check it out at http://birthday.yahoo.com/netrospective/
From PC World:
“Google opened up its Gmail Web mail service to a wider scope of users this week by randomly offering, for the first time, accounts to some visitors of the main Google.com page.
Until Monday, to get a Gmail account, a user had to be invited to the service by either Google or an existing Gmail user.”
I know Gmail invitations are everywhere now, but I still have a bunch if anyone wants one. Just email me and let me know.
Latest Comments
RSS