Add a Reporting Ribbon to Excel to consolidate and highlight the amazing capabilities of Power Query and Power Pivot
Tables, Power Query, Power Pivot and Pivot Tables are amazing tools that will transform the way people build their reports, but only once they know about them!
Let's SHOUT about how good these things are and how well they work together by putting them onto a single new Ribbon called "Reporting" - something like the attached image.

Thank you for posting and voting for this idea, but unfortunately we won’t be implementing it. Excel is a tool for a wide set of audience and while this may help to some, it may defintely confuse others. As a workaround, I suggest to use the Customize Ribbon option and add a new tab with you desired set of tools and commands.
Guy Hunkin
Program Manager, Excel Team
28 comments
Comments are closed-
Ilgar Zarbaliyev commented
Power View (although it is not so widely used) and 3D Maps (Power Map)
-
Manu commented
I am in a process of exploring the ultimate excel miracles and really would like to see into it
-
Anonymous commented
Need it
-
Luc Debois commented
Great idea but extra buttons such as KPI can be an added value ... :-)
-
ROMEO OYARO MOGIRE commented
Done
-
Shlomi commented
Great idea!!
-
Debbie commented
This would be brilliant. Also please add to MAC too.
-
Anonymous commented
Done!
-
Wyn Hopkins commented
Plus.... a Get Parameter button that avoids the formula firewall...
Sorry to cross post, but folks who like this idea may well like this one
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/32691571-add-get-parameter-button-to-power-query-and-avoid -
Wyn Hopkins commented
If I could edit my suggestion I would. Let's call it what it is... POWER features. Adding a Publish to Power BI button would be great too. Some good options listed in Sameer's post a few items below this one
-
Wyn Hopkins commented
OK, so let's call it the POWER tab (see image)
-
Sameer Bhide commented
Done
Let me know if you need the CustomUI File -
Anonymous commented
Power Query is NOT a reporting tool. However, I do agree that these two BI tools should be under the same tab.
-
Paul commented
This is a good idea.
-
David Benaim commented
Absolutely agree, excels biggest flaw is that no one clicks in the important features. This new ribbon people would actually click on to try! I would colour scales and data bars, as standalone command (not in a submenu). No one ever clicks on the conditional format dialog, so they miss out on these!
-
Dave Quinn commented
Please make this happen
-
Jimmy commented
Please make this available ASAP. Very useful.
-
Anonymous commented
Amazing Idea!!!
-
Ed Hansberry commented
Honestly, I'd be ok if we just got the "Center across columns" button. ;-)
-
NH commented
I suggest adding Excel's Power Query and Power Pivot features to Access in Office 2019.