{"product_id":"excel-data-analysis-for-dummies-isbn-9781119844426","title":"Excel Data Analysis For Dummies","description":"\u003cb\u003eTurn jumbles of numbers into graphics, insights, and answers with Excel\u003c\/b\u003e \u003cp\u003eWith Microsoft Excel, you can, well, excel at data analysis. And \u003ci\u003eExcel Data Analysis For Dummies\u003c\/i\u003e 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. \u003c\/p\u003e\u003cp\u003eThis 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. \u003c\/p\u003e\u003cul\u003e \u003cli\u003eLearn how to use Excel's built-in data analysis features and write your own functions to explore patterns in your data\u003c\/li\u003e \u003cli\u003eCreate striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbers\u003c\/li\u003e \u003cli\u003eClean up large datasets and identify statistical operations that will answer your questions\u003c\/li\u003e \u003cli\u003ePerform financial calculations, database operations, and more—without leaving Excel\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eExcel Data Analysis For Dummies\u003c\/i\u003e is the go-to resource for Excel users who are looking for better ways to crunch the numbers. \u003c\/p\u003e\u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1: Getting Started with Data Analysis 5\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Learning Basic Data-Analysis Techniques 7\u003c\/p\u003e \u003cp\u003eChapter 2: Working with Data-Analysis Tools 31\u003c\/p\u003e \u003cp\u003eChapter 3: Introducing Excel Tables 55\u003c\/p\u003e \u003cp\u003eChapter 4: Grabbing Data from External Sources 77\u003c\/p\u003e \u003cp\u003eChapter 5: Analyzing Table Data with Functions 99\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2: Analyzing Data Using PivotTables and PivotCharts 113\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 6: Creating and Using PivotTables 115\u003c\/p\u003e \u003cp\u003eChapter 7: Performing PivotTable Calculations 137\u003c\/p\u003e \u003cp\u003eChapter 8: Building PivotCharts 161\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3: Discovering Advanced Data-Analysis Tools 181\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 9: Dealing with Data Models 183\u003c\/p\u003e \u003cp\u003eChapter 10: Tracking Trends and Making Forecasts 203\u003c\/p\u003e \u003cp\u003eChapter 11: Analyzing Data Using Statistics 227\u003c\/p\u003e \u003cp\u003eChapter 12: Analyzing Data Using Descriptive Statistics 245\u003c\/p\u003e \u003cp\u003eChapter 13: Analyzing Data Using Inferential Statistics 261\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 4: The Part of Tens 279\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 14: Ten Things You Ought to Know about Statistics 281\u003c\/p\u003e \u003cp\u003eChapter 15: Ten Ways to Analyze Financial Data 293\u003c\/p\u003e \u003cp\u003eChapter 16: Ten Ways to Raise Your PivotTable Game 303\u003c\/p\u003e \u003cp\u003eAppendix: Glossary of Data Analysis and Excel Terms 317\u003c\/p\u003e \u003cp\u003eIndex 327\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePaul McFedries\u003c\/b\u003e 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.\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eDevelop your data-analysis skills\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFull of straightforward explanations and crystal-clear examples, \u003ci\u003eExcel\u003csup\u003e®\u003c\/sup\u003e Data Analysis For Dummies\u003c\/i\u003e is your beginner-friendly guide to analyzing data in Microsoft Excel\u003csup\u003e®\u003c\/sup\u003e. You’ll learn to create and visualize data, deploy PivotTables, use statistical functions to predict future results and describe relationships, and more. Get step-by-step guidance on how to use the world’s bestselling spreadsheet and data-analysis application to achieve powerful results, whether you’re new to Excel\u003csup\u003e®\u003c\/sup\u003e or a spreadsheet wizard. \u003c\/p\u003e\u003cp\u003e\u003cb\u003eInside…\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eImport data into Excel\u003csup\u003e®\u003c\/sup\u003e\n\u003c\/li\u003e \u003cli\u003eAnalyze Excel\u003csup\u003e®\u003c\/sup\u003e data with functions\u003c\/li\u003e \u003cli\u003eBuild PivotTables and PivotCharts\u003c\/li\u003e \u003cli\u003eMake reliable predictions\u003c\/li\u003e \u003cli\u003eDescribe data relationships\u003c\/li\u003e \u003cli\u003eInterpret financial data\u003c\/li\u003e \u003cli\u003eFind patterns and trends\u003c\/li\u003e \u003cli\u003eAvoid common statistical pitfalls\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47989182103781,"sku":"NP9781119844426","price":41.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119844426.jpg?v=1761783119","url":"https:\/\/k12savings.com\/products\/excel-data-analysis-for-dummies-isbn-9781119844426","provider":"K12savings","version":"1.0","type":"link"}