Overview

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These tips have been honed by Oz du Soleil, a former financial analyst charged with taking mainframe data and turning it into useful information quickly, and ""Mr. Excel"" himself, Bill Jelen. Topics include data quality, validation, perfectly sorting with one click, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables, and much more. This new edition has been updated for Excel 2013.

Full Product Details

9781615470334

Table of Contents

Reviews

Author Information

Oz du Soleil teaches Excel workshops and consults clients who have small businesses with no IT teams or sophisticated data management systems. He's worked with data and Excel for more than 10 years, including time spent as a financial analyst, facing issues of data quality, modeling business rules in Excel formulae, and revising reports. He lives in Chicago.Bill Jelenis the host of www.MrExcel.com, a Microsoft MVP, and writes the monthly Excel column forStrategic Finance Magazine. He is the author of 44 books about Excel. He lives in Akron, Ohio.

Tab Content 6

Customer Reviews

Recent Reviews

Countries Available