Ravindra BagaleCourses & study guides मराठी Track your progress

Ravi Sir's Cards › Excel

Group dates by month in a PivotTable

Revision card: Group dates by month in a PivotTable. Example data table with Revenue per month: Jan ₹700, Feb ₹300; Count of order_id in January: 2; Distinct Count in January: 1.

Revision card: Group dates by month in a PivotTable. Example data table with Revenue per month: Jan ₹700, Feb ₹300; Count of order_id in January: 2; Distinct Count in January: 1.
Card 1 of 2: Group dates by month in a PivotTable · Download PNG
Read card text

What this card says

Group dates by month in a PivotTable

Example

data table with Revenue per month: Jan ₹700, Feb ₹300; Count of order_id in January: 2; Distinct Count in January: 1

Learn this in the lesson: How to Group Dates by Month in an Excel PivotTable and Make a Monthly Revenue Pivot Chart

See all Excel revision cards