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
Thanks for your time and sharing.....its very useful !!!
@TheExcelChallenge
6 жыл бұрын
Hello Sakda. I’m glad to hear you found the video helpful. Thanks for watching.
I feel amazed at knowing how to do this now, and it's all thanks to you :D
Thank you very much for showing this!
very useful and helpful video. thanks for sharing your knowledge!
you are a pro in Excel (Y)
@TheExcelChallenge
7 жыл бұрын
Thanks for the comment Munawar. Glad you liked the video.
Amazing. Please make more
Just amazing
Thanks!
How you made this state area column
This can be a deadly weapon for managers to track their employees performance