Excel for the web supports slicers, but you can’t create a custom sort list in the web version. How to add a PivotTable in Excel Let’s suppose that you track orders for t-shirt sales using the ...

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.

Step 2: To sort using one of the buttons, select your column or table. In this case, we're using the second table in the sample spreadsheet. Image used with permission by copyright holder ...

Excel 2013 makes it easy to link tables, create reports and more. News. ... Click the Create button and the Create Relationship dialog box appears. ... Sort, create filters, ...

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

Click "Insert" in Excel's ribbon. Click "Pie" in the Charts group, and click one of the "2D Pie Chart" options to create a blank chart. Right-click the chart.

And that’s it. It took all of 20 seconds to create and format a table in Excel. How to use a Total row for quick calculations. Next, you’ll add calculations to your table.