Guerilla Data Analysis Using Microsoft Excel

Bill Jelen
156 pages (Fall 2002); 1.6MB download
Holy Macro! Books; ISBN: 0972425802

DESCRIPTION

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, "Mr. Excel," during his 10-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.