Excel Dashboards and Reports.
John. Walkenbach
Bok Engelsk 2013 · Electronic books.
| Omfang | 1 online resource (433 pages)
|
|---|---|
| Utgave | 2nd ed.
|
| Opplysninger | Intro -- 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 Formatting -- Chapter 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 Chart -- Adding 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.. - Understanding the Internal Data Model -- Creating a Power View Dashboard -- Part V: Working with the Outside World -- Chapter 18: Integrating External Data into Excel Reporting -- Importing Data from Microsoft Access -- Importing Data from SQL Server -- Passing Your Own SQL Statements to External Databases -- Chapter 19: Sharing Your Work with the Outside World -- Securing Your Dashboards and Reports -- Linking Your Excel Dashboards to PowerPoint -- Distributing Your Dashboards via a PDF -- Distributing Your Dashboards to SkyDrive -- Index.. - Working with Chart Titles -- Working 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 Trends -- Using 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 -- Why Use a Macro? -- Recording Your First Macro -- Enabling Macros in Excel 2013 -- Excel Macro Examples -- Part IV: Pivot Table Driven Dashboards -- Chapter 14: Using Pivot Tables -- Introducing the Pivot Table -- Customizing Your Pivot Table -- Examples of Filtering Your Data -- Chapter 15: Using Pivot Charts -- Getting Started with Pivot Charts -- Alternatives to Pivot Charts -- Chapter 16: Adding Interactivity with Slicers -- Understanding Slicers -- Creating a Standard Slicer -- Creating a Timeline Slicer -- Using Slicers as Form Controls -- Chapter 17: Using the Internal Data Model and Power View.. - 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 key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively. Details how to analyze large amounts of data and report the results in a way that is both visually attractive and effective Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly Shows how to automate redundant reporting and analysis processes Walks you through creating impressive dashboards, eye-catching visualizations, and real-world What-If analyses Excel Dashboards and Reports, Second Edition is part technical manual, part analytical guidebook, and exactly what you need to become your organization's dashboard dynamo!.
|
| Emner | |
| Sjanger | |
| Dewey | |
| ISBN | 9781118491416
|
| ISBN(galt) |
