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.
Counted ratings come from accounts older than 7 days and were made on or after publication. Finished readers weigh ×1.0. Readers who have not finished yet weigh ×0.5. Did-not-finish ratings are shown but not counted.
Editions
8 editions
Ebook · English · 2004
Holy Macro! Books · 108 pages · 9780972425872
Other · English · 2024
Guerrilla Data Analysis Using Microsoft Excel
de Gruyter GmbH, Walter · 277 pages · 9781836644026