{"product_id":"excel-dashboards-reports-for-dummies-isbn-9781119844396","title":"Excel Dashboards \u0026 Reports For Dummies","description":"\u003cp\u003e\u003cb\u003eIt’s time for some truly “Excel-lent” spreadsheet reporting\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eBeneath the seemingly endless rows and columns of cells, the latest version of Microsoft Excel boasts an astonishing variety of features and capabilities. But how do you go about tapping into some of that power without spending all of your days becoming a spreadsheet guru?  \u003c\/p\u003e\u003cp\u003eIt’s easy. You grab a copy of the newest edition of \u003ci\u003eExcel Dashboards \u0026amp; Reports For Dummies\u003c\/i\u003e and get ready to blow the pants off your next presentation audience!  \u003c\/p\u003e\u003cp\u003eWith this book, you’ll learn how to transform those rows and columns of data into dynamic reports, dashboards, and visualizations. You’ll draw powerful new insights from your company’s numbers to share with your colleagues – and seem like the smartest person in the room while you’re doing it.  \u003c\/p\u003e\u003cp\u003e\u003ci\u003eExcel Dashboards \u0026amp; Reports For Dummies\u003c\/i\u003e offers:  \u003c\/p\u003e\u003cul\u003e   \u003cli\u003eComplete coverage of the latest version of Microsoft Excel provided in the Microsoft 365 subscription\u003c\/li\u003e   \u003cli\u003eStrategies to automate your reporting so you don’t have to manually crunch the numbers every week, month, quarter, or year\u003c\/li\u003e   \u003cli\u003eWays to get new perspectives on old data, visualizing it so you can find solutions no one else has seen before\u003c\/li\u003e  \u003c\/ul\u003e  \u003cp\u003eIf you’re ready to make your company’s numbers and spreadsheets dance, it’s time to get the book that’ll have them moving to your tune in no time. Get \u003ci\u003eExcel Dashboards \u0026amp; Reports For Dummies \u003c\/i\u003etoday. \u003c\/p\u003e\u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1: Getting Started with Excel Dashboards and Reports 7\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Getting in the Dashboard State of Mind 9\u003c\/p\u003e \u003cp\u003eChapter 2: Building a Super Model 23\u003c\/p\u003e \u003cp\u003eChapter 3: The Pivotal Pivot Table 65\u003c\/p\u003e \u003cp\u003eChapter 4: Using External Data for Your Dashboards and Reports. 101\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2: Building Basic Dashboard Components 119\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 5: Dressing Up Your Data Tables 121\u003c\/p\u003e \u003cp\u003eChapter 6: Sparking Inspiration with Sparklines 139\u003c\/p\u003e \u003cp\u003eChapter 7: Formatting Your Way to Visualizations 153\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3: Adding Charts to Your Dashboards 185\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 8: Charts That Show Trending 187\u003c\/p\u003e \u003cp\u003eChapter 9: Grouping and Bucketing Data 211\u003c\/p\u003e \u003cp\u003eChapter 10: Displaying Performance against a Target 231\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 4: Advanced Reporting Techniques 247\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 11: Giving Users an Interactive Interface 249\u003c\/p\u003e \u003cp\u003eChapter 12: Adding Interactivity with Pivot Slicers 283\u003c\/p\u003e \u003cp\u003eChapter 13: Sharing Your Workbook with the Outside World 303\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 5: The Part of Tens 323\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 14: Ten Chart Design Principles 325\u003c\/p\u003e \u003cp\u003eChapter 15: Ten Questions to Ask Before Distributing Your Dashboard 339\u003c\/p\u003e \u003cp\u003eIndex 345\u003c\/p\u003e \u003cp\u003e\u003cb\u003eMichael Alexander \u003c\/b\u003eis a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community. \u003c\/p\u003e  \u003cp\u003e\u003cb\u003eIn go the data, out come valuable insights\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGot data? \u003ci\u003eExcel\u003csup\u003e®\u003c\/sup\u003e Dashboards \u0026amp; Reports For Dummies\u003c\/i\u003e will help you whip it up into information that people can understand—and it’ll look pretty, too. Use your data or someone else’s to craft summaries, visualizations, and charts. We’ll even show you how to make it interactive, so users can update, dice, and slice the data as needed. If you think it’s nice to have a bunch of numbers lying around, wait until you see what you can learn from those numbers with Excel\u003csup\u003e®\u003c\/sup\u003e. Dummies will help you take your knowledge beyond the basics. \u003c\/p\u003e\u003cp\u003e\u003cb\u003eInside…\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e\u003cb\u003e\u003cli\u003eThe lowdown on dashboard design principles\u003c\/li\u003e \u003cli\u003eAdvanced reporting techniques you should know\u003c\/li\u003e \u003cli\u003eTips for incorporating external data into your reporting\u003c\/li\u003e \u003cli\u003eWays to create interactive reporting with macros and pivot slicers\u003c\/li\u003e\u003c\/b\u003e\u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47989181907173,"sku":"NP9781119844396","price":39.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119844396.jpg?v=1761783119","url":"https:\/\/k12savings.com\/es\/products\/excel-dashboards-reports-for-dummies-isbn-9781119844396","provider":"K12savings","version":"1.0","type":"link"}