Spy Journal 3.0 Filtering the web for you

Today I am focussed on clearing out my browser from all the interesting things sitting there. No real organisation to this post – its just a link dump.

• Smashing Magazine useful web design information
• Feeling “Blogged Out?” [10 Pro Bloggers Share Their Advice on What to Do]
• David Willersdorf’s blog
• Australian Institute of Professional Photography
• Judith wrote up the story of last weekend’s DirtFest Adventure on her blog
• My photos from the Salomon Tre-X Triathlon – I was the official photographer for the day
• Results from the DirtFest and Triathlon on the in2adventure website. I got 24th from 32 entrants in my class and 43rd overall.
• Internet Explorer 9 is coming and you can test drive it. It might even be standards compliant!
• Australian students rejoice – you can get Office 2007 with a free upgrade to Office 2010 for only $75.
• Likewise any purchases of Office 2007 now are available with a free upgrade to Office 2010.
• Judith’s team is entered in the Oxfam Trailwalker Sydney – a 100km endurance walk challenge.
• Taking photos with motion blur
• Importing text files in Excel 2007

And I will leave you with some of my best photos from the Triathlon.

Its been a while since i wrote an Excel only post – apologies for that. This one is all about Excel. Seeing as we are now less than 2 months away from Excel 2010 there’s a heavy focus on that. I am now using the beta on my production  development machines though still using Excel 2003 in our virtual machine development environments. Some of our clients change slower than a glacier but we need to be able to support them.

Scatter charts with PowerPivot. Converting Pivot tables to cube formulas in order to access chart types not supported by Pivot tables. Sam has linked to Robs original post.

I have often used spin controls on spreadsheets to allow users to quickly and easily change inputs that affect charts or spreadsheet results. Cell Matrix has a good set of instructions on How to add an ActiveX SpinButton control to a spreadsheet in Excel 2007.

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

We are excited to announce a prize giveaway promotion, thanks to the folks over at Ignite Social Media.

Ok the quiz is open to everybody, but unfortunately the prize can only be won by someone who is a US resident.

The Prizes

The prize we will ship is a total value of over $250, and will include a Dell ST2310 23 inch flat panel monitor, keyboard, and mouse.

The Competition

Head to www.exceleratorsquiz.com and take the quiz. You will get a ranking, For example I was a Power User. You can post that on Twitter and Facebook also.

How to win

Post your ranking in the comments below along with your name, City and US post code. Add any other comment you like about Excel 2010 or PowerPivot. Be creative because I  will select a winner based on the comment you write.

Have fun!