Excel will present a few options for you to consider. In our example, Excel offers to create 10 different pivot tables that take a look at a number of different angles on our sales data.

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

A Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

Want to highlight Cell or Row if a checkbox is selected? We show you hHow to highlight a Cell or Row with a Checkbox in Excel.

Excel for the web supports both PivotTables and PivotCharts in an existing .xlsx file. You can also create a PivotTable in Excel for the web, but you can’t group columns.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.