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

Course Using advanced functions in Excel 365 (2024)
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course CompTIA Data+: Data Acquisition & Cleansing
Rating 4.6 of 13 users Rating 4.6 of 13 users (13)

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 Official Google Cloud Certified Associate Cloud Engineer Study Guide
Book Corporate Finance for Dummies