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.

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

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.

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.

Figure B The Excel add-in inserts a chart populated with dummy data. How to connect the Excel data to the chart At this point, you’re ready to connect the chart to real data.

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.

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.