Got a whole bunch of data in a row or column that needs to be sorted alphabetically? You can do it with just a few clicks in Excel.

Discover how Python in Excel transforms data analysis with advanced features. Is it worth the hype? Find out if it’s right for your workflow.

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

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

For instance, PyXLL-Jupyter can integrate data from your Excel workbook into a Jupyter Notebook using a single command. This enables you to analyze massive datasets quickly.

Copy, Move, and Link Cell Elements There are many ways to copy and move data, duplicate forming, and link cells together in Microsoft Excel. For example, you could use Paste Special, Format ...