YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com
Learn how to create a Top 5 Chart (or a Pareto Chart) that automatically updates and sorts data (descending) as you enter the data in Excel.
In this video you will use the SUM formula, the COUNTIF formula, the MATCH formula, the INDEX formula, the RANK.EQ formula, as well as a Bar Chart, 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 common Excel challenges from our viewers and subscribers.
Thank you for watching.
Check out some of our previous videos in the links below:
* TECH-008 - Create a chart with stacked pictures
• TECH-008 - Create a ba...
* TECH-007 - Create a survey in Excel using option buttons (a.k.a. radio buttons)
• TECH-007 - Create a su...
* TECH-006 - Create a list that automatically sorts alphabetically as you enter data
• TECH-006 - Create a li...
Негізгі бет TECH-009 - Create a TOP 5 Chart (Pareto) in Excel that updates and sorts automatically
Пікірлер: 19