Can I read 30-Second Spreadsheet Hack for Forecasts on EtoBox?

30-Second Spreadsheet Hack for Forecasts by Jason is a document available to read on EtoBox.

What is 30-Second Spreadsheet Hack for Forecasts about?

Adding 4 rows beneath the monthly data with formulas to dynamically display the year, quarter, and period allows forecast data shown monthly to be easily summarized quarterly or annually. Formulas extract the year and quarter from the month, and concatenate them into a formatted quarter and year. This "tags" each row of monthly data with its period, enabling fast summarization by any time interval to present or share forecast information. The simple 30-second hack avoids manually calculating and inserting p

Author

Jason

Language

EN