Excel data analysis for dummies
McFedries, Paul
Excel data analysis for dummies Microsoft Excel data analysis for dummies by Paul McFedries - 4th edition - John Wiley & Sons, Inc. c2019 - xi, 338 p. illustrations, charts - For dummies .
Includes index
Introduction -- Part 1: Getting started with data analysis -- 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 -- Part 2: Analyzing data with PivotTables and PivotCharts -- Creating and using PivotTables -- Performing PivotTable calculations -- Building PivotCharts -- Part 3: Discovering advanced data analysis tools -- Tracking trends an making forecasts -- Analyzing data with statistics -- Analyzing data with descriptive statistics -- Analyzing data with inferential statistics -- Part 4: The part of tens -- Ten things you ought to know about statistics -- Ten ways to analyze financial data -- Ten ways to raise your PivotTable game.
"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" -- Page 4 of cover.
9781119518167
Electronic spreadsheets--Computer programs
Electronic spreadsheets--Data processing
005.54
Excel data analysis for dummies Microsoft Excel data analysis for dummies by Paul McFedries - 4th edition - John Wiley & Sons, Inc. c2019 - xi, 338 p. illustrations, charts - For dummies .
Includes index
Introduction -- Part 1: Getting started with data analysis -- 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 -- Part 2: Analyzing data with PivotTables and PivotCharts -- Creating and using PivotTables -- Performing PivotTable calculations -- Building PivotCharts -- Part 3: Discovering advanced data analysis tools -- Tracking trends an making forecasts -- Analyzing data with statistics -- Analyzing data with descriptive statistics -- Analyzing data with inferential statistics -- Part 4: The part of tens -- Ten things you ought to know about statistics -- Ten ways to analyze financial data -- Ten ways to raise your PivotTable game.
"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" -- Page 4 of cover.
9781119518167
Electronic spreadsheets--Computer programs
Electronic spreadsheets--Data processing
005.54