Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

How to Use Microsoft Word to Extract Data From Excel. Excel spreadsheets can contain many types of data, including text, calculations and charts. If you need to use any of this information in your ...

Learn how to use the new Microsoft Excel REGEX functions to easily extract, clean and format data for easy data visualization and analysis ...

Slicers are a good way to filter data in a Microsoft Excel PivotTable or PivotChart, but they take up a bit of room. By moving the buttons to the chart, you free room for more visuals.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Adobe Acrobat is the only other tool I'm aware of that can automatically extract table data from a PDF -- and it starts at $299. PDF to Excel costs zilch.