Excel dashboards & reports / by Michael Alexander and John Walkenbach.
| Author/creator | Alexander, Michael, 1972- |
| Other author | Walkenbach, John. |
| Format | Electronic |
| Edition | 2nd Edition. |
| Publication Info | Hoboken, NJ : Wiley, [2013] |
| Description | xvi, 412 pages : illustrations ; 24 cm. |
| Supplemental Content | Full text available from Ebook Central - Academic Complete |
| Subjects |
| Variant title | Excel dashboards and reports |
| Series | Mr. Spreadsheet's bookshelf Mr. Spreadsheet's bookshelf. ^A1302504 |
| Contents | Part I: Getting Started with Excel Dashboards. Chapter 1: Introducing Dashboards ; Chapter 2: Table Design Best Practices ; Chapter 3: Using Excel Sparklines ; Chapter 4: Chartless Visualization Techniques -- Part II: Introducing Charts into Your Dashboards. Chapter 5: Excel Charting for the Uninitiated ; Chapter 6: Working with Chart Series ; Chapter 7: Formatting and Customizing Charts ; Chapter 8: Components That Show Trending ; Chapter 9: Components That Group Data ; Chapter 10: Components That Show Performance Against a Target -- Part III: Advanced Dashboarding Concepts. Chapter 11: Developing Your Data Model ; Chapter 12: Adding Interactive Controls to Your Dashboard ; Chapter 13: Macro-Charged Reporting -- Part IV: Pivot Table Driven Dashboards. Chapter 14: Using Pivot Tables ; Chapter 15: Using Pivot Charts ; Chapter 16: Adding Interactivity with Slicers ; Chapter 17: Using the Internal Data Model and Power View -- Part V: Working with the Outside World. Chapter 18: Integrating External Data into Excel Reporting ; Chapter 19: Sharing Your Work with the Outside World. |
| Abstract | "Create versatile, engaging dashboards with Excel. Organizations are hungry for data-driven insights, and the need to turn large amounts of data into meaningful information has made building effective dashboards and reports more important than ever. As one of the most powerful and commonly used business tools, Excel is an ideal platform for synthesizing complex data into clear and effective reporting. This book provides you with the technical know-how to move from reporting your data with simple tables full of dull numbers to creating meaningful and appealing reporting solutions that will wow an audience. You'll learn to analyze large amounts of data, present the results, add interactive controls, design eye-catching visualizations, and connect to external data sources with this one-of-a-kind Excel guide."--P. [4] of cover. |
| General note | Publisher's name appears on title page as: Wiley. |
| General note | Includes index. |
| Access restriction | Available only to authorized users. |
| Technical details | Mode of access: World Wide Web |
| Other edition issued | Alexander, Michael, 1972- Excel dashboards & reports. Hoboken, NJ : Wiley, ©2010 9780470620120 |
| Genre/form | Electronic books. |
| LCCN | 2013934910 |
| ISBN | 9781118490426 (pbk.) |
| ISBN | 1118490428 (pbk.) |
| ISBN | 0470620129 (pbk.) |
| ISBN | 9780470620120 (pbk.) |
| ISBN | 9781118490433 (e-book) |
| ISBN | 1118490436 (e-book) |
| ISBN | 9781118491508 (e-book) |
| ISBN | 1118491505 (e-book) |
| ISBN | 9781118491416 (e-book) |
| ISBN | 1118491416 (e-book) |
| Stock number | John Wiley & Sons Inc, Order Processing Dept 432 Elizabeth Ave, Somerset, NJ, USA, 08875, (732)4694400 |
Availability
| Library | Location | Call Number | Status | Item Actions |
|---|---|---|---|---|
| Electronic Resources | Access Content Online | ✔ Available |