Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or ...

Excel's PIVOTBY function allows you to group your figures ... you can draw insights from the result straightaway. For example, you can see that data is absent for certain sports in certain years.

The Syntax for the ROMAN function. Open Microsoft Excel. Create a table. In the cell where you want to place the result type =ROMAN(A2). A2 is the cell that contains the arabic numeral.