Guerrilla Data Analysis Using Microsoft Excel

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,” and Oz do Soleil during their careers run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables and much more.

Jelen uses his combined experience and analytical ingenuity to demystify the arduous task of dealing with downloaded data. He uses real-life examples of real-life management requests, and then walks users through the maze of Excel tools and formulas.

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,” and Oz do Soleil during their careers run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables and much more.

"Using real-life examples of real-life management requests, this thorough guide walks you through the maze of Excel tools and formulas that not only cuts valuable time out of the process, but teaches you in plain English how to overcome the most common analytical obstacles." --

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, OCO 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. "

* Essential for those who know basic Excel and want to explore the full potential of the program * Teaches how to manipulate data to suit specific needs and achieve more by doing less work * Self-contained two-page lessons, featuring high-resolution screen shots and minimal text, show how to create custom functions, retrieve data from databases, use value chains, and slice and pivot information from the Web with Excel's PivotTable utility * Covers data analyzing techniques for statistical functions, financial functions, data sharing, PivotTables and PivotCharts, Solver, and BackSolver

Microsoft Excel 5.0 is a widely used spreadsheet tool and this book is an excellent reference that shows students how to maximize the use of Excel 5.0s new data analysis functions.