- Joined
- Mar 13, 2011
- Messages
- 2,531
- Reaction score
- 6
- Points
- 38
- Location
- Nanaimo, BC, Canada
- Website
- www.excelguru.ca
- Excel Version(s)
- Excel Office 365 Insider
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.
http://blogs.msdn.com/b/bi/archive/...ndar-use-powerpivot-to-analyze-your-time.aspx
One thing this showed me is just how poorly I categorize my time!
http://blogs.msdn.com/b/bi/archive/...ndar-use-powerpivot-to-analyze-your-time.aspx
One thing this showed me is just how poorly I categorize my time!