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