Excel data analysis for dummies
Excel is the number-one spreadsheet application, with ever-expanding capabilities. If you're only using it to balance the books, you're missing out on a host of functions that can benefit your business or personal finances by uncovering trends and other important information hidden within the numbers. Excel Data Analysis For Dummies, 2nd Edition eliminates the need for advanced statistics or analysis courses by allowing you to harness the full power of Excel to do the heavy lifting for you. Thi…
Read More ↓Title Statements
- Full title :Excel data analysis for dummies / Stephen L. Nelson.
Summary
Excel is the number-one spreadsheet application, with ever-expanding capabilities. If you're only using it to balance the books, you're missing out on a host of functions that can benefit your business or personal finances by uncovering trends and other important information hidden within the numbers. Excel Data Analysis For Dummies, 2nd Edition eliminates the need for advanced statistics or analysis courses by allowing you to harness the full power of Excel to do the heavy lifting for you. This 2nd Edition is fully updated to include information about Excel's latest features, making it a your go-to Excel guide for data analysis.
Read More ↓Edition Statements
- Publication Date:2014
- Edition:2nd edition
Publication Statements
- Publisher(s):John Wiley & Sons
- Place of Publication:Hoboken
- Language:eng
- Publication Date:2014
Notes
Previous edition: 2002.
Includes index.
The Physical Object
- Description:xii, 346 pages : : illustrations ; : 24 cm.
Edition Identifiers
- ISBN:9781118898093, 1118898095
- oclc:ocn874930523
- LC Classification:HF5548.4.M523
- Dewey Decimal:005.54
Table of Contents
Machine generated contents note: 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 -- pt. I Where's the Beef? -- pt. II PivotTables and PivotCharts -- pt. III Advanced Tools -- pt. IV The Part of Tens -- Icons Used in This Book -- Beyond the Book -- Where to Go from Here -- pt. I Where's the Beef? -- ch. 1 Introducing Excel Tables -- What Is a Table and Why Do I Care? -- Building Tables -- Exporting from a database -- Building a table the hard way -- Building a table the semi-hard way -- Analyzing Table Information -- Simple statistics -- Sorting table records -- Using AutoFilter on a table -- Undoing a filter -- Turning off filter -- Using the custom AutoFilter -- Filtering a filtered table -- Using advanced filtering -- ch. 2 Grabbing Data from External Sources -- Getting Data the Export-Import Way -- Exporting: The first step -- Importing: The second step (if necessary).
Contents note continued: Querying External Databases and Web Page Tables -- Running a web query -- Importing a database table -- Querying an external database -- It's Sometimes a Raw Deal -- ch. 3 Scrub-a-…
Subjects
Writers
More from this Series
No reviews yet. Be the first to rate this work.
Related Works
more →
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