Pivot Tables and Charts: Summarizing and Visualizing Data Pivot tables are one of Excel’s most powerful tools for summarizing and organizing data into meaningful categories. They allow you to ...

Excel is also where you can turn tables into charts and format them to look exactly how you wish before pasting them into Word using the same methods outlined in this guide.

Select Analyze Data at the top and Excel automatically selects the table on your sheet. You can check suggested pivot tables and charts from the side menu. Select the button below to insert them.