Guerrilla Data Analysis Using Microsoft Excel

Bill Jelen, Oz du Soleil

ISBN 10: 1615470336 / ISBN 13: 9781615470334

Published by Holy Macro! Books, US, 2015

About this Item

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.

Seller Inventory # LU-9781615470334

Bibliographic Details

• Title: Guerrilla Data Analysis Using Microsoft Excel
• Publisher: Holy Macro! Books, US
• Publication Date: 2015
• Language: English
• ISBN 10: 1615470336
• ISBN 13: 9781615470334
• Binding: Paperback
• Edition: Second edition.
• Condition: New
• Weight: 376 grams

About this title

Synopsis

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.

About the Author

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.