This How To….Excel video shows you the steps for using Microsoft Excel’s table feature. This feature works in Microsoft Excel 2007, 2010, 2013 and Excel for Mac 2011. The Excel table feature allows you to quickly sort, filter and analyze your data. This instructional style video shows the features and benefits of converting your data into a table and how to use the features.
The details on how to use the feature are shown in the video but for general reference here are the basic steps:
1 – Select your data range first (or put your curser in the middle of the range)
2 – Insert, Table (location of command shown in video)
3 – Click the drop down arrows to sort, filter and analyze