{"product_id":"excel-dashboards-and-reports-isbn-9781118490426","title":"Excel Dashboards and Reports","description":"\u003cp\u003e\u003cb\u003eLearn to use Excel dashboards and reports to better conceptualize data\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUpdated for all the latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create compelling Excel reports. Veteran author Michael Alexander walks you through the most effective ways to present and report data. Featuring a comprehensive review of a wide array of technical and analytical concepts, this essential guide helps you go from reporting data with simple tables full of dull numbers to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eDetails how to analyze large amounts of data and report the results in a way that is both visually attractive and effective\u003c\/li\u003e \u003cli\u003eDescribes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly\u003c\/li\u003e \u003cli\u003eShows how to automate redundant reporting and analysis processes\u003c\/li\u003e \u003cli\u003eWalks you through creating impressive dashboards, eye-catching visualizations, and real-world What-If analyses\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eExcel Dashboards and Reports, Second Edition\u003c\/i\u003e is part technical manual, part analytical guidebook, and exactly what you need to become your organization's dashboard dynamo!\u003c\/p\u003e  \u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART I: Getting Started with Excel Dashboards\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Introducing Dashboards  11\u003c\/p\u003e \u003cp\u003eChapter 2: Table Design Best Practices 29\u003c\/p\u003e \u003cp\u003eChapter 3: Using Excel Sparklines 47\u003c\/p\u003e \u003cp\u003eChapter 4: Chartless Visualization Techniques 61\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART II: Introducing Charts into Your Dashboards\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 5: Excel Charting for the Uninitiated 89\u003c\/p\u003e \u003cp\u003eChapter 6: Working with Chart Series 107\u003c\/p\u003e \u003cp\u003eChapter 7: Formatting and Customizing Charts 131\u003c\/p\u003e \u003cp\u003eChapter 8: Components That Show Trending 171\u003c\/p\u003e \u003cp\u003eChapter 9: Components That Group Data 193\u003c\/p\u003e \u003cp\u003eChapter 10: Components That Show Performance Against a Target 209\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART III: Advanced Dashboarding Concepts\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 11: Developing Your Data Model 225\u003c\/p\u003e \u003cp\u003eChapter 12: Adding Interactive Controls to Your Dashboard 247\u003c\/p\u003e \u003cp\u003eChapter 13: Macro-Charged Reporting 265\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART IV: Pivot Table Driven Dashboards\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 14: Using Pivot Tables 281\u003c\/p\u003e \u003cp\u003eChapter 15: Using Pivot Charts 311\u003c\/p\u003e \u003cp\u003eChapter 16: Adding Interactivity with Slicers 329\u003c\/p\u003e \u003cp\u003eChapter 17: Using the Internal Data Model and Power View 343\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART V: Working with the Outside World\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 18: Integrating External Data into Excel Reporting 365\u003c\/p\u003e \u003cp\u003eChapter 19: Sharing Your Work with the Outside World 381\u003c\/p\u003e \u003cp\u003eIndex 399\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eMichael Alexander\u003c\/b\u003e is a Microsoft MVP who has written several books on advanced business analysis with Access and Excel, including \u003ci\u003e101 Ready-To-Use Excel Macros\u003c\/i\u003e and the \u003ci\u003eAccess 2013 Bible.\u003c\/i\u003e A consultant and developer, he offers workshops and webinars through www.datapigtechnologies.com.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eJohn Walkenbach,\u003c\/b\u003e aka Mr. Spreadsheet, has written hundreds of articles and over 50 books, including multiple editions of the bestselling \u003ci\u003eExcel Bible\u003c\/i\u003e. He also created the award-winning Power Utility Pak.\u003c\/p\u003e  \u003cp\u003e\u003cb\u003e\u003ci\u003eCreate versatile, engaging dashboards with Excel\u003c\/i\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOrganizations are hungry for data-driven insights, and the need to turn large amounts of data into meaningful information has made building effective dashboards and reports more important than ever. As one of the most powerful and commonly used business tools, Excel is an ideal platform for synthesizing complex data into clear and effective reporting.\u003c\/p\u003e \u003cp\u003eThis book provides you with the technical know-how to move from reporting your data with simple tables full of dull numbers to creating meaningful and appealing reporting solutions that will wow an audience. You'll learn to analyze large amounts of data, present the results, add interactive controls, design eye-catching visualizations, and connect to external data sources with this one-of-a-kind Excel guide.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e\u003ci\u003eLet Mr. Spreadsheet show you how to:\u003c\/i\u003e\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eEffectively analyze and present large volumes of data\u003c\/li\u003e \u003cli\u003eCreate eye-catching visualizations\u003c\/li\u003e \u003cli\u003eImprove data visibility from different perspectives\u003c\/li\u003e \u003cli\u003eAdd interactivity to slice data into various views on the fly\u003c\/li\u003e \u003cli\u003eConnect to external data sources\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989182038245,"sku":"NP9781118490426","price":39.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118490426.jpg?v=1761783117","url":"https:\/\/k12savings.com\/products\/excel-dashboards-and-reports-isbn-9781118490426","provider":"K12savings","version":"1.0","type":"link"}