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.

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Excel can recommend pivot tables Once your dataset is ready, you have a couple of options for creating a pivot table.

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it's as easy as creating a table. In earlier versions, you'll need the formula method.

It is particularly beneficial to use data-entry forms when your data range or table has many columns. A standard data-entry form in Excel looks similar to the screenshot below. (To follow along, ...

Step by Step Instructions for Creating a Pie Chart in Excel. Whether you are preparing a proposal for a new client or presenting your annual sales forecast, pie charts provide an instant ...

After creating either a regular or pivot table, go to the "Design" tab that appears in the Excel ribbon.