Custom cover image
Custom cover image

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

By: Contributor(s): Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Series: Mr. Spreadsheet's bookshelfPublisher: Hoboken, NJ : Wiley, [2013]Copyright date: ©2013Edition: 2nd edition (Online-Ausg.)Description: Online-Ressource (1 online resource (xvi, 412 pages)) : illustrations (black and white)ISBN:
  • 9781306450256
  • 130645025X
  • 9781118491416
Other title:
  • Nebent.: Umschlagt.: Microsoft Excel dashboards & reports
  • Excel dashboards and reports
  • Microsoft Excel dashboards & reports
  • Microsoft Excel dashboards and reports
Former title: Früherer Titel: Microsoft Excel dashboards & reportsSubject(s): Additional physical formats: 9781118491416 | 9781118490426 | 1306454727 | Erscheint auch als: 978-1-118-49042-6 Druck-Ausgabe | Revision of: Excel dashboards & reports DDC classification:
  • 658.40380285554
LOC classification:
  • HF5548.4.M523
Online resources:
Contents:
Summary: "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 coverSummary: 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 WorldPPN: PPN: 811695042Package identifier: Produktsigel: ZDB-26-MYL | ZDB-38-EBR | ZDB-30-PAD | ZDB-30-PBE | ZDB-30-PQE
No physical items for this record

Powered by Koha