PowerPivot: Excel’s Hidden Feature Will Change Your Life and Career



PowerPivot: Excel’s Hidden Feature Will Change Your Life and Career

Speaker: Rob Collie

  • Format


  • Level


  • Duration


Gain awareness of Microsoft's investments in Excel and how you can use them to better your career.

Learning outcomes

  • Gaining awareness of Microsoft's massive investments in this space (capabilities ideal for the FP&A pro, but poorly marketed)
  • Understanding the roles and utility of PowerPivot and PowerQuery- the two "engines" at the heart of this

£35.00 (CIMA members only)


VAT calculated on checkout

Product information


Microsoft has quietly been turbocharging Excel by integrating industrial strength business intelligence and reporting engines into it- capabilities that are 100% built for you- and that you start revolutionising your career (and improving your life) on your very first day using them. Take your first step in this session.

Topics discussed:

  • Microsoft's investments in Excel
  • PowerPivot and PowerQuery functions

This is an online, video course; it is also available as part of CGMA Essentials.

Who should take this course?

  • Controllers
  • CFOs
  • Finance Managers
  • Vice Presidents of Finance, Strategy, or FP&A
  • Anyone with responsibility for financial planning, strategy and analysis for small, medium or large companies

Professional development

All learning resources available in the CGMA Store qualify for CPD for CIMA members.

Programme level:Intermediate
Access:This is a digital product. You will have access to the content for a year after purchase date.

Return and refund policy

£35.00 (CIMA members only)


VAT calculated on checkout


  • Rob Collie

    One of the founding engineers behind Power Pivot during his 14-year career at Microsoft, and creator of the world?s first cloud Power Pivot service, Rob is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology. Rob left Microsoft in 2010 to start his own consulting and training firm (PowerPivotPro), and has seen the same theme repeat itself hundreds of times since: this toolset doesn?t just increase efficiency. It doesn?t just reduce costs. It doesn?t just lead to dramatically smarter decisions and same-day agility. It also makes people ? and organizations ? happier. Rob wants to help you experience that for yourself. When he?s not training, consulting, speaking, or writing, Rob can be found in his laboratory, devising new tools and techniques for the Power BI community. He is the author of two books, including the world?s #1-selling Power BI book (""Power Pivot and Power BI""), has penned over 600 articles and whitepapers, and also occasionally sleeps.


The Association is dedicated to removing barriers to the accountancy profession and ensuring that all accountancy professionals and other members of the public with an interest in the profession or joining the profession, including those with disabilities, have access to the profession and the Association's website, educational materials, products, and services. The Association is committed to making professional learning accessible to all. This commitment is maintained in accordance with applicable law. For additional information, please refer to the Association's Website Accessibility Policy. For accommodation requests, please contact adaaccessibility@aicpa-cima.com and indicate the product that you are interested in (title, etc.) and the requested accommodation(s): Audio/Visual/Other. A member of our team will be in contact with you promptly to make sure we meet your needs appropriately.