TECH-001 - Compare data in charts selecting values from dropdown menus
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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.
Видео TECH-001 - Compare data in charts selecting values from dropdown menus канала The Excel Challenge
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.
Видео TECH-001 - Compare data in charts selecting values from dropdown menus канала The Excel Challenge
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
TECH-002 - Find a value in intersecting rows and columns in ExcelSwitching Tables and Charts Using a Drop ListExcel Dynamic Chart with Drop down List (column graph with average line)Use a Dropdown to Switch between ChartsTECH-014 - Create a progress tracker with check boxes in ExcelTECH-003 - Insert images in comments in ExcelTECH-005 - Create a quick and simple Time Line (Gantt Chart) in ExcelEAF #68 - Use Smallest Worthwhile Change in your Fitness Testing ReportsTECH-011 - Create a calendar in Excel that automatically updates colors by event categoryTECH-012 - Create links in Excel to places within your spreadsheet and outside of your spreadsheetAmazing Dashboard with Balloon Charts in ExcelTECH-006 - Create a list that automatically sorts data (alphabetically) as you enter data in ExcelTECH-018 - Compare Estimated Time vs Actual Time in a Time Line (Gantt Chart) in ExcelTECH-009 - Create a TOP 5 Chart (Pareto) in Excel that updates and sorts automaticallyTECH-007 - Create a survey in Excel using Option Buttons (a.k.a. Radio Buttons)Quick Excel Trick to Unstack Data from one Column to Multiple ColumnsExcel Sort Data (by Value, Color, Icon, Own List) & How to UnsortMIS Report in Excel Progress ChartHighlight Blank and Non Blank Cells using Conditional FormattingTECH-013 - Create a bar chart with conditional formatting in Excel