But spreadsheets can still be useful to generate random numbers in Excel. Random data ... Then, click the "Data" tab and click "Sort A to Z" to sort the data in order of the randomized column.

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...