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.
Access 2013 for dummies / / by Laurie Ulrich Fuller and Ken Cook
| Access 2013 for dummies / / by Laurie Ulrich Fuller and Ken Cook |
| Autore | Ulrich Laurie A |
| Edizione | [1] |
| Pubbl/distr/stampa | Wiley, 2013 |
| Descrizione fisica | 1 online resource (459 p.) |
| Disciplina | 005.7565 |
| Collana | --For dummies |
| Soggetto topico | Microsoft Access |
| ISBN |
1-118-56850-8
1-118-56864-8 9781118568644 |
| Classificazione | 007.63 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Microsoft Access 2013 For Dummies; About the Authors; Contents at a Glance; Table of Contents; Introduction; About This Book; Conventions Used in This Book; What You Don't Have to Read; Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Where to Go from Here; Part I: Getting Started with Access 2013; Chapter 1: Access 2013 Basic Training; What Is Access Good For, Anyway?; What's New in Access 2013?; How Access Works and How You Work with It; Now What?; Chapter 2: Navigating the Access Workspace; Diving Right In; Working with Onscreen Tools in Access
Customizing the Access Workspace Mousing Around; Navigating Access with the Alt Key; Chapter 3: Database Basics; Database Lingo; Field Types and Uses; Choosing Between Flat and Relational Databases; Building a Database; Adding and Removing Tables; Part II: Setting the Table; Chapter 4: Table Tune Ups; The Primary Key to Success; Making Tables Get Along; Building Table Relationships; Indexing for Faster Queries; Chapter 5: Remodeling Your Data; Opening a Table for Editing; Inserting Records and Fields; Modifying Field Content; Name-Calling; Turn Uh-Oh! into Yee-Hah! Chapter 6: Types, Masks, and Triggers Access Table Settings; Field Data Formats; Gaining Control of Data Entry; Give Your Fingers a Mini Vacation by Default; Part III: Data Management Mania; Chapter 7: A Form for All Reasons; Generating Forms; Customizing Form Parts; Chapter 8: Importing and Exporting Data; Retrieving Data from Other Sources; Hit the Road, Data; Chapter 9: Automatic Data Editing; Please Read This First!; Creating Consistent Corrections; Using Queries to Automate the Editing Process; Chapter 10: Access and the Web; How Access Works with the Web; Understanding Office 365 Meet the Custom Web App Click! Using Hyperlinks in Your Access Database; Embedding Web Content into Your Access Forms; Publishing Your Data to the Web; Part IV: Ask Your Data, and Ye Shall Receive Answers; Chapter 11: Finding, Filtering, and Sorting Your Data - Fast; Using the Find Command; Sorting from A to Z or Z to A; Fast and Furious Filtering; Chapter 12: I was Just Asking...for Answers; Simple ( Yet Potent) Filter and Sort Tools; Select Queries; Getting Your Feet Wet with Ad Hoc Queries; Chapter 13: I Want These AND Those OR Them; Working with AND and/or OR Combining AND with OR and OR with AND Chapter 14: Number Crunching with the Total Row; Kissing That Calculator Goodbye via the Total Row; Adding the Total Row to Your Queries; Giving the Total Row a Workout; Creating Your Own Top-Ten List; Choosing the Right Field for the Summary Instruction; Chapter 15: Express Yourself with Formulas; A Simple Calculation; Complex Calculations; Hooray for the Expression Builder; Chapter 16: Take Charge with Action Queries; Easy Update; Add Records in a Flash; Quick Cleanup; Part V: Simple and Snazzy Reporting; Chapter 17: Fast and Furious Automatic Reporting Quick and Not-So-Dirty Automatic Reporting |
| Record Nr. | UNINA-9911137665003321 |
Ulrich Laurie A
|
||
| Wiley, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Access 2013 for dummies / / by Laurie Ulrich Fuller and Ken Cook
| Access 2013 for dummies / / by Laurie Ulrich Fuller and Ken Cook |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2013 |
| Descrizione fisica | 1 online resource (459 p.) |
| Disciplina | 005.7565 |
| Collana | --For dummies |
| Soggetto topico | Microsoft Access |
| ISBN |
1-118-56850-8
1-118-56864-8 9781118568644 |
| Classificazione | 007.63 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Microsoft Access 2013 For Dummies; About the Authors; Contents at a Glance; Table of Contents; Introduction; About This Book; Conventions Used in This Book; What You Don't Have to Read; Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Where to Go from Here; Part I: Getting Started with Access 2013; Chapter 1: Access 2013 Basic Training; What Is Access Good For, Anyway?; What's New in Access 2013?; How Access Works and How You Work with It; Now What?; Chapter 2: Navigating the Access Workspace; Diving Right In; Working with Onscreen Tools in Access
Customizing the Access Workspace Mousing Around; Navigating Access with the Alt Key; Chapter 3: Database Basics; Database Lingo; Field Types and Uses; Choosing Between Flat and Relational Databases; Building a Database; Adding and Removing Tables; Part II: Setting the Table; Chapter 4: Table Tune Ups; The Primary Key to Success; Making Tables Get Along; Building Table Relationships; Indexing for Faster Queries; Chapter 5: Remodeling Your Data; Opening a Table for Editing; Inserting Records and Fields; Modifying Field Content; Name-Calling; Turn Uh-Oh! into Yee-Hah! Chapter 6: Types, Masks, and Triggers Access Table Settings; Field Data Formats; Gaining Control of Data Entry; Give Your Fingers a Mini Vacation by Default; Part III: Data Management Mania; Chapter 7: A Form for All Reasons; Generating Forms; Customizing Form Parts; Chapter 8: Importing and Exporting Data; Retrieving Data from Other Sources; Hit the Road, Data; Chapter 9: Automatic Data Editing; Please Read This First!; Creating Consistent Corrections; Using Queries to Automate the Editing Process; Chapter 10: Access and the Web; How Access Works with the Web; Understanding Office 365 Meet the Custom Web App Click! Using Hyperlinks in Your Access Database; Embedding Web Content into Your Access Forms; Publishing Your Data to the Web; Part IV: Ask Your Data, and Ye Shall Receive Answers; Chapter 11: Finding, Filtering, and Sorting Your Data - Fast; Using the Find Command; Sorting from A to Z or Z to A; Fast and Furious Filtering; Chapter 12: I was Just Asking...for Answers; Simple ( Yet Potent) Filter and Sort Tools; Select Queries; Getting Your Feet Wet with Ad Hoc Queries; Chapter 13: I Want These AND Those OR Them; Working with AND and/or OR Combining AND with OR and OR with AND Chapter 14: Number Crunching with the Total Row; Kissing That Calculator Goodbye via the Total Row; Adding the Total Row to Your Queries; Giving the Total Row a Workout; Creating Your Own Top-Ten List; Choosing the Right Field for the Summary Instruction; Chapter 15: Express Yourself with Formulas; A Simple Calculation; Complex Calculations; Hooray for the Expression Builder; Chapter 16: Take Charge with Action Queries; Easy Update; Add Records in a Flash; Quick Cleanup; Part V: Simple and Snazzy Reporting; Chapter 17: Fast and Furious Automatic Reporting Quick and Not-So-Dirty Automatic Reporting |
| Record Nr. | UNINA-9911106657803321 |
| Hoboken, NJ, : Wiley, c2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Embedded systems : a contemporary design tool / / James K. Peckol
| Embedded systems : a contemporary design tool / / James K. Peckol |
| Edizione | [2nd ed] |
| Pubbl/distr/stampa | Hoboken, N.J., : Wiley, 2019 |
| Descrizione fisica | 1 online resource (1,082 pages) |
| Disciplina | 006.22 |
| Soggetto topico |
Embedded computer systems
Object-oriented methods (Computer science) |
| ISBN |
1-119-45755-6
1-5231-2807-0 1-119-45749-1 9781119457497 |
| Classificazione |
007.63
006.2/2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9911007085103321 |
| Hoboken, N.J., : Wiley, 2019 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel 2013 all-in-one for dummies / / by Greg Harvey
| Excel 2013 all-in-one for dummies / / by Greg Harvey |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2013 |
| Descrizione fisica | 1 online resource (795 p.) |
| Disciplina | 005.54 |
| Collana | --For dummies |
| Soggetto topico | Microsoft Excel (Computer file) |
| ISBN |
1-118-55018-8
9781118550182 |
| Classificazione | 007.63 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Excel® 2013 All-in-One For Dummies®; Table of Contents; Introduction; About This Book; Foolish Assumptions; How This Book Is Organized; Conventions Used in This Book; Icons Used in This Book; Where to Go from Here; Book I: Excel Basics; Contents at a Glance; Contents at a Glance; Chapter 1: The Excel 2013 User Experience; Excel 2013's New Look and Feel; Excel's Start Screen; Excel's Ribbon User Interface; Getting Help; Launching and Quitting Excel; Chapter 2: Customizing Excel 2013; Tailoring the Quick Access Toolbar to Your Tastes; Exercising Your Options; Using Office Apps; Add-In Mania
Book II: Worksheet DesignContents at a Glance; Chapter 1: Building Worksheets; Designer Spreadsheets; It Takes All Kinds (Of Cell Entries); Data Entry 101; Saving the Data; Document Recovery to the Rescue; Chapter 2: Formatting Worksheets; Making Cell Selections; Adjusting Columns and Rows; Formatting Tables from the Ribbon; Formatting Tables with the Quick Analysis Tool; Formatting Cells from the Ribbon; Formatting Cell Ranges with the Mini-Toolbar; Using the Format Cells Dialog Box; Hiring Out the Format Painter; Using Cell Styles; Conditional Formatting Chapter 3: Editing and Proofing WorksheetsOpening a Workbook; Cell Editing 101; A Spreadsheet with a View; Copying and Moving Stuff Around; Find and Replace This Disgrace!; Spell Checking Heaven; Looking Up and Translating Stuff; Marking Invalid Data; Eliminating Errors with Text to Speech; Chapter 4: Managing Worksheets; Reorganizing the Worksheet; Reorganizing the Workbook; Working with Multiple Workbooks; Consolidating Worksheets; Chapter 5: Printing Worksheets; Printing from the Excel 2013 Backstage View; Quick Printing the Worksheet; Working with the Page Setup Options Headers and FootersSolving Page Break Problems; Printing the Formulas in a Report; Book III: Formulas and Functions; Contents at a Glance; Chapter 1: Building Basic Formulas; Formulas 101; Copying Formulas; Adding Array Formulas; Range Names in Formulas; Adding Linking Formulas; Controlling Formula Recalculation; Circular References; Chapter 2: Logical Functions and Error Trapping; Understanding Error Values; Using Logical Functions; Error-Trapping Formulas; Whiting-Out Errors with Conditional Formatting; Formula Auditing; Removing Errors from the Printout; Chapter 3: Date and Time Formulas Understanding Dates and TimesUsing Date Functions; Using Time Functions; Chapter 4: Financial Formulas; Financial Functions 101; The PV, NPV, and FV Functions; The PMT Function; Depreciation Functions; Analysis ToolPak Financial Functions; Chapter 5: Math and Statistical Formulas; Math & Trig Functions; Statistical Functions; Chapter 6: Lookup, Information, and Text Formulas; Lookup and Reference; Information, Please . . .; Much Ado about Text; Book IV: Worksheet Collaboration and Review; Contents at a Glance; Chapter 1: Protecting Workbooks and Worksheet Data; Password-Protecting the File Protecting the Spreadsheet |
| Record Nr. | UNINA-9911096084503321 |
| Hoboken, NJ, : Wiley, c2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel 2013 all-in-one for dummies / / by Greg Harvey
| Excel 2013 all-in-one for dummies / / by Greg Harvey |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2013 |
| Descrizione fisica | 1 online resource (795 p.) |
| Disciplina | 005.54 |
| Collana | --For dummies |
| Soggetto topico | Microsoft Excel (Computer file) |
| ISBN |
1-118-55018-8
9781118550182 |
| Classificazione | 007.63 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Excel® 2013 All-in-One For Dummies®; Table of Contents; Introduction; About This Book; Foolish Assumptions; How This Book Is Organized; Conventions Used in This Book; Icons Used in This Book; Where to Go from Here; Book I: Excel Basics; Contents at a Glance; Contents at a Glance; Chapter 1: The Excel 2013 User Experience; Excel 2013's New Look and Feel; Excel's Start Screen; Excel's Ribbon User Interface; Getting Help; Launching and Quitting Excel; Chapter 2: Customizing Excel 2013; Tailoring the Quick Access Toolbar to Your Tastes; Exercising Your Options; Using Office Apps; Add-In Mania
Book II: Worksheet DesignContents at a Glance; Chapter 1: Building Worksheets; Designer Spreadsheets; It Takes All Kinds (Of Cell Entries); Data Entry 101; Saving the Data; Document Recovery to the Rescue; Chapter 2: Formatting Worksheets; Making Cell Selections; Adjusting Columns and Rows; Formatting Tables from the Ribbon; Formatting Tables with the Quick Analysis Tool; Formatting Cells from the Ribbon; Formatting Cell Ranges with the Mini-Toolbar; Using the Format Cells Dialog Box; Hiring Out the Format Painter; Using Cell Styles; Conditional Formatting Chapter 3: Editing and Proofing WorksheetsOpening a Workbook; Cell Editing 101; A Spreadsheet with a View; Copying and Moving Stuff Around; Find and Replace This Disgrace!; Spell Checking Heaven; Looking Up and Translating Stuff; Marking Invalid Data; Eliminating Errors with Text to Speech; Chapter 4: Managing Worksheets; Reorganizing the Worksheet; Reorganizing the Workbook; Working with Multiple Workbooks; Consolidating Worksheets; Chapter 5: Printing Worksheets; Printing from the Excel 2013 Backstage View; Quick Printing the Worksheet; Working with the Page Setup Options Headers and FootersSolving Page Break Problems; Printing the Formulas in a Report; Book III: Formulas and Functions; Contents at a Glance; Chapter 1: Building Basic Formulas; Formulas 101; Copying Formulas; Adding Array Formulas; Range Names in Formulas; Adding Linking Formulas; Controlling Formula Recalculation; Circular References; Chapter 2: Logical Functions and Error Trapping; Understanding Error Values; Using Logical Functions; Error-Trapping Formulas; Whiting-Out Errors with Conditional Formatting; Formula Auditing; Removing Errors from the Printout; Chapter 3: Date and Time Formulas Understanding Dates and TimesUsing Date Functions; Using Time Functions; Chapter 4: Financial Formulas; Financial Functions 101; The PV, NPV, and FV Functions; The PMT Function; Depreciation Functions; Analysis ToolPak Financial Functions; Chapter 5: Math and Statistical Formulas; Math & Trig Functions; Statistical Functions; Chapter 6: Lookup, Information, and Text Formulas; Lookup and Reference; Information, Please . . .; Much Ado about Text; Book IV: Worksheet Collaboration and Review; Contents at a Glance; Chapter 1: Protecting Workbooks and Worksheet Data; Password-Protecting the File Protecting the Spreadsheet |
| Record Nr. | UNINA-9911131715703321 |
| Hoboken, NJ, : Wiley, c2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel 2013 for dummies / / by Greg Harvey
| Excel 2013 for dummies / / by Greg Harvey |
| Autore | Harvey Greg |
| Edizione | [1] |
| Pubbl/distr/stampa | Wiley, 2013 |
| Descrizione fisica | 1 online resource (411 p.) |
| Disciplina | 005.54 |
| Collana | --For dummies |
| Soggetto topico | Microsoft Excel (Computer file) |
| ISBN |
1-118-55012-9
9781118550120 |
| Classificazione | 007.63 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. I. Getting started with Excel 2013 -- pt. II. Editing without tears -- pt. III. Getting organized and staying that way -- pt. IV. Digging data analysis -- pt. V. Life beyond the spreadsheet -- pt. VI. The part of tens. |
| Record Nr. | UNINA-9911150863603321 |
|
Harvey Greg
|
||
| Wiley, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel 2013 for dummies / / by Greg Harvey
| Excel 2013 for dummies / / by Greg Harvey |
| Pubbl/distr/stampa | Hoboken, NJ, : Wiley, c2013 |
| Descrizione fisica | 1 online resource (411 p.) |
| Disciplina | 005.54 |
| Collana | --For dummies |
| Soggetto topico | Microsoft Excel (Computer file) |
| ISBN |
1-118-55012-9
9781118550120 |
| Classificazione | 007.63 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. I. Getting started with Excel 2013 -- pt. II. Editing without tears -- pt. III. Getting organized and staying that way -- pt. IV. Digging data analysis -- pt. V. Life beyond the spreadsheet -- pt. VI. The part of tens. |
| Record Nr. | UNINA-9911105666203321 |
| Hoboken, NJ, : Wiley, c2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel 2019 bible / / Michael Alexander, Dick Kusleika, previously by John Walkenbach
| Excel 2019 bible / / Michael Alexander, Dick Kusleika, previously by John Walkenbach |
| Autore | Alexander Michael |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Wiley, 2018 |
| Descrizione fisica | 1 online resource (1,123 pages) |
| Disciplina | 005.369 |
| Soggetto topico |
Microsoft Excel (Computer file)
Business -- Computer programs Electronic spreadsheets |
| ISBN |
1-119-51476-2
1-119-54937-X 1-119-51477-0 9781119514770 |
| Classificazione |
007.63
005.54 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Introduction Part I: Getting Started with Excel Part II: Working with Formulas and Functions Part III: Creating Charts and Other Visualizations Part IV: Managing and Analyzing Data Part V: Understanding Power Pivot and Power Query Part VI: Automating Excel End User License Agreement |
| Record Nr. | UNINA-9910526529603321 |
|
Alexander Michael
|
||
| Wiley, 2018 | ||
| 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 | ||
| ||
Excel dashboards & reports for dummies / / by Michael Alexander
| Excel dashboards & reports for dummies / / by Michael Alexander |
| Edizione | [2nd ed] |
| Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2014 |
| Descrizione fisica | 1 online resource (339 p.) |
| Disciplina | 658.4038011 |
| Collana | --For dummies |
| Soggetto topico | Microsoft Excel (Computer file) |
| ISBN |
1-118-84236-7
9781118842362 |
| 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-9911109406603321 |
| Hoboken, N.J., : Wiley, c2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
