How-To Geek on MSN

How to use the PivotTable Fields pane in Microsoft Excel

You can create a PivotTable in Excel from an external data source, a table in your worksheet, or a pre-built data model. To ...
Hosted on MSN

How to Use the CHOOSECOLS and CHOOSEROWS Functions in Excel to Extract Data

Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula.