Excel dashboards & reports for dummies
By: by Michael Alexander
Edition: 3rd edition.
Series: For dummies,® a Wiley brand; --For dummies
Publisher: John Wiley & Sons, Inc.
Published: 2016
Language: eng
Number of pages: 360
ISBN-13: 9781119076766; 9781119088813; 9781119076773
Subjects: Dashboards (Management information systems); Statistics; Electronic spreadsheets; Charts, diagrams; Business; Computer programs; Microsoft Excel (Computer file); Business report writing
Other titles: Excel dashboards and reports for dummies; Microsoft Excel dashboards & reports for dummies; Microsoft Excel dashboards and reports for dummies
Notes: Includes index.
Table of contents: title: Getting started with Excel dashboards and reports. Getting in the dashboard state of mind ; Building a super model; title: Building basic dashboard components. Dressing up your data tables ; Sparking inspiration with Sparklines ; Formatting your way to visualizations ; The pivotal pivot table; title: Building advanced dashboard components. Charts that show trending ; Grouping and bucketing data ; Displaying performance against a target; title: Advanced reporting techniques. Macro-charged dashboarding ; Giving users an interactive interface ; Adding interactivity with pivot slicers; title: Working with the outside world. Using external data for your dashboards and reports ; Sharing your workbook with the outside world; title: The part of tens. Ten chart design principles ; Ten Excel chart types and when to use them.