MrExcel.com - Your One Stop for Excel Tips & Solutions

Forecast Data with Seasonality

May 19, 2022 - by Bill Jelen

Forecast Data with Seasonality

Problem: Straight-line forecasting won’t work because our sales are seasonal. We sell more near the Christmas holiday and less in the summer.

Strategy: Excel 2016 introduced a new Forecast Sheet command. Select your data with dates and sales. From the Data tab, choose Forecast Sheet. Excel will analyze your data, look for seasonality and produce new cells showing a future forecast and a chart with a confidence interval. The new rows will use new functions such as FORECAST.ETS and FORECAST.ETS.CONFINT.

continue reading »

More Reading

Calculate a Trendline Forecast

Calculate a Trendline Forecast »

May 18, 2022 - by Bill Jelen

I have monthly historical sales data. I want to predict future sales by month.

Generate Random Without Repeats

Generate Random Without Repeats »

May 17, 2022 - by Bill Jelen

I want Excel to generate numbers for the lottery. Once a number is chosen, I don’t want that number to appear again. Using RANDBETWEEN, it is possible to get duplicates.

Play Dice Games with Excel

Play Dice Games with Excel »

May 16, 2022 - by Bill Jelen

My Monopoly set is missing the dice. How can I create a spreadsheet that will simulate randomly rolling two dice?

read more articles »

Featured Products

Analyzing Data With Pivot Tables in Excel - Online Course

Analyzing Data With Pivot Tables in Excel - Online Course

January 2022

Bill Jelen has rolled all of his favorite Excel Pivot Table tips and techniques into a new guide on the Retrieve platform.

Continuing Financial Modelling

Continuing Financial Modelling

November 2020

You wait for one decent Financial Modelling book to come out and then two come along at once. This edition is aimed at those who wish to advance their knowledge and expertise in financial modelling by addressing common problems that occur day to day in the world of business / decision analyses, forecasting, and valuations.

Supercharge Power BI - 3rd Edition

Supercharge Power BI - 3rd Edition

February 2021

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.

Excel Dynamic Arrays Straight to the Point 2nd Edition

Excel Dynamic Arrays Straight to the Point 2nd Edition

January 2020

Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.

see more products »