Beställningsvara. Skickas inom 7-10 vardagar. Fri frakt för medlemmar vid köp för minst 249 kr.
Turn jumbles of numbers into graphics, insights, and answers with Excel With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical functions—it's all in here, with examples and ideas for Excel users of all skill levels. This latest edition covers the most recent updates to Excel and Microsoft 365. You'll beef up your data skills and learn powerful techniques for turning numbers into knowledge. For students, researchers, and business professionals, Excel is the spreadsheet and data application of choice—and Dummies is the best choice for learning how to make those numbers sing. Learn how to use Excel's built-in data analysis features and write your own functions to explore patterns in your dataCreate striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbersClean up large datasets and identify statistical operations that will answer your questionsPerform financial calculations, database operations, and more—without leaving ExcelExcel Data Analysis For Dummies is the go-to resource for Excel users who are looking for better ways to crunch the numbers.
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.
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