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," 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.
Table of Contents
Changing formulas to values Multiple customer names All sorts of sorts Matching 2 lists of data Filtering data SUNIF & COUNTIF CSE Pivot tables INDIRECT & OFFSET functions Remedial reading Excel functions
You can earn a 5% commission by selling Guerilla Data Analysis Using Microsoft Excel paperback book / softback on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep!
Authors/Publishers
Are you the Author/Publisher? Improve sales by submitting additional information on this title.
This item ships from and is sold by Fishpond World Ltd.