Guest Post by Ken Puls (www.excelguru.ca)
I just wanted to throw out a quick note to let everyone know that I’ll be teaching a course on PowerPivot and DAX in Victoria, BC on November 22nd, 2013. While the course is hosted by the Chartered Professional Accountants, it’s open to anyone who wishes to subscribe.
If you’ve been trying to figure out how to get started with PowerPivot, you’re confused as to how and why things work, or you want to master date/time intelligence in PowerPivot, this course is for you.
This is a hands on course that starts with basic pivot tables (just as a refresher) and how to build the PowerPivot versions. We then work though understanding filter context, measures and relationships, and finish the day by building measures that allow you to pull great stats such as Month to Date for the same month last year, among others.
You’ll get the most out of this course if you’re experienced with PivotTables.
This is a hands on course, so you need to bring a laptop that is pre-loaded with either:
- Excel 2010 and the free PowerPivot download
- Excel 2013 with Office 2013 Professional Plus installed (yes the PLUS is key!)
- Excel 2013 with Excel 2013 standalone installed.
If you have any questions as to which you have installed, simply drop me a note via the contact form on my website, and I’ll help you figure it out.
As an added bonus, to anyone who signs up via this notice, please let me know. I’ll provide you with a free copy of my Magic of PivotTables course so that you can make sure you’re 100% Pivot Table compatible before you arrive.
Full details of the course contents as well as a registration link, can be found at https://www.icabc-pd.com/pd-seminars-seminar.php?id=2849. Don’t wait too long though, as registration deadline is November 14th!
Hope to see you there!