TECH-001 - Compare data in charts selecting values from dropdown menus

YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com
Learn how to create a spreadsheet that will allow you to quickly compare data in charts that update automatically as you select values from a dropdown menu.
In this video you will use the formula VLOOKUP, you will use VALIDATION in the form of LIST, you will create BAR CHARTS, FILL DOWN, etc. etc.
I hope this tool is something you can use in your daily routine so you get more with less effort.
If you have a challenge with Excel that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve the most common Excel challenges from our viewers and suscribers.
Thank you for watching.

Пікірлер: 12

  • @sakdaseedapol2020
    @sakdaseedapol20206 жыл бұрын

    Thanks for your time and sharing.....its very useful !!!

  • @TheExcelChallenge

    @TheExcelChallenge

    6 жыл бұрын

    Hello Sakda. I’m glad to hear you found the video helpful. Thanks for watching.

  • @rogersourm4650
    @rogersourm46505 жыл бұрын

    I feel amazed at knowing how to do this now, and it's all thanks to you :D

  • @laszlokovi4719
    @laszlokovi47195 жыл бұрын

    Thank you very much for showing this!

  • @coldsai8868
    @coldsai88684 жыл бұрын

    very useful and helpful video. thanks for sharing your knowledge!

  • @munawarhussain7878
    @munawarhussain78787 жыл бұрын

    you are a pro in Excel (Y)

  • @TheExcelChallenge

    @TheExcelChallenge

    7 жыл бұрын

    Thanks for the comment Munawar. Glad you liked the video.

  • @Steave-M
    @Steave-M5 жыл бұрын

    Amazing. Please make more

  • @SujonAhmed26
    @SujonAhmed265 жыл бұрын

    Just amazing

  • @md.rosado
    @md.rosado2 жыл бұрын

    Thanks!

  • @shubhisingh5684
    @shubhisingh56843 жыл бұрын

    How you made this state area column

  • @waquarahmad2353
    @waquarahmad2353 Жыл бұрын

    This can be a deadly weapon for managers to track their employees performance