Guerilla Data Analysis Using Microsoft Excel

Overview

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, “MrExcel,” and Oz do Soleil during their careers run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables and much more.

Author Biography

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.