Spy Journal 3.0 Filtering the web for you

I have been using the HTC Mozart for a few months now. Fair to say its the best phone I have ever used in a number of ways.

Best hardware I have every used. Simple easy to use external hard and soft buttons, ordinary 6.5mm stereo headphone jack, micro USB charger - uses both a power adaptor (supplied) or via a USB port.

Best Phone Software - EVER. This kills the previous mobile 6.1, 6.5 interfaces, and the previous HTC TouchFlo software. It is smooth, sexy, responsive and packed with features. The only draw back is its missing copy and paste.

Best ever applications. While there are plenty of stupid ones (I love the Chuck Norris Facts App) there are very good useful apps, including YouTube, Flickr Manager, Facebook, etc.

The built in maps software is fast with amazing fine grained detail.

I have setup access to two separate exchange server email accounts and a POP3 account. The calendar integrates with them and allows separate colours to differentiate.

The following pages were useful in setting up accounts:

Set up or delete an email account

Setting up your Windows Live ID and email accounts

I have had a lot of articles, news and other tech information filling up my browser and its time to de-clutter before Christmas.

Microsoft Excel

INDEX -MATCH - a much better lookup function combination than using VLOOKUP or HLOOKUP. Charley Kyd writes a very good instructive post on using this combination. We use this a lot where the failings of VLOOKUP make it impossible to use.

MSDN announces the new developer roadmap for Excel and VBA. Interesting reading and has lots of useful links.

Power Pivot is an amazing AddIn for Excel 2010. I have written about Power Pivot before. Dick Kusleika has written a simple function to determine whether an Excel Workbook contains power pivot data.

Microsoft Outlook

Conditional formatting and highlighting your emails based on content, subject, sender etc.

Roy MacLean asks some interesting questions about storing data in Outlook. I love Outlook and think it is a very good tool, however there are lots of limitations with using it. Mind you I don't see any other email client out there that can do everything that Outlook can do or even half as well in most cases. Still Roy has some good points.

I have upgraded to a Windows Phone 7 - and the handset I chose is the HTC Mozart. It is probably the slickest phone interface i have ever used - and beats the iPhone 4 on most features. It certainly is streets ahead of the old Windows Mobile 6.5 phones - my previous phone was the extremely powerful HTX TouchPro2. Its only flaw was the slow TouchFlo3d interface.

Microsoft Office 2010

There are some nice new things to get used to in Office 2010. I’m loving and hating Outlook. The conversations are great and painful at the same time.

Thank goodness for Xobni or I think I would go mad trying to find some emails.

I do have two exchange accounts running in Outlook, hence the reason I had to go to the Beta. The good news is the RTM version is now only 2 months away.

I’m running 32bit Office 2010 at the moment. Here are some articles about the differences between 32bit and 64bit.

• Understanding 64bit Office
• Compatibility Between the 32-bit and 64-bit Versions of Office 2010