Guerrilla Data Analysis Using Microsoft Excel: Overcoming Crap Data and Excel Skirmishes

by Bill Jelen, Oz du Soleil

Overview

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.

Product Details

ISBN-13:	9781615471607
Publisher:	Holy Macro! Books
Publication date:	03/01/2022
Sold by:	Barnes & Noble
Format:	eBook
Pages:	240
File size:	62 MB
Note:	This product may take a few minutes to download.

About the Author

Bill Jelen is the host of MrExcel.com and the author of 61 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel 2019 Inside Out. He has made over 80 guest appearances on TV's Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He writes the Excel column for Strategic Finance magazine. He has produced over 2200 episodes of his daily video podcast Learn Excel from MrExcel. Oz du Soleil is an Excel MVP who has been working with Excel since 2001. Oz has several Excel courses on the LinkedIn Learning platform. He's possibly best known for the dramatic and colorful Excel tutorials he posts on his Excel on Fire YouTube channel. When Oz isn't elbows-deep in the guts of a spreadsheet, he does storytelling around Portland, Oregon.