Guerilla Data Analysis Using Microsoft Excel
Elsewhere US$38.99 US$29.59 Save US$9.40 (24%)
Free Shipping Worldwide
Ships from UK supplier
Available as an e-Gift
|Format:||Paperback / softback, 110 pages|
|Other Information: ||illustrations|
|Published In: ||United States, 01 August 2003|
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
About the Author
Bill Jelen is the principal of MrExcel.com, a leading Excel web site. He provides custom Excel and Access applications for hundreds of clients and is the author of "Mr Excel on Excel." He lives in Akron, Ohio.
|Publisher: ||Holy Macro! Books|
|Dimensions: ||27.97 x 21.62 x 0.81 centimeters (0.42 kg)|