Excel 2016 training video on how to use the Subtotals feature which is used to quickly calculate rows of related data by inserting subtotals and totals.
30th Aug 2017
Excel 2016 tutorial on how to add, average or count up a range of cells in a column (field) of records in a list or database, based upon the criteria you specify in a mini or sub database using the DSUM, DAVERAGE and DCOUNT functions in this Excel 2016 training video. …
24th Aug 2017
Excel 2016 tutorial on how to place conditions, or criteria on what you want to sum or add up, count up, or average out by using the SUMIF, COUNTIF and AVERAGEIF as well as the plural SUMIFs, COUNTIFs and AVERAGEIFs functions respectively. …
11th Aug 2017