Interactive dashboards in Google sheets

Автокөліктер мен көлік құралдары

Google Sheets allows you to create charts and choose to aggregate easily, and if you add Slicers then it can become interactive. Card visuals and Table visuals are interesting to explore as Excel doesn't have them, plus using Pivot Tables allows you to sort the charts or have crosstab analysis which can be made more visual through sparklines and conditional formatting. I cover all this in my video.
Other links:
You can download the example files here: www.xlconsulting-asia.com/you...
Sparklines in Google Sheets: • Sparklines: In cells c...
Pivot Tables in Google Sheets: • Google sheets Pivot ta...
Interactive dashboards in Excel: • Interactive dashboards...
00:00 Introduction
00:37 Create an aggregated chart
02:30 Card visuals
03:18 Pivot Tables and sorted charts
04:22 Chart only dashboard
06:09 Slicer for interactivity
11:03 Pivot table date groups
12:21 Paginated table chart
13:20 Conditional format and sparklines
14:34 Colour picker to match logo etc
16:04 Final dashboard touches
16:38 Marker 11

Пікірлер: 38

  • @gabrielvasquez6477
    @gabrielvasquez64774 ай бұрын

    This is some of the best and most useful content I've found on Google Sheets. Thanks!

  • @learnspreadsheets

    @learnspreadsheets

    4 ай бұрын

    Wow! That’s so kind 😃 glad you like it! Happy to make more sheet content 🤣

  • @sovecheasophanna
    @sovecheasophanna3 ай бұрын

    Thanks David, LOVE IT! This is very helpful. Enjoy your vidoes.

  • @learnspreadsheets

    @learnspreadsheets

    3 ай бұрын

    Thanks so much! That’s awesome 😃

  • @analystintelligence
    @analystintelligence5 ай бұрын

    This is really good!

  • @learnspreadsheets

    @learnspreadsheets

    5 ай бұрын

    Glad you find it useful 😃

  • @itskristieali
    @itskristiealiАй бұрын

    Literally the most helpful video!! Thank you!

  • @learnspreadsheets

    @learnspreadsheets

    Ай бұрын

    Glad you like it!

  • @IbrahimBashir
    @IbrahimBashir7 күн бұрын

    Great video! I have definitely found most of the charts I wanted to use all in one video. Thanks for this.

  • @learnspreadsheets

    @learnspreadsheets

    2 күн бұрын

    Nice one!

  • @mfourmanagement9440
    @mfourmanagement94405 ай бұрын

    Awesome Man!!!!!!

  • @learnspreadsheets

    @learnspreadsheets

    5 ай бұрын

    Haha what a great emoji! Glad you like that video 😃

  • @Tigrenocchek
    @Tigrenocchek21 күн бұрын

    Very usefull information, thank you for this video!

  • @learnspreadsheets

    @learnspreadsheets

    2 күн бұрын

    Ya thanks!

  • @mitooquerer
    @mitooquerer6 күн бұрын

    Thanks! Just what I was looking for. 😊

  • @learnspreadsheets

    @learnspreadsheets

    2 күн бұрын

    Thanks for saying that - very kind!

  • @nerlyherrera4433
    @nerlyherrera44332 ай бұрын

    I'm pretty new with sheets but was tasked to make a dashboard, and man, I was banging my head against the wall because I could NOT figure out why my slicers weren't affecting the chart, THANK YOU!!

  • @learnspreadsheets

    @learnspreadsheets

    2 ай бұрын

    Aww wow thanks for the kind words, glad it helped and the slicers work now!

  • @user-mw4wv2wn7h
    @user-mw4wv2wn7h5 ай бұрын

    THANKS

  • @learnspreadsheets

    @learnspreadsheets

    5 ай бұрын

    Glad you like it!

  • @masadi1980
    @masadi19806 ай бұрын

    thanks

  • @learnspreadsheets

    @learnspreadsheets

    6 ай бұрын

    No worries!

  • @mycafalcunaya876
    @mycafalcunaya8764 ай бұрын

    Hi, how to keep the charts in position when using slicer? Whenever I use slicer the charts I made keeps on being a mess again

  • @learnspreadsheets

    @learnspreadsheets

    4 ай бұрын

    That can be annoying & I’m not sure how to fix sorry, excel does that too

  • @Awahab44
    @Awahab445 ай бұрын

    Thanks For teaching sir... How you are showing this whole project in full screen even in 150%zoom 🤯 🤷‍♂️. GIVE TRICKS SIR

  • @learnspreadsheets

    @learnspreadsheets

    4 ай бұрын

    Hahaha! F11 makes a browser fill screen & windows key + will zoom in!

  • @otappiah
    @otappiah2 ай бұрын

    Hi. This video is really easy to understand. The link doesn't seem to work for me, is there another way I get access to the files?

  • @learnspreadsheets

    @learnspreadsheets

    2 ай бұрын

    Hi, thanks for pointing it out, there was an error with the file download site. You can get it from this link, let me know if there are any issues: xlconsultingasia.sharepoint.com/:x:/s/Blogging/EerDGBHZRz9FrNWcenMOwEgBv2sn449-3pn_56O3CkAriQ?e=RTXEa2

  • @otappiah

    @otappiah

    2 ай бұрын

    @@learnspreadsheets I can access it now. Thanks

  • @safamoh1558
    @safamoh15582 ай бұрын

    thank you for this video . I could not download the data to practice .

  • @learnspreadsheets

    @learnspreadsheets

    2 ай бұрын

    Hi, sorry there was an error with the file download. You can get it from this link, let me know if there are any issues: xlconsultingasia.sharepoint.com/:x:/s/Blogging/EerDGBHZRz9FrNWcenMOwEgBv2sn449-3pn_56O3CkAriQ?e=RTXEa2

  • @catedoge3206
    @catedoge32065 ай бұрын

    yh

  • @learnspreadsheets

    @learnspreadsheets

    4 ай бұрын

    Yup

  • @JoseAntonioMorato
    @JoseAntonioMorato7 ай бұрын

    You make the example file available for download, but the difficult part is knowing what it is among a bunch of files stored on YT public files. There is no file named "Interactive dashboards".

  • @learnspreadsheets

    @learnspreadsheets

    7 ай бұрын

    Hi sorry about that, it should be there now in the part for Google files: www.xlconsulting-asia.com/youtube-files.html

  • @solooutvlog
    @solooutvlog4 ай бұрын

    How to show charts when freez a row .it disapear

  • @learnspreadsheets

    @learnspreadsheets

    4 ай бұрын

    Freeze panes shouldn’t affect chart ranges so I’m not sure what you mean sorry

Келесі