Excel Shortcut: For Filter

Filter is being when your excel sheet have long list of data. You may use the filter to automatically show the data that you needed. Below is a sample of how Filter is applied

















Subtotal:

Subtotal is use when Filter is applied in excel sheet. Below is the step by step process to use the subtotal SUM.








SUBTOTAL(any of the number below, range of data)

1---average
2---count
3---countA
4---Max
5---min
6---produc
7---stdev
8---stdevp
9---sum
10---var
11---varp