Excel Data Analysis for Dummies, 4th Edition
- 4h 57m
- Paul McFedries
- John Wiley & Sons (US)
- 2019
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.
About the Author
Paul McFedries is the president of Logophilia Limited, a technical writing company, and has worked with computers large and small since 1975. Although now primarily a writer, Paul has worked as a programmer, consultant, database developer, and website developer. Paul has written more than 90 books that have sold over four million copies worldwide.
In this Book
-
Introduction
-
Learning Basic Data-Analysis Techniques
-
Working with Data-Analysis Tools
-
Introducing Excel Tables
-
Grabbing Data from External Sources
-
Scrub-a-Dub-Dub—Cleaning Data
-
Analyzing Table Data with Functions
-
Creating and Using PivotTables
-
Performing PivotTable Calculations
-
Building PivotCharts
-
Tracking Trends and Making Forecasts
-
Analyzing Data with Statistics
-
Analyzing Data with Descriptive Statistics
-
Analyzing Data with Inferential Statistics
-
Ten Things You Ought to Know about Statistics
-
Ten Ways to Analyze Financial Data
-
Ten Ways to Raise Your PivotTable Game
