A treemap chart provides a hierarchical view of data and makes it easy to spot patterns. Learn how to create a treemap chart in Excel.

How to Subset Data in Excel. 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 ...

How to Create a BOM Using MS Excel. Tree diagrams use graphics to indicate the materials comprising a project or product and the relationships between those materials. A bill of materials, or BOM ...

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

When collaborating in Excel, sometimes the collaboration can be distracting. Here's how to make a static image so you can do your own work without interruption.

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.