Excel dashboards and reports

Excel dashboards and reports / by Michael Alexander and John Walkenbach.

Learn to use Excel dashboards and reports to better conceptualize data Updated 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...

Full description

Saved in:
Bibliographic Details
Main Author: Alexander, Michael, 1972-
Other Authors: Walkenbach, John
Format: eBook
Language:English
Published: Hoboken, N.J. : J. Wiley & Sons, ©2013.
Edition:2nd ed.
Series:Mr. Spreadsheet's bookshelf.
Subjects:
Microsoft Excel (Computer file)
Dashboards (Management information systems)
Statistics > Charts, diagrams, etc.
Business report writing.
Balanced scorecard (Management)
Business writing.
BUSINESS & ECONOMICS > Information Management.
BUSINESS & ECONOMICS > Knowledge Capital.
Business writing
Business report writing
Statistics
Charts, diagrams, etc.
Online Access:Click for online access
Table of Contents:
  • Introducing dashboards
  • Table design best practices
  • Using Excel sparklines
  • Chartless visualization techniques
  • Excel charting for the uninitiated
  • Working with chart series
  • Formatting and customizing charts
  • Components that show trending
  • Component that group data
  • Components that show performance against a target
  • Developing your data model
  • Adding interactive controls to your dashboard
  • Marco-charged reporting
  • Using Pivot tables
  • Using Pivot charts
  • Adding interactivity with slicers
  • Using the internal data model and power view
  • Integrating external data into Excel reporting
  • Sharing your work with the outside world.

Similar Items