Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...

Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there’s a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft ...

Microsoft Excel 2013 charts are dynamic in that they automatically update when the current data changes. However, if you add a series of data points to a spreadsheet, Excel doesn't know to include ...

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...