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 best practices for business / / Loren Abdulezer
| Excel best practices for business / / Loren Abdulezer |
| Autore | Abdulezer Loren |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub., c2004 |
| Descrizione fisica | 1 online resource (547 p.) |
| Disciplina | 005.54 |
| Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
| ISBN |
1-280-35184-5
9786610351848 0-7645-5756-4 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Excel Best Practices for Business; About the Author; Credits; Preface; Acknowledgments; Contents at a Glance; Contents; Introduction; How to Use This Book; What You Need to Use This Book; What This Book Covers; Conventions Used in this Book; Icons Used in the Book; How This Book Is Organized; Part I: Best Practice Essentials; Chapter 1: A Foundation for Developing Best Practices; Preliminaries; Working with Different Ways To Compute a Number in Excel; Understanding Alternative Ways to Represent Cells; Computing a Number in Excel; Excel Functions; Closing Thoughts
Chapter 2: Mastering Spreadsheet Construction Techniques One Size Does Not Fit All; Understanding Simple Spreadsheets; Building a Spreadsheet: A Simple Example; Complex Spreadsheets; Closing Thoughts; Chapter 3: Your Handy Reference for Manipulating Data; Excel String Manipulation Functions You Need to Know; Sorting Techniques; First Steps to Tidying Up Your Data; The Sentinel Look Ahead Technique; Other Functions for Effective Data Manipulation; Useful Sorting Techniques; Data Surgery and Data Manipulation; Closing Thoughts; Chapter 4: Compiling, Managing, and Viewing Your Data; Preliminaries The Number Line-Up Putting Data into Perspective with Pivot Tables; Preparing Your Data; Closing Thoughts; Part II: Spreadsheet Ergonomics; Chapter 5: Scaling the Peaks of Mt. Data; The Art of Data Slogging; Climbing Past the Foothills; Closing Thoughts; Chapter 6: Let the Data Speak for Itself: Viewing and Presenting Data; They Threw In the Kitchen Sink; Using Excel Filters; Presentation Tear Sheets; Advanced Filters; Tips for Spreadsheet Comments; Closing Thoughts; Chapter 7: Creating and Using Smart Data; What Is Smart Data, Anyhow?; Conditional Formatting From RAGs to Riches: An Interactive Array of Colors Perimeter Surveillance: Smart Borders; Miscellaneous Topics; Closing Thoughts; Chapter 8: Analyzing Data; Charting Your Course in a Sea of Data; Quantifying Uncertainty: Techniques and Rules; Data Sculpting: Crafting Data with the Excel Goal Seek and Solver Tools; Suggestions for Further Reading; Closing Thoughts; Chapter 9: How Not to Get Stuck in the MUD ( Messed-Up Data); Ambiguous and Incomplete Data; Inconsistent Data and Computations; Square Peg/Round Hole Scenario; Analyses/Reports Built on Too Much White Noise or Static Closing Thoughts Part III: Special Topics: Getting the Numbers Right; Chapter 10: Going for the Face lift: Spreadsheet Makeovers; Spreadsheet Makeover Techniques; A Hands-On Example of a Spreadsheet Makeover; Alternative Approaches; Closing Thoughts; Chapter 11: Spreadsheet Auditing: Challenging the Numbers of Others; Structural Analysis of Spreadsheets; Off-Spreadsheet Analysis; State Transition Analysis; Testing the Reasonableness of Spreadsheets; Closing Thoughts; Chapter 12: Spreadsheet Portals, XML, and Web Services; Spreadsheet Portals and Desktop Client Portals; Simple Client Portals Complex Spreadsheet Portals |
| Record Nr. | UNINA-9910819430103321 |
Abdulezer Loren
|
||
| Indianapolis, IN, : Wiley Pub., c2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel dashboards & reports [[electronic resource] /] / Michael Alexander and John Walkenbach
| Excel dashboards & reports [[electronic resource] /] / Michael Alexander and John Walkenbach |
| Autore | Alexander Michael <1972-> |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, Ind., : Wiley, 2010 |
| Descrizione fisica | 1 online resource (457 p.) |
| Disciplina | 658.40380285554 |
| Altri autori (Persone) | WalkenbachJohn |
| Collana | Mr. Spreadsheet's bookshelf |
| Soggetto topico |
Dashboards (Management information systems)
Statistics Business report writing Electronic spreadsheets |
| Soggetto genere / forma | Electronic books. |
| ISBN |
0-470-92073-4
1-62198-435-4 1-282-75638-9 9786612756382 1-118-25750-2 0-470-92071-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. 1. Moving from spreadsheets to dashboards -- pt. 2. Excel chart basics -- pt. 3. Going beyond tables and charts -- pt. 4. Creating advanced dashboard components -- pt. 5. Automating your dashboards and reports -- pt. 6. Working with the outside world. |
| Record Nr. | UNINA-9910140820203321 |
|
Alexander Michael <1972->
|
||
| Indianapolis, Ind., : Wiley, 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel dashboards & reports [[electronic resource] /] / Michael Alexander and John Walkenbach
| Excel dashboards & reports [[electronic resource] /] / Michael Alexander and John Walkenbach |
| Autore | Alexander Michael <1972-> |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, Ind., : Wiley, 2010 |
| Descrizione fisica | 1 online resource (457 p.) |
| Disciplina | 658.40380285554 |
| Altri autori (Persone) | WalkenbachJohn |
| Collana | Mr. Spreadsheet's bookshelf |
| Soggetto topico |
Dashboards (Management information systems)
Statistics Business report writing Electronic spreadsheets |
| ISBN |
0-470-92073-4
1-62198-435-4 1-282-75638-9 9786612756382 1-118-25750-2 0-470-92071-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. 1. Moving from spreadsheets to dashboards -- pt. 2. Excel chart basics -- pt. 3. Going beyond tables and charts -- pt. 4. Creating advanced dashboard components -- pt. 5. Automating your dashboards and reports -- pt. 6. Working with the outside world. |
| Record Nr. | UNINA-9910830980803321 |
|
Alexander Michael <1972->
|
||
| Indianapolis, Ind., : Wiley, 2010 | ||
| 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 |
| 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 | 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-9910822640203321 |
|
Alexander Michael
|
||
| Hoboken, : Wiley, 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel for accountants [[electronic resource] /] / Conrad Carlberg
| Excel for accountants [[electronic resource] /] / Conrad Carlberg |
| Autore | Carlberg Conrad George |
| Pubbl/distr/stampa | Philadelphia, Pa., : CPA911 Pub., 2007 |
| Descrizione fisica | 1 online resource (290 p.) |
| Disciplina |
005.54
006.754 |
| Soggetto topico |
Accounting - Data processing
Electronic spreadsheets |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-932925-08-2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Cover; Table of Contents; Acknowledgments; From the Author; Download the Example Files; Chapter 1: Using Lists in Excel; Chapter 2: Pivot Tables; Chapter 3: Common Sizing Using Worksheets; Chapter 4: Charting; Chapter 5: Tools for Accountants; Chapter 6: Scenarios In Excel; Chapter 7: Payment Functions; Chapter 8: Excel's Depreciation Functions; Chapter 9: Excel and QuickBooks; Appendix A: From the Web to Excel; Index |
| Record Nr. | UNINA-9910453973503321 |
|
Carlberg Conrad George
|
||
| Philadelphia, Pa., : CPA911 Pub., 2007 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel for chemists : a comprehensive guide / / E. Joseph Billo
| Excel for chemists : a comprehensive guide / / E. Joseph Billo |
| Autore | Billo E. Joseph |
| Edizione | [3rd ed.] |
| Pubbl/distr/stampa | Hoboken, N.J., : John Wiley & Sons, c2011 |
| Descrizione fisica | 1 online resource (xxvii, 764 pages) : illustrations (chiefly colour) |
| Disciplina | 542/.85 |
| Soggetto topico |
Electronic spreadsheets
Chemistry - Data processing |
| ISBN |
1-283-33212-4
9786613332127 1-118-09394-1 1-118-09395-X 1-118-09393-3 |
| Classificazione | SCI013000 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | PART I THE BASICS -- Chapter 1 Working with Excel 2007 or Excel 2010 -- Chapter 2 Working with Excel 2003 -- Chapter 3 Excel Formulas and Functions -- Chapter 4 Excel 2007/2010 Charts -- Chapter 5 Excel 2003 Charts -- PART II ADVANCED SPREADSHEET TOPICS -- Chapter 6 Advanced Worksheet Formulas -- Chapter 7 Array Formulas -- Chapter 8 Advanced Charting Techniques -- Chapter 9 Using Excel's Database Features -- Chapter 10 Importing Data into Excel -- Chapter 11 Adding Controls to a Spreadsheet -- Chapter 12 Other Language Versions of Excel -- PART III SPREADSHEET MATHEMATICS -- Chapter 13 Mathematical Methods for Spreadsheet Calculations -- Chapter 14 Linear Regression and Curve Fitting -- Chapter 15 Nonlinear Regression Using the Solver -- PART IV EXCEL'S VISUAL BASIC FOR APPLICATIONS -- Chapter 16 Visual Basic for Applications: An Introduction -- Chapter 17 Programming with VBA -- Chapter 18 Working with Arrays in VBA -- PART V SOME APPLICATIONS OF VBA -- Chapter 19 Command Macros -- Chapter 20 Custom Functions -- Chapter 21 Automatic Procedures -- Chapter 22 Custom Menus -- Chapter 23 Custom Toolbars and Toolbuttons -- PART VI APPENDICES -- Appendix A What's Where in Excel 2007/2010 -- Appendix B Selected Worksheet Functions by Category -- Appendix C Alphabetical List of Selected Worksheet Functions -- Appendix D Renamed Functions in Excel 2010 -- Appendix E Selected Visual Basic Keywords by Category -- Appendix F Alphabetical List of Selected Visual Basic Keywords -- Appendix G Selected Excel 4 Macro Functions -- Appendix H Shortcut Keys by Keystroke -- Appendix I Selected Shortcut Keys by Category -- Appendix J ASCII Codes -- Appendix K Contents of the CD-ROM. |
| Record Nr. | UNINA-9910139563103321 |
|
Billo E. Joseph
|
||
| Hoboken, N.J., : John Wiley & Sons, c2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel for scientists [[electronic resource] /] / by Gerard M. Verschuuren
| Excel for scientists [[electronic resource] /] / by Gerard M. Verschuuren |
| Autore | Verschuuren G. M. N (Geert M. N.) |
| Pubbl/distr/stampa | Uniontown, Ohio, : Holy Macro Books, c2005 |
| Descrizione fisica | 1 online resource (180 p.) |
| Disciplina | 005.36 |
| Collana | Excel for Professionals series |
| Soggetto topico |
Electronic spreadsheets
Engineering - Data processing Science - Data processing |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-61547-313-0
1-932802-62-2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Title Page; Copyright Page; Table of Contents; About the Author; Prologue; Chapter I: General Techniques; Making Copies and Trends; Understanding Relative versus Absolute; Telling Appearance from Reality; Managing Dates; Putting Functions Inside Functions; Chapter II: Statistical Analysis; Understanding Sampling Distributions; Estimating with Confidence; Testing with Significance; Chapter III: Plotting Graphs; Types of Charts; Manipulating Graphs; Adding an extra axis; Line Charts versus XY Charts; Using Error Bars; Using Histograms; Configuring Default Graphs; Putting Inserts in Graphs
Adding Special EffectsWorking with Dynamic Ranges; Chapter IV: Regression Analysis; Mono-factorial and Linear; Curve Fitting; Multiple Regression; Chapter V: Complex Functions; Fancy Functions; Array Formulas; Homemade Functions; Solving Equations; Chapter VI: Data Analysis; Validation; Sorting Records; Creating Subtotals; Using Data Filters; Database Functions; Calculated Criteria; Marked Records; Appendix A: Answers to Exercises |
| Record Nr. | UNINA-9910454417703321 |
|
Verschuuren G. M. N (Geert M. N.)
|
||
| Uniontown, Ohio, : Holy Macro Books, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel for scientists [[electronic resource] /] / by Gerard M. Verschuuren
| Excel for scientists [[electronic resource] /] / by Gerard M. Verschuuren |
| Autore | Verschuuren G. M. N (Geert M. N.) |
| Pubbl/distr/stampa | Uniontown, Ohio, : Holy Macro Books, c2005 |
| Descrizione fisica | 1 online resource (180 p.) |
| Disciplina | 005.36 |
| Collana | Excel for Professionals series |
| Soggetto topico |
Electronic spreadsheets
Engineering - Data processing Science - Data processing |
| ISBN |
1-61547-313-0
1-932802-62-2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Title Page; Copyright Page; Table of Contents; About the Author; Prologue; Chapter I: General Techniques; Making Copies and Trends; Understanding Relative versus Absolute; Telling Appearance from Reality; Managing Dates; Putting Functions Inside Functions; Chapter II: Statistical Analysis; Understanding Sampling Distributions; Estimating with Confidence; Testing with Significance; Chapter III: Plotting Graphs; Types of Charts; Manipulating Graphs; Adding an extra axis; Line Charts versus XY Charts; Using Error Bars; Using Histograms; Configuring Default Graphs; Putting Inserts in Graphs
Adding Special EffectsWorking with Dynamic Ranges; Chapter IV: Regression Analysis; Mono-factorial and Linear; Curve Fitting; Multiple Regression; Chapter V: Complex Functions; Fancy Functions; Array Formulas; Homemade Functions; Solving Equations; Chapter VI: Data Analysis; Validation; Sorting Records; Creating Subtotals; Using Data Filters; Database Functions; Calculated Criteria; Marked Records; Appendix A: Answers to Exercises |
| Record Nr. | UNINA-9910782762103321 |
|
Verschuuren G. M. N (Geert M. N.)
|
||
| Uniontown, Ohio, : Holy Macro Books, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
