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
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Tableau For Dummies, 2nd Edition
Book Make Your Data Speak: Creating Actionable Data through Excel For Non-Technical Professionals
Course Analyzing and forecasting data in Excel 365 (2024)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Developing an AI/ML Data Strategy: The Data Analytics Maturity Model
Rating 4.6 of 260 users Rating 4.6 of 260 users (260)
Book Corporate Finance for Dummies
Course Big Data Concepts: Getting to Know Big Data
Rating 4.5 of 445 users Rating 4.5 of 445 users (445)