Summary
Keywords
Full Transcript
A really simple yet effective trick to make an interactive pivot report or dashboard quickly. You can set up hyperlink navigation in Excel that can take users from one sheet to another. When you combine this idea with shapes & simple formatting trickery, you get a nice & polished multi-page Pivot report. Sample fileππ : =============== https://chandoo.org/wp/wp-content/uploads/2021/09/hyperlink-multipivot-trick.xlsx π₯NEWπ₯ ======== I just launched a mini-course on how to create modern & interactive executive dashboard using Excel. If you want to learn how to make powerful & dynamic dashboards, Please get the course here π https://chandoo.org/wp/modern-excel-dashboards-mini-course/ Learn more π»: ============= How to create a Pivot Report in Excel - https://youtu.be/aofsdpjvK7w Pivot table basics, concepts & examples - https://www.youtube.com/watch?v=Gx9ZVlGkbOk&list=PLmejDGrsgFyAurpKfvdwBsvBsRDsgvr2j Advanced Pivot Table tricks - Playlist - https://www.youtube.com/watch?v=0HU8Hej6ong&list=PLmejDGrsgFyBH0zkiwAXsDLMMyGEO2hsx More Dashboard tips & tricks - https://chandoo.org/wp/excel-dashboards/ My new dashboard mini-course - https://chandoo.org/wp/modern-excel-dashboards-mini-course/ ~ And yeah, DFTBA ππΌπ #ExcelDashboards
