Fiscal Years Starting in April: FY, Fiscal Quarter and Fiscal YTD
This lesson is part of the subscription
The first 2 lessons of this course are free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Month Keys with EOMONTH: Group Any Date into Its MonthFree
- Month-to-Date (MTD): SUMIFS Between the Month Start and the Report DateFree
- Year-to-Date (YTD) and Prior-Year YTD with SUMIFS and EDATE Pro
- Year-over-Year (YoY): Variance, Growth % and the "New" Case Pro
- Rolling 12 Months: Moving Totals, Averages and a Trend Chart Pro
- Fiscal Years Starting in April: FY, Fiscal Quarter and Fiscal YTD Pro
- Like-for-Like (Same-Store) Growth with COUNTIFS Flags Pro
- Capstone: KPI Tiles (Month, YTD, YoY, R12) and a Current vs Prior Year Chart Pro