For more of Webster’s Excel tips, including how to do data lookups from another worksheet using VLOOKUP(), download her PDF document My Favorite (Excel) Things 2014 and the sample spreadsheet.

In Excel 2003, choose Filter from the Data menu and then select AutoFilter. With the filter in place, display a subset. For instance, the filter in Figure C is the date November 12, which displays ...

Up-to-date information can be critical; these 4 tips will add flexibility and increase efficiency when refreshing pivot tables. Image: Getty Images/iStockphoto PivotTable objects are only as good ...

If you’re new to Microsoft Excel — or an old hand who wants to plumb Excel’s depths — our Excel tips and tricks are sure to help you increase your productivity. Read on for all the details ...