Have you heard of Power Query in Microsoft Excel but always thought that it's only intended for Excel experts? Let me stop ...

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, ...