This article explains how to create a report in Microsoft Excel, using key skills such as creating basic charts and tables, creating pivot tables, and printing the report. The information in this article applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel for Mac.

Reporting usually means gathering information and presenting it all in one sheet that serves as the report sheet for all the information. These report sheets should be formatted in such a way that they are also easy to print.

One of the most used tools in Excel to create reports are the chart and table tools. To create a chart in an Excel report sheet:

Select Insert from the menu, and in the Charts group, select the type of chart you want to add to the report sheet.