Excel Data Analysis For Dummies

Introduction 1

Part 1: Getting Started with Data Analysis 5

Chapter 1: Learning Basic Data-Analysis Techniques 7

Chapter 2: Working with Data-Analysis Tools 31

Chapter 3: Introducing Excel Tables 55

Chapter 4: Grabbing Data from External Sources 77

Chapter 5: Analyzing Table Data with Functions 99

Part 2: Analyzing Data Using PivotTables and PivotCharts 113

Chapter 6: Creating and Using PivotTables 115

Chapter 7: Performing PivotTable Calculations 137

Chapter 8: Building PivotCharts 161

Part 3: Discovering Advanced Data-Analysis Tools 181

Chapter 9: Dealing with Data Models 183

Chapter 10: Tracking Trends and Making Forecasts 203

Chapter 11: Analyzing Data Using Statistics 227

Chapter 12: Analyzing Data Using Descriptive Statistics 245

Chapter 13: Analyzing Data Using Inferential Statistics 261

Part 4: The Part of Tens 279

Chapter 14: Ten Things You Ought to Know about Statistics 281

Chapter 15: Ten Ways to Analyze Financial Data 293

Chapter 16: Ten Ways to Raise Your PivotTable Game 303

Appendix: Glossary of Data Analysis and Excel Terms 317

Index 327

Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.

• Excel

Microsoft; Excel; Excel 365; spreadsheet; data analysis; data visualization; statistical analysis; financial analysis; charts; graphs; PivotTables; PivotCharts; analyzing data; VLOOKUP; tables; functions; data cleaning; database; statistics