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.
Wyn Hopkins
shared this idea
27 comments
-
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.
-
Pieter Erasmus
commented
The Graphing function does not allow for easy amendment of the graphed ranges. If I copy a graph I have to change the ranges manually one series at a time which wastes time. A global change for this graph on the full data set will be valued.
Also if the Legend for Trends would color the slope and R squared values the same color as the data series trended.
