Description |
1 online resource (1 volume) : illustrations. |
Series |
Mr. Spreadsheet's bookshelf |
|
Mr. Spreadsheet's bookshelf.
|
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. |
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. |
Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
|
Dashboards (Management information systems)
|
|
Statistics -- Charts, diagrams, etc.
|
|
Business report writing.
|
|
Balanced scorecard (Management)
|
|
Business writing.
|
|
Tableaux de bord (Gestion) |
|
Statistique -- Tableaux, graphiques, etc. |
|
Style commercial. |
|
Business writing |
|
Balanced scorecard (Management) |
|
Business report writing |
|
Dashboards (Management information systems) |
|
Statistics |
Genre |
Charts, diagrams, etc.
|
Added Author |
Walkenbach, John.
|
Other Form: |
Print version: Alexander, Michael, 1972- Excel dashboards and reports. Second edition. Hoboken, N.J. : John Wiley & Sons, 2013 9781118490426 (OCoLC)827267348 |
ISBN |
9781118490433 |
|
1118490436 |
|
9781118491416 (e-book) |
|
1118491416 (e-book) |
|
9781118491508 |
|
1118491505 |
|
(pbk. ; alk. paper) |
|