Bruno Aziza has a pretty cool post on the MSDN blog which uses PowerPivot to extract calendar data from Exchange and put it into a dashboard. There's a Youtube video there, as well as the file to download and try it out.
One thing this showed me is just how poorly I categorize my time!
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.