Conditional Counting

An Excel file that teaches how to perform Conditional Counting operation.

Excel Format: Conditional Counting

Time series are being cleaned. Breakdowns are being sliced with slicers. Target lines are being added. Moving averages are being calculated. Axes are being adjusted for readability. A suitable theme is being applied to the dashboard.

Hope it is useful.