• Buffer
  • Sharebar
  • Buffer
jethro's picture

Excel Links and news

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

Excel 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.

jethro's picture

Office DevCon has been a big disappointment so far

So I was all excited. Office DevCon 2009 was in Brisbane this year. We develop in Excel and VBA. I was looking forward to networking with others who do the same, and learning some new techniques and tricks.  odc09_logo The session track précis hinted at new reporting techniques, building reports for excel-centric clients, new VBA forms and more. I skipped the first day because there was only 1 session I wanted to go to. I was all excited about the second day because I thought (wrongly) my desires would be met. But no. I should have read the presenter profiles page first!.

These guys were all Access gurus. And they seemed to know what they were doing, but when it came to Excel they ignored the massive functionality of Excel, and treated it primarily as a report display system.

I think I am going to offer to present next year.

jethro's picture

News from around the Web

Windows Phone Website – if you use a windows mobile then there are plenty of resources here. If you don’t you probably should!

Insert the date and time in your OneNote notes. Shortcuts are:

  • To insert the current date and time, press ALT+SHIFT+F.
  • To insert only the date, press ALT+SHIFT+D.
  • To insert only the time, press ALT+SHIFT+T.

Explanation of trusted documents feature in Office 2010

Outlook 2010 has some cool calendar features

Windows Media Centre Hints and tips from Missing remote

jethro's picture

Riding and other bits and pieces

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.