Creating a Microsoft SharePoint list from Microsoft Excel data is safer than sharing the entire Excel workbook.

Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and analyze your vast database in different ways.

To the left are three icons. Click Data — the one in the middle — to see the dataset. SEE: Learn how to create a date table in Power BI. Right-click the table and choose Copy Table (Figure D).

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

When the table is ready, copy it to the clipboard and paste it into Microsoft Excel, email, Google Sheets spreadsheet, etc. This can be helpful when you find some data on a webpage or image and ...