Microsoft Excel's CHOOSECOLS and CHOOSEROWS ... game drop-down list in cell B9. Next, select cell B9, and click the top half of the "Data Validation" button in the Data tab on the ribbon.

in an Excel spreadsheet ... Before clicking the second OK button to save the change, select the next data series and follow the steps mentioned here. That’s all! I hope it helps.

Here’s how to use this basic yet powerful Excel tool ... the normal view where all of the data is visible, simply click the column header button again and select Clear Filter.

Just as Excel can perform basic data analysis functions ... Click the PivotTable button and you will be asked to select the data range, the rows and columns to be included in the table.

Microsoft Excel 2010 gives you ... or "January," for which you have data. Continue down the column, entering all of your data periods into different cells. Select cell "B1" and enter the number ...

You can always get the latest data by tapping the “Refresh data” button within Excel. Microsoft has also partnered with Wolfram Alpha to take hundreds more data types and bring them into Excel ...