Spy Journal 3.0 Filtering the web for you

There has been so much Excel and Office related info come over my desk the last couple of weeks I don't have time to do it all justice, but I will try and share it with you in an organised way as possible.

Office 2007 and earlier

Create conditional drop-down lists. In Excel 2007 (and earlier), it’s possible to create a drop-down list. By using the INDIRECT function, you can then create additional drop-down lists that are conditional to the first drop-down list.

From J-Walk, run some code that runs 1 million random numbers and see how fast your computer is compared with others.

From Daily Dose of Excel theres some great code to alter screen size to suit the clients screen resolution.

Office and Excel 2010

Working with images in Office 2010 is fantastic. The new background removal feature is a Photoshop-like technique that works really we.. This article describes how to make background removal work even better.

Mobility in Office 2010 is great if you have an iPhone or Blackberry and even better if you have a Windows Mobile.

Ribbon customization is available across all Office 2010 client applications, and allows you to create a personalized Ribbon optimized to the way you work with the application.