{"product_id":"microsoft-365-excel-all-in-one-for-dummies","title":"Microsoft 365 Excel All-In-One for Dummies","description":"\u003ctable align=\"center\" border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"100%\"\u003e\n\u003ctr\u003e\n\u003ctd class=\"productDetailSmallElements\"\u003e\n\u003cp\u003e\n\u003cstrong\u003eBiographical Note\u003c\/strong\u003e:\u003cbr\u003e\n\u003c\/p\u003e\n\u003cp\u003eThis book collects bestselling Excel content from the \u003ci\u003eFor Dummies\u003c\/i\u003e series, including selections from \u003ci\u003eMicrosoft 365 Excel For Dummies\u003c\/i\u003e (\u003cb\u003eDavid H. Ringstrom\u003c\/b\u003e), \u003ci\u003eMicrosoft Excel Dashboards \u0026amp; Reports\u003c\/i\u003e (\u003cb\u003eMichael Alexander\u003c\/b\u003e), \u003ci\u003eMicrosoft 365 Excel Formulas \u0026amp; Functions For Dummies\u003c\/i\u003e (\u003cb\u003eKen Bluttman\u003c\/b\u003e), \u003ci\u003eMicrosoft Excel Power Pivot \u0026amp; Power Query For Dummies\u003c\/i\u003e (\u003cb\u003eMichael Alexander\u003c\/b\u003e), \u003ci\u003eMicrosoft Excel Data Analysis For Dummies\u003c\/i\u003e (\u003cb\u003ePaul McFedries\u003c\/b\u003e), \u003ci\u003eExcel Macros For Dummies\u003c\/i\u003e (\u003cb\u003eDick Kusleika\u003c\/b\u003e).\u003c\/p\u003e\n\u003cbr\u003e\u003cbr\u003e\n\u003cstrong\u003eJacket Description\/Back\u003c\/strong\u003e:\u003cbr\u003e\n\u003cp\u003e\u003cb\u003eYour essential guide to Excel expertise\u003c\/b\u003e \u003c\/p\u003e\n\u003cp\u003eAlmost every job and profession requires digging into an Excel spreadsheet from time to time. You can spend hours of trial and error figuring out how to make Excel work for you, or jump right to the answers you need with the help of this book. This collection of Excel insight walks you through the basics of spreadsheet creation and dives into creating next-level formulas, data visualizations, and analysis. It's the roadmap to unleashing the Excel guru inside of you! \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003e8 Books Inside...\u003c\/b\u003e \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cb\u003eGetting Started with Excel\u003c\/b\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eWriting Formulas and Functions\u003c\/b\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eGoing Farther with Functions\u003c\/b\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eAnalyzing Data\u003c\/b\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eSummarizing and Visualizing Data\u003c\/b\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eReporting and Querying Data\u003c\/b\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eCreating Dashboards and Reports\u003c\/b\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cb\u003eAutomating Excel\u003c\/b\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cbr\u003e\u003cbr\u003e\n\u003cstrong\u003eTable of Contents\u003c\/strong\u003e:\u003cbr\u003e\n\u003cp\u003eIntroduction 1\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook 1: Getting Started with Excel 5\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Getting Started with Spreadsheets 7\u003c\/p\u003e\n\u003cp\u003eChapter 2: Carrying Out Basic Calculations 31\u003c\/p\u003e\n\u003cp\u003eChapter 3: Formatting Cells and Worksheets 53\u003c\/p\u003e\n\u003cp\u003eChapter 4: Organizing Data and Creating Tables 79\u003c\/p\u003e\n\u003cp\u003eChapter 5: Navigating Worksheets and Workbooks 113\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook 2: Working with Formulas and Functions 129\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Tapping Into Formula and Function Fundamentals 131\u003c\/p\u003e\n\u003cp\u003eChapter 2: Saving Time with Function Tools 161\u003c\/p\u003e\n\u003cp\u003eChapter 3: Building Array Formulas and Functions 177\u003c\/p\u003e\n\u003cp\u003eChapter 4: Fixing Errors in Formulas 191\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook 3: Going Farther with Functions 207\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Calculating Loans, Interest, and Depreciation 209\u003c\/p\u003e\n\u003cp\u003eChapter 2: Performing Functional Math. 241\u003c\/p\u003e\n\u003cp\u003eChapter 3: Working with Date and Time Functions 271\u003c\/p\u003e\n\u003cp\u003eChapter 4: Manipulating Text with Functions 291\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook 4: Analyzing Data 317\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Using Basic Data Analysis Techniques 319\u003c\/p\u003e\n\u003cp\u003eChapter 2: Working with Data Analysis Tools 343\u003c\/p\u003e\n\u003cp\u003eChapter 3: Analyzing Table Data with Functions 365\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook 5: Summarizing, Visualizing, and Illustrating Data 377\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Creating Charts 379\u003c\/p\u003e\n\u003cp\u003eChapter 2: Creating and Using PivotTables 391\u003c\/p\u003e\n\u003cp\u003eChapter 3: Performing PivotTable Calculations 413\u003c\/p\u003e\n\u003cp\u003eChapter 4: Building PivotCharts 435\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook 6: Reporting and Querying Data 455\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Introducing Power Pivot 457\u003c\/p\u003e\n\u003cp\u003eChapter 2: Advanced Moves with PivotTables 469\u003c\/p\u003e\n\u003cp\u003eChapter 3: Working Directly with the Internal Data Model 499\u003c\/p\u003e\n\u003cp\u003eChapter 4: Adding Formulas to Power Pivot 513\u003c\/p\u003e\n\u003cp\u003eChapter 5: Meeting Power Query and Its Connection Types 531\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook 7: Creating Dashboards and Reports 559\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Getting in the Dashboard State of Mind 561\u003c\/p\u003e\n\u003cp\u003eChapter 2: Building a Super Model 575\u003c\/p\u003e\n\u003cp\u003eChapter 3: Dressing Up Your Data Tables 619\u003c\/p\u003e\n\u003cp\u003eChapter 4: Formatting Your Way to Visualizations 635\u003c\/p\u003e\n\u003cp\u003eChapter 5: Displaying Performance against a Target 663\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook 8: Automating Excel with Macros and VBA 679\u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003eChapter 1: Macro Fundamentals 681\u003c\/p\u003e\n\u003cp\u003eChapter 2: Getting Cozy with the Visual Basic Editor 701\u003c\/p\u003e\n\u003cp\u003eChapter 3: The Anatomy of Macros 715\u003c\/p\u003e\n\u003cp\u003eChapter 4: Working with Workbooks 729\u003c\/p\u003e\n\u003cp\u003eIndex 753\u003c\/p\u003e\n\u003cbr\u003e\u003cbr\u003e\n\u003cstrong\u003ePublisher Marketing\u003c\/strong\u003e:\u003cbr\u003e\n\u003cp\u003e\u003cb\u003eGet into the nitty gritty of Excel, the all-important spreadsheet tool\u003c\/b\u003e \u003c\/p\u003e\n\u003cp\u003e\u003ci\u003eMicrosoft 365 Excel All-in-One For Dummies\u003c\/i\u003e offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organizing data and work your way to pro techniques that help with any career field or reason for using the app. Gain the skills to apply advanced formulas and functions, create stunning data visualizations, build dashboards and reports, and automate your spreadsheets. You'll also get a glimpse into how AI tools can boost your work. Eight mini-books come together in this expanded Excel reference. With \u003ci\u003eMicrosoft 365 Excel All-in-One For Dummies, \u003c\/i\u003e you'll soon be the go-to Excel guru in your office or school. \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn the basics of Excel--organizing data, performing calculations, and formatting your spreadsheet.\u003c\/li\u003e\n\u003cli\u003eUse functions to handle advanced math and financial analysis.\u003c\/li\u003e\n\u003cli\u003eCreate data visualizations and summaries to help tell your story\u003c\/li\u003e\n\u003cli\u003eApply basic programming skills using VBA\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eThis book is perfect for professionals or students who need to up their Excel game with insight from pros who know the classic spreadsheet app inside and out.\u003c\/p\u003e\n\u003cbr\u003e\u003cbr\u003e\n\n\u003cbr\u003e\n\u003cbr\u003e\n\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/table\u003e\u003cp\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Ringstrom, David H\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e For Dummies\u003cbr\u003e\u003cb\u003eBinding:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePub Date:\u003c\/b\u003e 2025-09-09\u003cbr\u003e\u003cb\u003eBISAC:\u003c\/b\u003e Computers \/ Business \u0026amp; Productivity Software \/ Spreadsheets|Computers \/ Data Science \/ Data Visualization\u003cbr\u003e\u003cb\u003eSubjects:\u003c\/b\u003e Electronic spreadsheets|Computer programs|Handbooks and manuals\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 2.4 lbs\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781394344635\u003cbr\u003e\u003cb\u003eASIN:\u003c\/b\u003e -\u003cbr\u003e\u003cb\u003eSKU:\u003c\/b\u003e SP-9781394344635\u003c\/p\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":52374521184537,"sku":"SP-9781394344635","price":67.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0913\/0380\/5209\/files\/9781394344635_spiral.png?v=1778476936","url":"https:\/\/westbindery.com\/products\/microsoft-365-excel-all-in-one-for-dummies","provider":"West Bindery","version":"1.0","type":"link"}