Aggregate Function
This video describes one of the very useful functions of Ms Excel which will enable you to speed up your analysis of different datasets.
Excel Carols is here with a very useful formula which you might need if you're dealing with a sheet full of numbers or trying to analyze finances and many such instances. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.
Following is the syntax for the AGGREGATE function
Reference Form : AGGREGATE(function_num, options, ref1, [ref2], …)
Array Form : AGGREGATE(function_num, options, array, [k])
Timestamp -
Sum Formula doesn't ignore errors - 00:35
Entering Aggregate Formula - 0:59
Subtotal Formula - 1:20
Advantage of Aggregate Formula - 2:05
Modifying the Aggregate Formula to make it dynamic - 2:22
Keyboard Shortcut to apply Filter - 3:05
Application of Aggregate Formula - 3:20
Average using Aggregate Formula - 3:53
Please like and share the video if you find it useful. Excel Carols is always looking for scope of improvements, so please mention your feedback in the comments section below. In case, you want to learn about any other feature of Ms Excel, please mention that too in the comments section. Don't forget to subscribe to the channel and press the bell icon in order to get all the notifications.
Please follow the instagram handle in order to get all the updates : https://instagram.com/excelcarols?utm...
#ExcelCarols #MsExcel #ExcelShortcuts #KeyboardShortcuts #ExcelOptions #MsExcelOptions