Guerilla Data Analysis Using Microsoft Excel

Guerilla Data Analysis Using Microsoft Excel

by Bill Jelen
     
 

View All Available Formats & Editions

ISBN-10: 0972425802

ISBN-13: 9780972425803

Pub. Date: 09/28/2002

Publisher: Holy Macro! Books


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

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,” 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.

Product Details

ISBN-13:
9780972425803
Publisher:
Holy Macro! Books
Publication date:
09/28/2002
Edition description:
New Edition
Pages:
110
Product dimensions:
8.00(w) x 10.00(h) x 0.32(d)

Table of Contents

Contents

Title Page,
Copyright Page,
About the Author,
Acknowledgements,
Foreword,
Introduction,
In the trenches,
Changing formulas to values,
Multiple customer names/single customer number,
All sorts of sorts,
Matching two lists of data,
Data [right arrow] Consolidate,
Data [right arrow] Subtotals and Go To Special,
Filtering Data,
SUMIF and COUNTIF,
The keys to the kingdom: CSE,
Pivot tables,
INDIRECT and OFFSET functions,
Remedial reading,
Introduction to Excel functions,
Appendix: Quick function reference,
Afterword,
HOLY MACRO! QUICK ORDER FORM,

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >