7 Excel Dashboard Tools & Tips for the Quick Access Toolbar

In this video, you can learn several tips and shortcuts for working with charts, slicers, and shapes by adding handy buttons to the Quick Access Toolbar.

0:00 1. Select Objects Tool
2:40 2. Align Object Features
4:00 3. The Selection Pane
5:29 4. Bring to Front/Send to Back
6:53 5. Change Font, Fill, and Line Color
8:02 6. Snap to Shape / Snap to Grid
10:36 7. Toggling the Gridlines On/Off

Related Videos:

#MsExcel #ExcelCampus

[skigglystars]

It's tutorials just like this one that remind me to express sincere gratitude to you for the time and effort it took to share it with the community.

[teoxengineer]

Thank you Jon for those tips.
Selection pane shortcut is Alt+F10 (hide and unhide)
Hiding and unhiding objects shortcut is CTRL+6
✋

[juliaahulu]

So clear and easy to follow, thankyou for your time.

[conradhaynes]

Another superb presentation - once again thank you.

[ElTigreFIME]

I’m speechless…..just amazing video!
Thanks Jon for sharing with us. Definitely you are one of the best Excel pro teachers!

[darrylmorgan]

Cool Tutorial And Some Really Great Tips...Thank You Jon :)

[wayneedmondson]

Great tips! Thanks for demonstrating Jon. Thumbs up!!

[LuisCarlosChavez]

Thanks for sharing! Amazing and very helpful video for people like me just starting out with Dashboards. 🙌🤝🙏💪💪💪💪

[joar]

This is an excellent video and the first I watched from this channel. Precise information, a good voice to listen to and a good bonus information at the end (export Quick Access Toolbar). Since I am confronted with a lot of excel work in my new project as a freelancer, more than usual, I will look up more videos and I am very curious to learn more about creating dashboards. Thank you.

[GrainneDuggan_Excel]

Thanks for these handy dashboard QAT tips and also for the Export technique! Implementing now ⚙

[reenakuruvilla]

Hi Jon, Thank you helping us out with Excel. I managed to learn Index/match after going through your video. if possible, can you please do a video on Indirect function.

[BouncewithLife_]

Yah! Great Video..specially the last tip i.e. import /export

[twitchyfingerss]

My favorite is New Document. Gets me into a sandbox for quick data cleans that don't need to be saved. Maybe I just need certain rows of a table to put into an email but I want them transposed with a different font and number format. New Document > paste values, transpose > apply borders, font, and custom number format > paste result into email > close the New Document without saving

[nadermounir]

An excellent tutorial John this is great information. Thank you very much for your hard work and sharing your knowledge with us. By the way, the song played on your videos is nice. From where did u get it ?

[time.burnspwks]

Is the export/import only for the quick access, or does it also grab any customized ribbon?

[dhirajsinghchauhan]

Hi,
Hope you are doing well.

Please Help ....
I have date format 02-03-2022 (want to change cell format date to text)

1. if i change manually by text to column, i get 02-03-2022 (DD-MM-YYYY)
2. If i use text to column by vba code, i get 2-3-2022 (D-M-YYYY)

Please help, how to fix

[brianmoyer]

You have very nice white teeth, sir. Thank you for the video.