This article explains how to create a report in Microsoft Excel using key skills like creating basic charts and tables, creating pivot tables, and printing the report.

Naming a cell or a range of cells in Excel is straightforward. Simply select the cell or range you want to name, and replace ...

If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.

Microsoft Excel can add charts to your workbook in two forms - chart sheets and embedded charts. Chart sheets set charts as new sheets within the workbook. They work well when you created the ...

If you want to add labels to the bubbles in an Excel bubble chart, you have to do it after you create the chart. Mary Ann Richardson explains what you need to do to add a data label to each bubble.

Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet.

Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.

With Excel's versatile chart tool, putting together data visualizations is as easy as pie (groan).