Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Excel Dashboards & Reports For Dummies [[electronic resource]]
| Excel Dashboards & Reports For Dummies [[electronic resource]] |
| Autore | Alexander Michael |
| Edizione | [2nd ed.] |
| Pubbl/distr/stampa | Hoboken, : Wiley, 2014 |
| Descrizione fisica | 1 online resource (339 p.) |
| Disciplina | 658.4038011 |
| Collana | For dummies Excel dashboards & reports for dummies |
| Soggetto topico |
Business intelligence -- Computer programs
Dashboards (Management information systems) Electronic spreadsheets Microsoft Excel (Computer file) Dashboards (Management information systems) - Computer programs Statistics Business report writing Business Management Commerce Business & Economics Management Styles & Communication Marketing & Sales |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-118-84236-7 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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 |
| Record Nr. | UNINA-9910464958603321 |
Alexander Michael
|
||
| Hoboken, : Wiley, 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel Dashboards & Reports For Dummies [[electronic resource]]
| Excel Dashboards & Reports For Dummies [[electronic resource]] |
| Autore | Alexander Michael |
| Edizione | [2nd ed.] |
| Pubbl/distr/stampa | Hoboken, : Wiley, 2014 |
| Descrizione fisica | 1 online resource (339 p.) |
| Disciplina | 658.4038011 |
| Collana | For dummies Excel dashboards & reports for dummies |
| Soggetto topico |
Business intelligence -- Computer programs
Dashboards (Management information systems) Electronic spreadsheets Microsoft Excel (Computer file) Dashboards (Management information systems) - Computer programs Statistics Business report writing Business Management Commerce Business & Economics Management Styles & Communication Marketing & Sales |
| ISBN | 1-118-84236-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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 |
| Record Nr. | UNINA-9910789010303321 |
|
Alexander Michael
|
||
| Hoboken, : Wiley, 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel Dashboards & Reports For Dummies
| Excel Dashboards & Reports For Dummies |
| Autore | Alexander Michael |
| Edizione | [2nd ed.] |
| Pubbl/distr/stampa | Hoboken, : Wiley, 2014 |
| Descrizione fisica | 1 online resource (339 p.) |
| Disciplina | 658.4038011 |
| Collana | For dummies Excel dashboards & reports for dummies |
| Soggetto topico |
Business intelligence -- Computer programs
Dashboards (Management information systems) Electronic spreadsheets Microsoft Excel (Computer file) Dashboards (Management information systems) - Computer programs Statistics Business report writing Business Management Commerce Business & Economics Management Styles & Communication Marketing & Sales |
| ISBN |
9781118842362
1118842367 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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 |
| Altri titoli varianti |
--For dummies
Excel dashboards & reports for dummies Excel Dashboards and Reports for Dummies |
| Record Nr. | UNINA-9910968311503321 |
|
Alexander Michael
|
||
| Hoboken, : Wiley, 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel Dashboards & Reports For Dummies
| Excel Dashboards & Reports For Dummies |
| Edizione | [2nd ed.] |
| Pubbl/distr/stampa | Hoboken, : Wiley, 2014 |
| Descrizione fisica | 1 online resource (339 p.) |
| Disciplina | 658.4038011 |
| Collana | For dummies Excel dashboards & reports for dummies |
| Soggetto topico |
Business intelligence -- Computer programs
Dashboards (Management information systems) Electronic spreadsheets Microsoft Excel (Computer file) Dashboards (Management information systems) - Computer programs Statistics Business report writing Business Management Commerce Business & Economics Management Styles & Communication Marketing & Sales |
| ISBN | 1-118-84236-7 |
| Classificazione | 007.63 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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 |
| Record Nr. | UNINA-9910822640203321 |
| Hoboken, : Wiley, 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||