(Multiple Updates so hang on tight!)
I’m going to keep this one short as I’m actually working on another post more focused on Powerpivot
First Update: New and more Clean Website Design
Check it out for yourself! Click here to visit the site. It took me about a whole week designing this with Wix but it came out great. I’m planning on adding more widgets down the line but you’ll hear about it pretty soon.
Let me know in the comments sections below your thoughts on this new design.
Second Update: Translating a Powerpivot Book and June Course Evaluations
I’m happy to tell you that I’m translating Rob Collie’s book and that you can see his post about it here:
I’m more than halfway through so it should be available sooner than expected. In terms of my June Powerpivot Course:
you could say that it went greatwith a total of 5 participants (a few chosen ones!) the evaluations scores gave an average of 4.6 out of a 5 possible total which is extremely great!
I’m planning on doing it again with another partner by the end of August so stay tuned for more info about it!
Third Update: The Automatic Refresh Process
If you’ve read this post
before then you’ve read the comments about the Excel Refresher Service
and if you’ve done more googling you’ve probably found that with Excel 2013, things are even easier because of how you can use straight forward VBA to code things for Powerpivot. After playing a bit with the Excel Refresher, I’ve noticed that it works perfectly but some people doesn’t seem to set it up the right way at first and, to be honest, it can be tricky. Therefore, I’m going towards the excel refresher solutions on codeplex and hopefully streamline this solutions so we can all have the add to what’s already been built and not recreate a whole new ‘wheel’.
Final Update: The new Access 2013 Web Application on Sharepoint (blog post coming too!)
If you’ve never seen or heard about this before then I urge you to do it asap. If not, then wait a couple of days for an interesting post about itThis is truly a groundbreaking tool when creating a database and Access+Excel has always been the best duo of MS Office but now it’ll be the Access Web App + Powerpivot