Picture 1 of 1

Stock photo

Excel Dashboards & Reports for Dummies by Michael Alexander: New - Picture 1 of 1

Excel Dashboards and Reports for Dummies by Michael Alexander (2016, Trade Paperback)

AlibrisBooks (462744)

98.6% positive feedback

Price:

$87.91

Free shipping

Estimated delivery Sat, Aug 16 - Thu, Aug 21

Returns:

30 days returns. Buyer pays for return shipping. If you use an eBay shipping label, it will be deducted from your refund amount.

Condition:

Brand New

New Trade paperback

About this product

Product Identifiers

PublisherWiley & Sons, Incorporated, John

ISBN-101119076765

ISBN-139781119076766

eBay Product ID (ePID)211900044

Product Key Features

Number of Pages384 Pages

LanguageEnglish

Publication NameExcel Dashboards and Reports for Dummies

SubjectProbability & Statistics / General, Desktop Applications / Spreadsheets, Business Writing

Publication Year2016

TypeTextbook

AuthorMichael Alexander

Subject AreaMathematics, Computers, Business & Economics

FormatTrade Paperback

Dimensions

Item Height0.9 in

Item Weight18.6 Oz

Item Length9.8 in

Item Width7.5 in

Additional Product Features

Edition Number3

Intended AudienceTrade

LCCN2015-958876

Dewey Edition23

IllustratedYes

Dewey Decimal658.4038011

Table Of ContentIntroduction 1 Part I: Getting Started with Excel Dashboards & Reports 7 Chapter 1: Getting In the Dashboard State of Mind 9 Chapter 2: Building a Super Model 25 Part II: Building Basic Dashboard Components 51 Chapter 3: Dressing Up Your Data Tables 53 Chapter 4: Sparking Inspiration with Sparklines 69 Chapter 5: Formatting Your Way to Visualizations 83 Chapter 6: The Pivotal Pivot Table 115 Part III: Building Advanced Dashboard Components 151 Chapter 7: Charts That Show Trending 153 Chapter 8: Grouping and Bucketing Data 179 Chapter 9: Displaying Performance against a Target 201 Part IV: Advanced Reporting Techniques 217 Chapter 10: Macro-Charged Dashboarding 219 Chapter 11: Giving Users an Interactive Interface 233 Chapter 12: Adding Interactivity with Pivot Slicers 255 Part V: Working with the OutsideÂ@World 273 Chapter 13: Using External Data for Your Dashboards and Reports 275 Chapter 14: Sharing Your Workbook with the Outside World 301 Part VI: The Part of Tens 323 Chapter 15: Ten Chart Design Principles 325 Chapter 16: Ten Excel Chart Types andÂ@When to Use Them 339 Index 345

SynopsisMake the most of your data using the power of Excel When you think of data, do you think of endless rows and columns in spreadsheets? Excel Dashboards and Reports For Dummies, 3rd Edition shows you how to make the most of your data--and puts an end to mind-numbing spreadsheets by exploring new ways to conceptualize and present key information. There's often a gap between handling data and synthesizing it into meaningful reports, and this approachable text bridges this gap with quick and accessible information that answers key questions, like how to meaningfully capture data trends, how to show relationships in data, and when it's better to show variances than actual data values. As a leading spreadsheet application, Microsoft Excel is the go-to data software. This tool allows you to use dashboard reports that leverage gauges, maps, charts, sliders, and other visual elements to present complex data in a manner that's easy to understand. Using Excel dashboards effectively can improve your professional capabilities by leaps and bounds. Analyze and report on large amounts of data in a meaningful way Look at data from different perspectives, and better visualize the information you're presenting by quickly slicing data on the fly Automate redundant reporting and analysis functions, making your data analysis and reporting routine more efficient Create visualizations, dashboards, and what-if analyses that are as visually appealing as they are substantial Excel Dashboards and Reports For Dummies, 3rd Edition is a fantastic resource if you're looking to spice up your reporting!, Learn to: Analyze data and report it in a way that makes sense Slice and dice data from different perspectives Create eye-catching and understandable reports, visualizations, and dashboards Automate redundant reporting Make the most of your data using the power of Excel When you think of data, do you see endless rows and columns? Excel Dashboards & Reports For Dummies is here to put an end to mind-numbing spreadsheets and shows you how to make the most of your data by exploring new ways to conceptualize and present key information. Get ready to improve your professional capabilities by leaps and bounds! Let's get started uncover best practices for setting up the source data for your dashboards and reports and explore key Excel functions that help you build effective dashboard models Build your dashboard look at the various techniques you can use to visualize data without the use of charts or graphs and discover how pivot tables can enhance your analytical and reporting capabilities Know your components find out how to represent trending across multiple series and distinct time periods, explore how best to use charts to group data, and uncover techniques that can help you display and measure performance Advance your techniques leverage macros to automate your reporting systems, provide your clients with simple interfaces, and explore vibrant pivot slicers Open the book and find: A quick look at dashboard design principles The lowdown on the pivotal pivot table Advanced reporting techniques you should know Tips for using external data for your dashboards and reports How to share your workbook with the outside world Ten chart design principles Questions to ask before distributing your dashboard, Make the most of your data using the power of Excel When you think of data, do you think of endless rows and columns in spreadsheets? Excel Dashboards and Reports For Dummies, 3rd Edition shows you how to make the most of your data--and puts an end to mind-numbing spreadsheets by exploring new ways to conceptualize and present key information. There's often a gap between handling data and synthesizing it into meaningful reports, and this approachable text bridges this gap with quick and accessible information that answers key questions, like how to meaningfully capture data trends, how to show relationships in data, and when it's better to show variances than actual data values. As a leading spreadsheet application, Microsoft Excel is the go-to data software. This tool allows you to use dashboard reports that leverage gauges, maps, charts, sliders, and other visual elements to present complex data in a manner that's easy to understand. Using Excel dashboards effectively can improve your professional capabilities by leaps and bounds. Analyze and report on large amounts of data in a meaningful way Look at data from different perspectives, and better visualize the information you're presenting by quickly slicing data on the fly Automate redundant reporting and analysis functions, making your data analysis and reporting routine more efficient Create visualizations, dashboards, and what-if analyses that are as visually appealing as they are substantial Excel Dashboards and Reports For Dummies, 3rd Edition is a fantastic resource if you're looking to spice up your reporting

LC Classification NumberHF5548.4.M523