Excel Magic Trick 1396

PivotTable Show Values As: Running Total and % of Running Total (2 Examples)

DESCRIPTION

See how to:
(00:13) Introduction. What is a Running Total or Cumulative Frequency. What is a % Running Total
(03:10) Example 1: Grouping Integer Values for # of Transactions with a Quantity between an Lower & Upper Value
(04:25) Frequency (Count Function)
(05:20) Show Values As: Running Total, Cumulative Frequency
(05:49) Show Values As: % Running Total, % Cumulative Frequency
(06:40) Example 2: Grouping Dates to calculate Month Totals
(07:35) Add Revenue for Each Month
(08:41) Show Values As: Running Revenue Total, Cumulative Revenue Total for each Month in each Year
(09:36) Show Values As: % Running Total, % Cumulative Frequency for Month Totals within each year
(10:20) Summary

WORKBOOKS

Download “Excel Magic Trick 1391-1400” Excel-Magic-Trick-1391-1400.zip – Downloaded 93 times – 3 MB







Be the first to comment

Leave a Reply