Random List from Another Table - RAND() or RANDARRAY

If you wanted to sort a list in random order there a many ways this can be done in excel. If you have Office 365 the new dynamic array function of RANDARRAY combined with SORTBY provide a quick way to do this. If you don't have O365, then using the RAND() function along with the sort capability will give you this output. This video will also cover the detail on how the SORTBY and RANARRAY functions works later on in the video.

Use the Forecast Sheet in Excel

Forecasting in Excel has become must easier with the Forecast Sheet feature (which became available in Excel 2016). If you wanted to do a quick forecast of sales or population data, Forecast Sheet will create a table and chart for you all in a few clicks of the mouse. It uses the Exponential Smoothing (ETS) algorithm and the note here is that it requires the timeline to be organized with a constant step between the different points (i.e., a monthly timeline with the values on the 1st of the month); so if you've got different dates, it's advised to aggregate raw detailed data to a common time series before you apply the forecast.

Use the SORT Function

New and currently only available in Office 365 is the SORT function. It's part of the dynamic array functions in Microsoft 365 Excel. Prior to the SORT function you might have had to use a combination of other functions to perform sorting, turn your range of data into a table for sorting or use the custom sort functions. However using this SORT function does give flexibility in the use of other dynamic array functions.