Excel Data Analysis For Dummies

ISBN-13: 9781119844426 / Angielski / Miękka / 2022 / 368 str.

Paul McFedries

Spis treści

Introduction 1Part 1: Getting Started with Data Analysis 5Chapter 1: Learning Basic Data-Analysis Techniques 7Chapter 2: Working with Data-Analysis Tools 31Chapter 3: Introducing Excel Tables 55Chapter 4: Grabbing Data from External Sources 77Chapter 5: Analyzing Table Data with Functions 99Part 2: Analyzing Data Using PivotTables and PivotCharts 113Chapter 6: Creating and Using PivotTables 115Chapter 7: Performing PivotTable Calculations 137Chapter 8: Building PivotCharts 161Part 3: Discovering Advanced Data-Analysis Tools 181Chapter 9: Dealing with Data Models 183Chapter 10: Tracking Trends and Making Forecasts 203Chapter 11: Analyzing Data Using Statistics 227Chapter 12: Analyzing Data Using Descriptive Statistics 245Chapter 13: Analyzing Data Using Inferential Statistics 261Part 4: The Part of Tens 279Chapter 14: Ten Things You Ought to Know about Statistics 281Chapter 15: Ten Ways to Analyze Financial Data 293Chapter 16: Ten Ways to Raise Your PivotTable Game 303Appendix: Glossary of Data Analysis and Excel Terms 317Index 327

O autorze

Paul McFedries is the owner of Logophilia Limited, a successful technical writing firm. He has 25 years' experience writing instructional computer books and is the author of over 100 books that have sold a combined 4 million copies worldwide.