Guerrilla Data Analysis Using Microsoft Excel

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These tips have been honed by Oz du Soleil, a former financial analyst charged with taking mainframe data and turning it into useful information quickly, and &;Mr. Excel&; himself, Bill Jelen. Topics include data quality, validation, perfectly sorting with one click, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables, and much more. This new edition has been updated for Excel 2013.

Oz du Soleil teaches Excel workshops and consults clients who have small businesses with no IT teams or sophisticated data management systems. He&;s worked with data and Excel for more than 10 years, including time spent as a financial analyst, facing issues of data quality, modeling business rules in Excel formulae, and revising reports. He lives in Chicago. Bill Jelen is the host of www.MrExcel.com, a Microsoft MVP, and writes the monthly Excel column for Strategic Finance Magazine. He is the author of 44 books about Excel. He lives in Akron, Ohio.