Excel Data Analysis For Dummies, 4th Edition

Excel Data Analysis For Dummies, 4th Edition Front Cover
0 Reviews
352 pages

Book Description

Take Excel to the next level

Excel is the world’s leading spreadsheet application. It’s a key module in Microsoft Office—the number-one productivity suite—and it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other elements to present complex data in an easy-to-understand format.

Excel Data Analysis explains in depth how to use Excel as a tool for analyzing sets. In no time, you’ll discover how to mine and analyze critical data in order to make more informed business decisions.

  • Work with external databases, PivotTables, and Pivot Charts
  • Use Excel for statistical and and data sharing
  • Get familiar with Solver
  • Use the Small Business Finance

If you’re familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting it to use for you.

Table of Contents

Part 1: Getting Started with Data Analysis
Chapter 1: Learning Basic Data-Analysis Techniques
Chapter 2: Working with Data-Analysis Tools
Chapter 3: Introducing Excel Tables
Chapter 4: Grabbing Data from External Sources
Chapter 5: Scrub-a-Dub-Dub: Cleaning Data
Chapter 6: Analyzing Table Data with Functions

Part 2: Analyzing Data with PivotTables and PivotCharts
Chapter 7: Creating and Using PivotTables
Chapter 8: Performing PivotTable Calculations
Chapter 9: Building PivotCharts

Part 3: Discovering Advanced Data Analysis Tools
Chapter 10: Tracking Trends and Making Forecasts
Chapter 11: Analyzing Data with Statistics
Chapter 12: Analyzing Data with Descriptive Statistics
Chapter 13: Analyzing Data with Inferential Statistics

Part 4: The Part of Tens
Chapter 14: Ten Things You Ought to Know about Statistics
Chapter 15: Ten Ways to Analyze Financial Data
Chapter 16: Ten Ways to Raise Your PivotTable Game

Appendix: Glossary of Data Analysis and Excel Terms

Book Details

  • Title: Excel Data Analysis For Dummies, 4th Edition
  • Author:
  • Length: 352 pages
  • Edition: 4
  • Language: English
  • Publisher:
  • Publication Date: 2018-11-13
  • ISBN-10: 1119518164
  • ISBN-13: 9781119518167