Swapping or moving columns around in your data set can be a fairly simple exercise. It's a simple step of cut and paste. But if you were to move or re-arranging a data set that has a lot of columns or you're working with someone that wants to see how it looks like this or that (multiple times) it becomes a burden. This video covers three ways to move columns around. The first two are using the mouse and cursor to move it around. The last example uses the newer dynamic array function called SORTBY and gives you an effective and dynamic way to swap columns around and change it effortless through multiple times.
Thursday, May 27, 2021
Sunday, May 23, 2021
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.
Thursday, May 20, 2021
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.
Subscribe to:
Posts (Atom)