Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Make an AWESOME Multi-page Dashboard in Excel with this Trick πŸ’‘
Play lesson

Data Analysis with Excel πŸ“ˆπŸ“‰πŸ“Šβœ… - Make an AWESOME Multi-page Dashboard in Excel with this Trick πŸ’‘

4.0 (1)
11 learners

What you'll learn

This course includes

  • 14.3 hours of video
  • Certificate of completion
  • Access on mobile and TV

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

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

FAQs

Course Hive
Download CourseHive
Keep learning anywhere