Spy Journal 3.0 Filtering the web for you

There is just so much going on with the whole change over from Office 2007 to 2010, and for those of you still stuck in 2003, even more important for you to start convincing your organisations of the need to go straight to 2010.

We have been running the beta 2010 here solidly an all our main machines here for 2 months now, with some individual test machines previous to that. Unfortunately now we have to have test and development environments in both 2003 and 2007 so that has doubled our required number of Virtual Machines.

Following are some of the latest news and bits and pieces as well as some other MS Office related information I have come across recently.

Excel 2007 and 2010

Conditional formatting. Conditional formatting in 2007 is one of the main reasons people come to Spyjournal.biz. These two articles are the single most hit articles of the thousands here with over 50,000 views between them:

• Conditional formatting in Excel 2007 - entire row colours
• Excel 2007 Conditional Formatting

Amit Velingkar has written conditional formatting rules simplified while Dick Kusleika has written some code to list out all the conditional formatting rules in a worksheet

Windows Phone Website – if you use a windows mobile then there are plenty of resources here. If you don’t you probably should!

Insert the date and time in your OneNote notes. Shortcuts are:

• To insert the current date and time, press ALT+SHIFT+F.
• To insert only the date, press ALT+SHIFT+D.
• To insert only the time, press ALT+SHIFT+T.

Explanation of trusted documents feature in Office 2010

Outlook 2010 has some cool calendar features

Windows Media Centre Hints and tips from Missing remote

Starting with what do people do all day? The New York Times has an interactive chart of what people do all day broken by various demographics. Very cool to view.

Change the world – start by changing your underpants. Pact is a lingerie company with some major differences. Check out their website.

PACT's motto is CHANGE STARTS WITH YOUR UNDERWEAR. The purchase of PACT underwear is participation in a social movement: when you buy PACT underwear, you are supporting and encouraging organic cotton farmers, responsible labor practices, and businesses that form partnerships with nonprofit organizations dedicated to positive change in our world

Office twenty-ten (the correct way of saying it) has some awesome new features over Office 2003 and 2007.

The following links highlight some of the amazing things that are going on and I must say I am pretty impressed so far.

Joseph Chirilov has been busy writing (and geting guest writers to write) articles about both the upcoming changes in Excel 2010 as well as a series on using sparklines in Excel 2007 and 2010. Sparklines are mini in-line charts that can graphically display data in a very small space.