Formula Tab [Excel] | Complete Use in Hindi | Excel Tutorial for beginners in Hindi #excel #exceltutorial #exceltutorialforbeginners #excel_in_hindi Welcome to Computer Gyan, Excel formula tab: excel is one of the famous and popular software which is very demand-able in private sector. in this video, we will cover excel formula tab, which is one of the hard section of EXCEL Course. Watch this video and learn it very easily. Thank You. New Channel for Excel Course: https://www.youtube.com/@letsex

Data Analytics in Microsoft Excel using Dynamic Array Formulas Examples: 1. Amount sold by trader for each year. =SUM(FILTER(SALE,(YEAR(DATE)=($B32))*(NAME=C$31))) 2. Get the Total Sales by Each Trader? =SUM(CHOOSECOLS($C$31:$E$34,MATCH(C$37,$C$31:$E$31,0))) 3. Who had the first, second and third highest sales? =TAKE(SORTBY($C$37:$E$37,$C$38:$E$38,-1),1,3) | Excel Basement