Excel dashboards and reports

Alexander, Michael 1972- (Author). Walkenbach, John. (Added Author).

Summary: 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 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.

Record details

ISBN: 1118490428
ISBN: 9781118490426
ISBN: 1118491505
ISBN: 9781118491508
ISBN: 1118491416
ISBN: 9781118491416
ISBN: 1118490436
ISBN: 9781118490433
Physical Description: 1 online resource (1 volume) : illustrations.
remote
Edition: 2nd ed.
Publisher: Hoboken, N.J. : J. Wiley & Sons, ©2013.

Content descriptions

Formatted Contents Note:

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.

Source of Description Note:

Print version record.