Spy Journal 3.0 Filtering the web for you

I am proud to be affiliated with Charley Kyd’s Excel User Dashboard products (see the little graphic on the left hand side). I can heartily recommend his excellent products.

Charley is having a HALF OFF sale as well as some other amazing benefits. Here are the details:

Until midnight this Friday, you can get my best dashboard products for HALF OFF.

Here’s where you can grab your copies for half off.

I’m holding this special sale as a way to say THANK YOU to my customers and people who read my Excel For Business newsletter.

Here’s where you can grab your copy and save 50%.

Try My Dashboards for 50% And Get Six Free Bonuses.

If the 50% discount isn’t enough to have you heading to my half-off catalog page, these SIX free gifts will surely do the trick.

•  Bonus 1: One-Hour Live Webinar about IncSight QnE
This live webinar will show you how to set up and use IncSight QnE, and how to adapt its templates to meet your specific needs. I'll show you how to add or subtract periods, change periods to any that you want, add calculations, change chart sizes, change color schemes, and a lot more.

I don’t know why I seem to write massive link posts lately – maybe because i have been very busy with my three major priorities, family, work and photography. However this is a priority as well, so I need to allocate some time to write soon. In the mean time I am going to clear my browser of the tabs that are open there.

Here goes – and have a great weekend. Oh – and this photo was my favourite of the week. I took it in low light, no flash using the 70-200 2.8 IS L Lens.

Exposure 1/128, Aperture f2.8, focal length 170mm, ISO 2000

Photography Links

• A Beginner’s Guide to Flickr by Elizabeth Halford – I love flickr also – an awesome tool
• Helping Your Client Prepare for Their Shoot – Dress to Match the Sofa? by Elizabeth Halford
• 5 Tips for Photographing Children – some great tips here
• 3 Affordable E-books to Improve Your Photography by Darren Rowse – thinking of getting these
• How to Capture Motion Blur in Photography by Darren Rowse - learning this technique is going to be fun
• Jasmine Star – an awesome wedding photography blog
• I love this photo gypsy meets gangster
• Jakob Aungiers – this is an amazing portfolio

Back to work and back to an inbox full of things to do. I have spent a massive amount of time this last week working – the sailing holiday is now a dim and distant memory!

First some riding news. I got my bike back with the rear shock rebuilt (under warranty) and took it for a test ride with the MTB ride group yesterday. It held up just fine and the ride was an epic one - if a little long for my liking. The Saturday MTB group is back – meeting at the Wolves Bike Den every Saturday at midday for an epic ride like this. All ages and experiences welcome.

Map and terrain detail on bikely of the Ewen Maddock Dam Ride Click the pictures for more detail.

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.

Ok so that title was a little contrived – and only because my wife bought the classic Jules Verne book yesterday along with Mark Twain’s Tom Sawyer, Louisa Alcott’s Little Woman and Jack London’s Call of the Wild.

This article has a bunch of cool Microsoft Excel related content from all around the world.

10 worst Microsoft Excel practices. Michiel has created this list, but I certainly wouldn’t rank them the same way.

My Top three would be:

• Linked spreadsheet files (workbooks)
• Merged Cells
• Combining reports and data tables on the same worksheet – Michiel’s number 9. The other two don’t even make his list.

Allen Wyatt has a great article providing some VBA code to detect errors in conditional formatting formulas. This is a very practical solution to a very real problem.

Doug Klippert has posted some code from Peter Beach an Excel MVP that will create a list in Excel of all the folders on a drive and their sizes.

Andrew Engwirda has added some cool chart tools to his free Excel Tools. (News flash – he might come back to work for me! – Stay tuned)

Dick’s Daily Dose of Excel has two interesting posts (well lots actually but two I picked out) – the first written is on displaying image galleries in the ribbon written by Ron de Bruin, and the second titled Elle’s birthday.

Joseph has a very good explanation written for the new Excel 2007 tables of how not to break your summing formulas. The same concepts apply in Excel 2003 for the auto sum function using the Sigma button the toolbar.

Oh and that’s a photo of Kitty pretending to be interested in spreadsheeting techniques. Kitty is a business analyst working for Jethro.