This cheat sheet covers 100s of functions that are critical to know as an Excel analyst. In the opening Grouping dialog box click to highlight the item you want to calculate averages based on in the By box such as Months and click the OK button. When I double-click inside the cell I see it is a formula with the AVERAGE function.
Now you will get all averages of each month in the Pivot Table see below screenshots.
Compound Quarterly Growth Rate CQGR in Excel is rather easy to calculate. Press ENTER Step 4. If we scroll to the right we can see that we have a Date field that shows the year month and day of every. If your projected revenue data is off-set copy and paste the columns until they line up.