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
Guerilla Data Analysis Using Microsoft Excel
โ Scribed by Jelen, Bill;Soleil, Oz Du
- Publisher
- Holy Macro! Books
- Year
- 2015
- Tongue
- English
- Edition
- 2nd edition
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
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.
โฆ Subjects
Electronic spreadsheets--Computer programs;Microsoft Excel (Computer file);Electronic spreadsheets -- Computer programs
๐ SIMILAR VOLUMES
Guerrilla Data Analysis Using Microsoft Excel: Excel Skirmishes and Conquering Crap Data Third Ed. goes beyond Excel tips & tricks and includes real world warnings and case studies.โฉWhen asked about the motivation for this book, Oz replied: โthis is for the person whoโs been thrown into the fire wit
Guerrilla Data Analysis Using Microsoft Excel: Excel Skirmishes and Conquering Crap Data Third Ed. goes beyond Excel tips & tricks and includes real world warnings and case studies.โฉWhen asked about the motivation for this book, Oz replied: โthis is for the person whoโs been thrown into the fire wit
Two of the leading Excel channels on YouTube join forces to combat bad data. 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 du Soleil during their careers run as finan
This Microsoft Forecasting & Data Analysis book is aimed at people who want to expand their knowledge into forecasting and more specialized analytical functionality offered by Microsoft Excel.
<span>With the world brimming with data, data analysis is one of the most in-demand digital skills today. Microsoftยฎ Excelยฎ remains the most popular number-crunching tool across all businesses of any size and type. This book will teach you a highly desirable combination of data analysis with Excel s