[wps academy] 1.5.9 excel: subtotal function：calculate the data with the hidden value
Published 3 years ago • 1.1K plays • Length 2:34Download video MP4
Download video MP3
Similar videos
-
![[wps academy] 2.3.7 excel:use subtotal feature to do statistic](https://i.ytimg.com/vi/UDaXJAEEWuk/mqdefault.jpg)
4:36
[wps academy] 2.3.7 excel:use subtotal feature to do statistic
-
1:26
using excel's subtotal function with filters in excel
-
2:32
get the sum of filtered data in excel (using subtotal formula)
-
![[wps academy] 1.9.7 excel:use the shortcut alt = to quickly sum](https://i.ytimg.com/vi/3p8C1p62YdE/mqdefault.jpg)
1:03
[wps academy] 1.9.7 excel:use the shortcut alt = to quickly sum
-
11:46
quickly find worksheets and unhide multiple sheets using tab hound
-
10:25
how to make pivot table in excel in hindil (wps office)
-
27:19
top 10 most important excel formulas - made easy!
-
0:23
calculate subtotal in blank rows of an #excel data #shorts
-
![[wps academy] 2.9.9 excel: customize the formats to show data changes](https://i.ytimg.com/vi/-2cL9pNPxIE/mqdefault.jpg)
1:29
[wps academy] 2.9.9 excel: customize the formats to show data changes
-
![[wps academy] 1.5.8 excel: how can we use rank function](https://i.ytimg.com/vi/W5qGIOONNxU/mqdefault.jpg)
1:19
[wps academy] 1.5.8 excel: how can we use rank function
-
![[wps academy] 1.2.7 excel: the sumproduct function for quick calculation of total sales](https://i.ytimg.com/vi/A4AiuOaKOCo/mqdefault.jpg)
1:45
[wps academy] 1.2.7 excel: the sumproduct function for quick calculation of total sales
-
![[wps academy] 1.6.4 excel:how to set the calculated field of the pivot table](https://i.ytimg.com/vi/7iEzgmdPxyY/mqdefault.jpg)
1:50
[wps academy] 1.6.4 excel:how to set the calculated field of the pivot table
-
![[wps academy] 1.9.3 excel:use match function to search location information](https://i.ytimg.com/vi/9WkmFOLEQj8/mqdefault.jpg)
2:17
[wps academy] 1.9.3 excel:use match function to search location information
-
4:57
using the excel subtotal function
-
![[wps academy] 1.4.2 excel: how can we use the data validation feature](https://i.ytimg.com/vi/kh3o7itEYtc/mqdefault.jpg)
2:47
[wps academy] 1.4.2 excel: how can we use the data validation feature
-
0:49
wps office (excel): “alt =“ to get sum / total
-
![[wps academy] 1.0.0 excel: format cells locked and hidden](https://i.ytimg.com/vi/XycQ6jMi0Os/mqdefault.jpg)
1:22
[wps academy] 1.0.0 excel: format cells locked and hidden
-
![[wps academy] 3.0.3 excel: how to use the filter function](https://i.ytimg.com/vi/H3Ns3Os0zqE/mqdefault.jpg)
3:15
[wps academy] 3.0.3 excel: how to use the filter function
-
4:20
descriptive statistics using pivot tables part-1 | wps spreadsheet
-
0:40
exclude the hidden rows data & errors to get sum in microsoft excel