Williamsburg Regional Library

Microsoft Excel dashboards & reports, by Michael Alexander

eng

illustrations

index present

non fiction

Microsoft Excel dashboards & reports

1308473403

by Michael Alexander

For dummies

"Beneath 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? It's easy. You grab a copy of the newest edition of Excel Dashboards & Reports For Dummies and get ready to blow the pants off your next presentation audience! With 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

Getting started with Excel dashboards and reports. Getting in the dashboard state of mind ; Building a super model ; The pivotal pivot table ; Using external data for your dashboards and reports -- Building basic dashboard components. Dressing up your data tables ; Sparking inspiration with Sparklines ; Formatting your way to visualizations -- Adding charts to your dashboards. Charts that show trending ; Grouping and bucketing data ; Displaying performance against a target -- Advanced reporting techniques. Giving users an interactive interface ; Adding interactivity with pivot slicers ; Sharing your workbook with the outside world -- The part of tens. Ten chart design principles ; Ten questions to ask before distributing your dashboard

adult

Microsoft Excel dashboards and reportsMicrosoft Excel dashboards & reports for dummies