Guerrilla Data Analysis Using Microsoft Excel
Published on 1. April 2015
978-1-61547-343-4 (ISBN)
Description
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 "e;Mr. Excel"e; 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.
More details
Person
Oz du Soleil is a consultant based in Chicago. He's worked with data and Excel for more than 10 years, including time spent as a Commissions Analyst, facing issues of data quality, modelling business rules in Excel formulae, and revising reports. Today, Oz teaches Excel workshops and consults clients who have small businesses with no IT teams or sophisticated data management systems. Bill Jelen is the host of www.MrExcel.com, Microsoft MVP, contributing editor for CFO.com, and writes the monthly Excel column for Strategic Finance Magazine. He is the author of 43 books about Excel.
