Excel® dashboards and reports
by Michael Alexander and John Walkenbach
| Alternative title: | Excel dashboards and reports Microsoft Excel dashboards & reports Microsoft Excel dashboards and reports |
|---|---|
| Year of publication: |
[2013] ; 2nd edition (Online-Ausg.)
|
| Authors: | Alexander, Michael ; Walkenbach, John |
| Publisher: |
Hoboken, NJ : Wiley |
| Description of contents: | Table of Contents [external.dandelon.com] |
Online Resource
| Extent: | Online-Ressource (1 online resource (xvi, 412 pages)) illustrations (black and white) |
|---|---|
| Series: | |
| Type of publication: | Book / Working Paper |
| Language: | English |
| Notes: | Previous edition: 2010. - Includes index. - Description based on print version record Previous edition: 2010 About the Authors; Contents at a Glance; Table of Contents; Introduction; What You Need to Know; What You Need to Have; Conventions in This Book; How This Book Is Organized; About the Companion Website; About the Power Utility Pak Offer; Reach Out; Part I: Getting Started with Excel Dashboards; Chapter 1: Introducing Dashboards; What Are Dashboards and Reports?; Establish the User Requirements; A Quick Look at Dashboard Design Principles; Key Questions to Ask Before Distributing Your Dashboard; Chapter 2: Table Design Best Practices; Table Design Principles Enhancing Reporting with Custom Number FormattingChapter 3: Using Excel Sparklines; Understanding Sparklines; Applying Sparklines; Creating Sparklines; Customizing Sparklines; Chapter 4: Chartless Visualization Techniques; Enhancing Reports with Conditional Formatting; Using Symbols to Enhance Reporting; Using Excel's Camera Tool; Part II: Introducing Charts into Your Dashboards; Chapter 5: Excel Charting for the Uninitiated; What Is a Chart?; How Excel Handles Charts; Parts of a Chart; Basic Steps for Creating a Chart; Working with Charts; Chapter 6: Working with Chart Series Specifying the Data for Your ChartAdding a New Series to a Chart; Deleting a Chart Series; Modifying the Data Range for a Chart Series; Understanding Series Names; Adjusting the Series Plot Order; Charting a Noncontiguous Range; Using Series on Different Sheets; Handling Missing Data; Controlling a Data Series by Hiding Data; Unlinking a Chart Series from Its Data Range; Working with Multiple Axes; Chapter 7: Formatting and Customizing Charts; Chart Formatting Overview; Adjusting Fills and Borders: General Procedures; Formatting Chart Background Elements; Formatting Chart Series Working with Chart TitlesWorking with a Chart's Legend; Working with Chart Axes; Working with Gridlines; Working with Data Labels; Working with a Chart Data Table; Chapter 8: Components That Show Trending; Trending Dos and Don'ts; Comparative Trending; Emphasizing Periods of Time; Other Trending Techniques; Chapter 9: Components That Group Data; Listing Top and Bottom Values; Using Histograms to Track Relationships and Frequency; Emphasizing Top Values in Charts; Chapter 10: Components That Show Performance Against a Target; Showing Performance with Variances Showing Performance Against Organizational TrendsUsing a Thermometer-Style Chart; Using a Bullet Graph; Showing Performance Against a Target Range; Part III: Advanced Dashboarding Concepts; Chapter 11: Developing Your Data Model; Building a Data Model; Data Model Best Practices; Excel Functions for Your Data Model; Working with Excel Tables; Chapter 12: Adding Interactive Controls to Your Dashboard; Getting Started with Form Controls; Using the Button Control; Using the Check Box Control; Using the Option Button Control; Using the Combo Box Control; Using the List Box Control Chapter 13: Macro-Charged Reporting Nebent.: Umschlagt.: Microsoft Excel dashboards & reports Microsoft Excel dashboards & reports |
| ISBN: | 978-1-306-45025-6 ; 1-306-45025-X ; 978-1-118-49141-6 ; 978-1-118-49141-6 ; 978-1-118-49042-6 ; 1-306-45472-7 |
| Source: | ECONIS - Online Catalogue of the ZBW |
Persistent link: https://www.econbiz.de/10014461191