Two Excel Functions that makes you Expert |Subtotal and aggregate Function |Excel Malayalam Tutorial

Two Excel Functions that makes you Expert | Subtotal and aggregate Function #ExcelTutor #avtechandtravel #Subtotal #aggregate The AGGREGATE function in Excel allows applying different aggregate functions like AVERAGE, SUM, PRODUCT, COUNT, COUNTA, MAX, or MIN to a list of data, with an option to ignore hidden rows and error values. The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. 00:00 Introduction 00:11 Intro 00:28 Subtotal Function 05:04 Aggregate Function Splitting Data From Mainsheet into Multiple sheets in Excel https://youtu.be/AIitQKpAcL8 Automated Attendance Sheet in Excel for 2023 https://youtu.be/cAhNSg7O3_I 6Amazing Copy Paste Tricks in Excel | Paste Special in Excel https://youtu.be/Ffp9oSF4BRs RandBetween Function | Excel Function to create Worksheet in seconds https://youtu.be/RU64Kw7YbAs 10 Amazing Excel Tricks /Top 10 Excel Tricks https://youtu.be/wWkAv_S8Cpc How to Type Malayalam in Windows/Manglish https://youtu.be/PDiPYBH96G8 Top 8 Pivot Table Tricks https://youtu.be/dG-PEgZEHsc Top 5 Excel Secrets https://youtu.be/J3tE3cnQEoA Top Excel Printing Tips & Tricks https://youtu.be/OCp3X8bohEE Excel Tutorials playlist Link https://youtube.com/playlist?list=PLgeIgRaZLnlV3Hcsu1DVUx2Lq0bssjHt5 Microsoft Word 2019 Basic to Advanced in Malayalam https://youtube.com/playlist?list=PLgeIgRaZLnlVN6VGTA52KTk0Dm06wlc-k Microsoft Power Point Basic to Advanced. https://youtube.com/playlist?list=PLgeIgRaZLnlUjyOIyk6o2CLkUPPBkIJPJ Outlook 2019 Basic to Advanced https://youtube.com/playlist?list=PLgeIgRaZLnlVZBXttSXVf8YdjT7bikPin google forms https://youtube.com/playlist?list=PLgeIgRaZLnlV59snFoTb6MUXM7QoNxpw8 Macros in Excel https://youtube.com/playlist?list=PLgeIgRaZLnlV59snFoTb6MUXM7QoNxpw8