Excel Data Analysis For Dummies, 4th Edition

• Navigate and analyze complicated data
• Work with external databases, PivotTables, and PivotCharts
• Make the most of the latest features of Excel 2019

Take your Excel data-analysis skills to the next level

If you can get data into Excel, then you have a giant basket of data analysis tools at your fingertips. This book shows you how to access and use the features and techniques for organizing, manipulating, and summarizing just about anything that resides in a worksheet. So 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 Excel to use for you.

Inside...

• Work with external databases
• Start data sharing
• Get familiar with Solver
• Clean your data
• Use PivotTables and PivotCharts
• Track trends and make forecasts