Excel data analysis for dummies
Harness the power of Excel to discover what your numbers are hiding Excel Data Analysis For Dummies, 2nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through the basic and not-so-basic features of Excel to help you discover the gems hidden in your rough data. From input, to analysis, to visualization, the book walks you through the steps that lead to superior data analysis.
Read More ↓Title Statements
- Full title :Excel data analysis for dummies / Stephen L. Nelson.
Summary
Harness the power of Excel to discover what your numbers are hiding Excel Data Analysis For Dummies, 2nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through the basic and not-so-basic features of Excel to help you discover the gems hidden in your rough data. From input, to analysis, to visualization, the book walks you through the steps that lead to superior data analysis.
Read More ↓Edition Statements
- Publication Date:©2014
- Edition:2nd ed
Publication Statements
- Publisher(s):Wiley
- Place of Publication:Hoboken N.J
- Language:eng
- Publication Date:©2014
Notes
Includes index.
The Physical Object
- Description:1 online resource
Edition Identifiers
- ISBN:9781118898109, 1118898109, 9781118898086, 1118898087, 1118898095, 9781118898093
- oclc:ocn877772392
- LC Classification:HF5548.4.M523 .N384 2014eb
- Dewey Decimal:005.54
Table of Contents
Contents at a Glance; Table of Contents; Introduction; About This Book; What You Can Safely Ignore; What You Shouldn't Ignore (Unless You're a Masochist); Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Beyond the Book; Where to Go from Here; Part I: Where's the Beef?; Chapter 1: Introducing Excel Tables; What Is a Table and Why Do I Care?; Building Tables; Analyzing Table Information; Chapter 2: Grabbing Data from External Sources; Getting Data the Export-Import Way; Querying External Databases and Web Page Tables; It's Sometimes a Raw Deal.
Chapter 3: Scrub-a-Dub-Dub: Cleaning DataEditing Your Imported Workbook; Cleaning Data with Text Functions; Using Validation to Keep Data Clean; Part II: PivotTables and PivotCharts; Chapter 4: Working with PivotTables; Looking at Data from Many Angles; Getting Ready to Pivot; Running the PivotTable Wizard; Fooling Around with Your Pivot Table; Customizing How Pivot Tables Work and Look; Chapter 5: Building PivotTable Formulas; Adding Another Standard Calculation; Creating Custom Calculations; Using Calculated Fields and Items; Retrieving Data from a Pivot Table.
Chapter 6: Working with PivotChartsWhy Use a Pivot C…
Subjects
Writers
More from this Series
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
Files & Downloads
-
Excel Data Analysis For Dummies -- (.epub)
EPUB · 10.5 MB · updated -
Excel Data Analysis For Dummies -- (.pdf)
PDF · 24.4 MB · updated -
Excel Data Analysis For Dummies, 2nd Edition -- (…
PDF · 27.1 MB · updated -
Excel Data Analysis for Dummies -- (.pdf)
PDF · 26.0 MB · updated
Rate & Review