Description |
1 online resource (vi, 110, A1-33 pages) : illustrations |
Physical Medium |
polychrome |
Description |
text file |
Summary |
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. |
Contents |
About the Author; Acknowledgements; Table of contents; 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(Consolidate; Data(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. |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
Genre/Form |
Electronic books.
|
Other Form: |
Print version: Jelen, Bill. Guerilla data analysis using Microsoft Excel. Uniontown, OH. : Holy Macro! Books, ©2002 0972425802 (DLC) 2002117109 (OCoLC)51317255 |
ISBN |
097242587X (electronic book) |
|
9780972425872 (electronic book) |
|
9781615473199 (electronic book) |
|
161547319X (electronic book) |
|