Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior. By default, Excel displays only visible data in a chart. Consequently, if you hide ...

Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data matching your specified criteria.

The VSTACK and HSTACK functions enable efficient data combination from multiple sheets while maintaining dynamic ...

One way businesses can save time and money is using Excel spreadsheets as data tables in which to store customer information, inventory details or other important data. Excel has several features that ...

Ever found yourself overwhelmed by the sheer amount of data you need to track in Excel? Tracking data across multiple Excel worksheets can be a daunting task, often leading to missed updates and ...

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...

To do that, select the Data tab, highlight the table, and click From Table/Range in the Get & Transform Data command group of ...