Spy Journal 3.0 Filtering the web for you

Let me introduce Kitty to you. At the inaugural Brisbane Girl Geek Dinner, to which I took Amanda who worked for me, I wore my kilt and took photos of the ladies there. Bronwen Zande had done a great job organising it and while Amanda was sitting down chatting I was wandering around taking photos and talking. When I finally sat down next to Amanda the seat on the other side was taken by a lovely young platinum blonde haired lady. She was very personable and though she was there with her friend Jenine spent most of the night talking to me. By the end of the night I had decided to hire her.

I love Windows Live Photo Gallery. Apart from the fact that it is free, is the best camera import tool I have found, can display RAW images (with the right codecs installed), can publish to flickr, facebook and YouTube, has facial recognition built in and other cool features, it also has another really cool feature – editing with a revert to original option.

So this week I discovered something about that. I had been noticing my C drive space slowly decreasing. Now seeing as I only have Windows 7 and all my programs installed on the C drive and most of my data is contained on other drives, I was wondering what was going on. A quick search found the bulk of the data was in two folders, my outlook data folder where I had an unused old archive sitting (10GB) and then a folder called

C:\Users\(username)\AppData\Local\Microsoft\Windows Photo Gallery\Original Images. There was some 20GB in here

When I looked I was amazed to see a bunch of photos. Some research turned up these facts.

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