Excel Data Analysis For Dummies,4th Edition

Excel Data Analysis For Dummies (For Dummies (Computer/Tech))
Authors: Paul McFedries
ISBN-10 书号: 1119518164
ISBN-13 书号: 9781119518167
Edition 版本: 4
Publisher Finelybook 出版日期: 2018-11-13
pages 页数: 352 pages
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 graphical elements to present complex data in an easy-to-understand format.
Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data 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 financial functions and data sharing
Get familiar with Solver
Use the Small Business Finance Manager
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.
Contents
Introduction
Part 1: Getting Started with Data Analysis
tChapter 1: Learning Basic Data-Analysis Techniques
Chapter 2: Working with Data-Analysis Tools
+Chapter 3: Introducing Excel Tables
4Chapter4: 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
tChapter 8: Performing PivotTable Calculations
tChapter 9: Building PivotCharts
Part 3: Discovering Advanced Data Analysis Tools
4Chapter 10: Tracking Trends and Making Forecasts
+Chapter 11: Analyzing Data with Statistics
+Chapter 12: Analyzing Data with Descriptive Statistics
4Chapter 13: Analyzing Data with Inferential Statistics
Part 4: The Part of Tens
tChapter 14: Ten Things You Ought to Know about Statistics
Chapter 15: Ten Ways to Analyze Financial Data
+Chapter 16: Ten Ways to Raise Your PivofTable Game
AppendixGlossary of Data Analysis and Excel Terms
Index
Author Bio
Connect with Dummies
End User License Agreement