This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Use Easy-XL for Data Wrangling
Problem: I regularly have to use the techniques in this book to compare lists, split data, do VLOOKUPs. I hate Excel. It is too intimidating.
Strategy: Check out the Easy-XL utility from MrExcel. It seems that every Excel book author has a suite of utilities these days, but Easy-XL is not designed to help you format your worksheet. It is designed to help you do the hard data analysis tasks with ease.