Custom cover image
Excel dashboards & reports for dummies / Michael Alexander
Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Series: --For dummiesPublisher: Hoboken, New Jersey : John Wiley & Sons, Inc, [2014]Copyright date: ©2014Edition: 2nd editionDescription: Online-Ressource (viii, 326 pages)ISBN:- 1306533147
- 9781306533140
- 1118842243
- 9781118842362
- Excel dashboards and reports for dummies
- Microsoft Excel (Computer file)
- Statistics -- Charts, diagrams, etc
- Business report writing
- Electronic spreadsheets
- Business
- Dashboards (Management information systems)
- Business intelligence -- Computer programs
- Electronic spreadsheets -- Computer programs
- Business intelligence ; Computer programs
- Electronic spreadsheets ; Computer programs
- Electronic books
- Electronic books
- 005.369
- 658.40380285554 23
- 658.4038011
- HF5548.4.M523
- HF5548.4 .M523 2014
Contents:
Summary: Create dynamic dashboards and put your data on display with ForDummiesNo matter what business you’re in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboards Reports For Dummiesis here to help you make meaning of all your data and turn it into clear and actionable visualizations. Fully updated for the latest business intelligence and spreadsheet tools in Excel 2013, this book shows you how to analyze large amounts of data, quickly slice data into various views on the fly, automate redundant reporting, create eye-catching visualizations, and more.Helps you move beyond reporting data with simple tables, rows, and columns to designing high-impact reports, dashboards, and visualsWalks you through a wide array of technical and analytical concepts to give you the background you need to select the right tool for interpreting and displaying dataCovers how to build a chart, work with pivot tables, group and bucket your data, represent trends, create What-If analyses, and increase the value of your reportsExcel Dashboards Reports For Dummies, 2ndEditionis the business analysis tool you need to transform your raw data into a powerful and effective presentation that is accessible to everyone.PPN: PPN: 811769658Package identifier: Produktsigel: ZDB-26-MYL | ZDB-30-PQE | ZDB-30-PBE | ZDB-30-PAD
Title Page; Table of Contents; Introduction; Part I: Getting Started with Excel Dashboards and Reports; Chapter 1: Getting in the Dashboard State of Mind; Chapter 2: Building a Super Model; Part II: Building Basic Dashboard Components; Chapter 3: Dressing Up Your Data Tables; Chapter 4: Sparking Inspiration with Sparklines; Chapter 5: Formatting Your Way to Visualizations; Chapter 6: The Pivotal Pivot Table; Part III: Building Advanced Dashboard Components; Chapter 7: Charts That Show Trending; Chapter 8: Grouping and Bucketing Data; Chapter 9: Displaying Performance against a Target
Part IV: Advanced Reporting TechniquesChapter 10: Macro-Charged Dashboarding; Chapter 11: Giving Users an Interactive Interface; Chapter 12: Adding Interactivity with Pivot Slicers; Part V: Working with the Outside World; Chapter 13: Using External Data for Your Dashboards and Reports; Chapter 14: Sharing Your Workbook with the Outside World; Part VI: The Part of Tens; Chapter 15: Ten Chart Design Principles; Chapter 16: Ten Questions to Ask Before Distributing Your Dashboard; About the Author; Cheat Sheet; More Dummies Products
Table of Contents; Introduction; About This Book; Foolish Assumptions; Icons Used In This Book; Beyond the Book; Where to Go from Here; Part I: Getting Started with Excel Dashboards and Reports; Chapter 1: Getting in the Dashboard State of Mind; Defining Dashboards and Reports; Preparing for Greatness; A Quick Look at Dashboard Design Principles; Chapter 2: Building a Super Model; Data Modeling Best Practices; Excel Functions That Really Deliver; Using Smart Tables That Expand with Data; Part II: Building Basic Dashboard Components; Chapter 3: Dressing Up Your Data Tables
Table Design PrinciplesGetting Fancy with Custom Number Formatting; Chapter 4: Sparking Inspiration with Sparklines; Introducing Sparklines; Understanding Sparklines; Customizing Sparklines; Chapter 5: Formatting Your Way to Visualizations; Enhancing Reports with Conditional Formatting; Using Symbols to Enhance Reporting; The Magical Camera Tool; Chapter 6: The Pivotal Pivot Table; An Introduction to the Pivot Table; The Four Areas of a Pivot Table; Creating Your First Pivot Table; Customizing Your Pivot Table Reports; Creating Useful Pivot-Driven Views
Part III: Building Advanced Dashboard ComponentsChapter 7: Charts That Show Trending; Trending Dos and Don'ts; Comparative Trending; Emphasizing Periods of Time; Other Trending Techniques; Chapter 8: Grouping and Bucketing Data; Creating Top and Bottom Displays; Using Histograms to Track Relationships and Frequency; Emphasizing Top Values in Charts; Chapter 9: Displaying 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 IV: Advanced Reporting TechniquesChapter 10: Macro-Charged Dashboarding; Why Use a Macro?; Recording Your First Macro; Running Your Macros; Enabling and Trusting Macros; Excel Macro Examples; Chapter 11: Giving Users an Interactive Interface; Getting Started with Form Controls; Using the Button Control; Using the Check Box Control; Using the Option Button Control; Option Button Example: Showing Many Views through One Chart; Using the Combo Box Control; Combo Box Example: Changing Chart Data with a Drop-Down Selector; Using the List Box Control; Using the List Box Control
List Box Example: Controlling Multiple Charts with One SelectorChapter 12: Adding Interactivity with Pivot Slicers; Understanding Slicers; Creating a Standard Slicer; Formatting Slicers; Controlling Multiple Pivot Tables with One Slicer; Creating a Timeline Slicer; Using Slicers as Form Controls; Part V: Working with the Outside World; Chapter 13: Using External Data for Your Dashboards and Reports; Importing Data from Microsoft Access; Importing Data from SQL Server; Chapter 14: Sharing Your Workbook with the Outside World; Protecting Your Dashboards and Reports
Linking Your Excel Dashboards to PowerPoint
No physical items for this record