Extract Data from a Corrupt Workbook in Excel 2007 - Excel tutorial

Category: Excel tutorials > Macros - Difficulty:

Sometimes we (all) make mistakes or things change. If you have a spreadsheet designed and you forgot to include some important information, you can insert a column into an existing spreadsheet.

These text functions give you the ability to to extract certain segments of a cell (normally text). Useful if only part of a cell's text contains the information you want..

The ISERROR function allows you to test whether a cell has generated an error message. This is particularly useful for division by zero (#DIV/0!) errors and is often combined with an IF statement to provide an alternate action if an error is generated.

If XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into Excel directly, tell Excel how you want to present it, and work with the data through maps.

Pivot tables allow you to report on vast sums of information in a quick and efficient manner. Probably Excels most valuable tool.