Using UNIQUE and FILTER functions, you can avoid PIVOT TABLES.<br />Check these quick tricks<br /><br /><br />Excel magic trick with UNIQUE and FILTER to avoid PIVOT TABLE<br /><br /><br />#exceltrick #excel2020 #excelshortcut<br />~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~- <br /> <br />Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. <br />Subscribe to my channel at <a href="http://www.youtube.com/user/excelissimple?sub_confirmation=1" target="_blank" rel="nofollow">http://www.youtube.com/user/excelissimple?sub_confirmation=1</a> <br />Want some focused playlists. Click here and lean back: <br />The IF formula explained: <a href="https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe" target="_blank" rel="nofollow">https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe</a> <br />All excel formulas in one place: <a href="https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401" target="_blank" rel="nofollow">https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401</a> <br />Excel basics if you have just started: <a href="https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76" target="_blank" rel="nofollow">https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76</a> <br /> <br /> <br />Share, like and post any questions on the videos<br />...<br /><a href="https://www.youtube.com/watch?v=rkY7POHg-kY" target="_blank" rel="nofollow">https://www.youtube.com/watch?v=rkY7POHg-kY</a>