Month Keys with EOMONTH: Group Any Date into Its Month
This lesson is part of the course
In this lesson
You turn Larkspur Coffee Co.'s order dates into month keys and month starts, then total sales and count orders per month with SUMIFS and COUNTIFS.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Month Keys with EOMONTH: Group Any Date into Its Month Locked
- Month-to-Date (MTD): SUMIFS Between the Month Start and the Report Date Locked
- Year-to-Date (YTD) and Prior-Year YTD with SUMIFS and EDATE Locked
- Year-over-Year (YoY): Variance, Growth % and the "New" Case Locked
- Rolling 12 Months: Moving Totals, Averages and a Trend Chart Locked
- Fiscal Years Starting in April: FY, Fiscal Quarter and Fiscal YTD Locked
- Like-for-Like (Same-Store) Growth with COUNTIFS Flags Locked
- Capstone: KPI Tiles (Month, YTD, YoY, R12) and a Current vs Prior Year Chart Locked