Available as classroom training course only
£695 + VAT for most venues (£850 + VAT for London)
Excel can do so much more than simple pivot tables! This two-day course will show you how to:
Note that you'll need to be using Excel 2016 (or 2013) Professional Plus or Office 365 ProPlus to be able to use the Power BI (Power Business Intelligence) features within Excel.
The contents of this course are as follows:
This course uses Excel 2016 Professional Plus or Office 365 ProPlus.
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Mark Davies (NIHR Academy)
Anton Breen (Live Nation (Music) UK Limited)
Louise Gorry (Gamma Telecom Ltd)
Claire Howarth (Lex)
Jamie Fidler (STMicroelectronics (R&D) Ltd)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Good Day Wiseowl
Am I able to take this class while using an older version of excel? Just wanted to make sure I was up to date.
Good day Lance!
PowerPivot is pretty much the same for Excel 2010, 2013, 2016, 2019 and 365 (don't think I've missed any out), but for pre-2016 versions it's an add-in that you have to install. Excel 2013 had an annoying (and as it turned out, temporary) change, calling measures "calculated fields".
We don't run this course often now, though - my impression is that it hasn't got a great future, with everyone using Power BI instead (certainly that's where Microsoft are investing their money).
Hope this helps!