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

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.

Advanced Excel Techniques - Online Course

Advanced Excel Techniques - Online Course

January 2022

Understanding data is crucial, and the easiest place to start is with Microsoft Excel. In this guide, I've compiled advanced skills and formulas in Excel that you should know to analyze and understand your data easier and faster.

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.

Cool Excel Sh*t

Cool Excel Sh*t

March 2021

Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.

see more products »