Guerrilla data analysis using Microsoft Excel: conquering crap data and Excel skirmishes
"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, tab…
Read More ↓Title Statements
- Full title :Guerrilla data analysis using Microsoft Excel : conquering crap data and Excel skirmishes / Oz du Soleil & Bill Jelen.
Summary
"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."--
Read More ↓Edition Statements
- Publication Date:2022
- Edition:3rd edition
Publication Statements
- Publisher(s):Holy Macro! Books
- Place of Publication:Merritt Island, FL
- Language:eng
- Publication Date:2022
Notes
Includes index.
The Physical Object
- Description:1 online resource : : color illustrations
Edition Identifiers
- ISBN:9781615471607, 161547160X
- oclc:on1328221135
- LC Classification:HF5548.4.M523
- Dewey Decimal:005.54
Subjects
Writers
No reviews yet. Be the first to rate this work.
Related Works
more →
Excel 2019 for environmental sciences statistics: a guide to solving practical problems
Quirk, Thomas J
Excel 2019 for environmental sciences statistics: a guide to solving practical problems
Quirk, Thomas J
Rate & Review