Excel Dynamic HR DASHBOARD - Part 7 FINAL TOUCHES!

In the finale of how to create a dashboard in Excel, we'll put on the finishing touches for your audience. I show you how to create an introduction page, create buttons to aid navigation, hide technical sheets, remove the rulers and grid, insert update instructions, and more. You've done the hard work on the more technical dashboard in the videos so far, so why not make your Excel file feel like a proper professional report too?

For this Excel dashboard, I've used an HR dataset from the fictional company 'Dunder Mifflin', which you may know from 'The Office' TV show. I believe it's good to use familiar and fun data while learning, rather than the generic or bland 'dummy data' used in such tutorials. I find it more engaging and the concepts seem to flow easier.

Download the follow-along dataset should you wish to learn by creating this exact thing from my blog below. But using the concepts and learning, you'll be able to create your own dashboard from ANY dataset!

https://excelattheoffice.com/2024/04/...

This is Video 7 and the finale in my mini-series all about how to make stunning and dynamic dashboards of charts and graphs in Excel. Video 1 gave you an introduction and demo of the HR dashboard I've created. In Video 2 I showed you how to set up the worksheets and refine the data with formatting and calculations. Video 3 went deep on creating the pivot tables to summarise the raw data. In Video 4 we created the dashboard canvas, then created the pleasing charts and graphs in Video 5. We then made those graphs interactive with slicers in Video 6. And now you have the finishing touches!

____________________________

Chapters

0:00 - Intro, recap & overview
2:02 - Design Intro explainer sheet
4:00 - Navigation buttons & links
7:01 - Insert & format text boxes
9:20 - Fit on 1 page, set page margins, PDF
10:27 - Make worksheet look less like Excel!
10:45 - Hide sheets & protect
11:36 - Create handover instructions
15:10 - Save & share dashboard
15:40 - Recap, final tip & close

_________________


I hope you find this helpful. Let me know your thoughts and questions in the comments. See my other videos or blogs with more tips:

https://excelattheoffice.com/blog

Kind Regards,
Adrian