Ctrl+shift+enter [[electronic resource] ] : mastering Excel array formulas / / Mike Girvin
(Visualizza in formato marc)
(Visualizza in BIBFRAME)
| Autore: |
Girvin Mike
|
| Titolo: |
Ctrl+shift+enter [[electronic resource] ] : mastering Excel array formulas / / Mike Girvin
|
| Pubblicazione: | Uniontown, OH, : Holy Macro! Books, 2013 |
| Descrizione fisica: | 1 online resource (353 p.) |
| Disciplina: | 005.54 |
| Soggetto topico: | Electronic spreadsheets - Computer programs |
| Note generali: | Subtitle from cover. |
| Includes index. | |
| Nota di contenuto: | Front Cover -- Title page -- Copyright page -- Contents -- Dedications -- About the Author -- Acknowledgements -- Introduction -- Chapter 1: Formula Basics -- Chapter 2: Introduction to Array Formulas -- Chapter 3: Math Array Operations -- Chapter 4: Comparative Array Operations and Aggregate Calculations with One or More Conditions -- Chapter 5: Join Array Operations -- Chapter 6: Function Argument Array Operations -- Chapter 7: Array Constants -- Chapter 8: Array Formulas That Deliver More Than One Value -- Chapter 9: A First Look at Array Functions: TRANSPOSE, MODE.MULT, and TREND -- Chapter 10: The Amazing SUMPRODUCT Function (and SUMIFS, Too) -- Chapter 11: Boolean Logic: AND Criteria and OR Criteria -- Chapter 12: When Is an Array Formula Really Needed? -- Chapter 13: Dynamic Ranges with the INDEX and OFFSET Functions -- Chapter 14: Array Formula Efficiency Rules -- Chapter 15: Extracting Data, Based on Criteria -- Chapter 16: The FREQUENCY Array Function -- Chapter 17: Unique Counting Formulas and the Power of the FREQUENCY Function -- Chapter 18: The MMULT Array Function -- Chapter 19: Extracting Unique Lists and Sorting Formulas -- Chapter 20: Conditional Formatting with Array Formulas -- Chapter 21: Data Tables -- Chapter 22: The LINEST Array Function -- Chapter 23: Can You Figure Out How the Huge Array Formula Works? -- Conclusion -- Index. |
| Sommario/riassunto: | Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots. |
| Titolo autorizzato: | Ctrl+shift+enter |
| ISBN: | 1-61547-209-6 |
| 1-61547-109-X | |
| Formato: | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione: | Inglese |
| Record Nr.: | 9910814971103321 |
| Lo trovi qui: | Univ. Federico II |
| Opac: | Controlla la disponibilità qui |