Autore |
Girvin Mike
|
Pubbl/distr/stampa |
Uniontown, OH, : Holy Macro! Books, 2013
|
Descrizione fisica |
1 online resource (353 p.)
|
Disciplina |
005.54
|
Soggetto topico |
Electronic spreadsheets - Computer programs
|
ISBN |
1-61547-209-6
1-61547-109-X
|
Formato |
Materiale a stampa ![](img/format/mas.png) |
Livello bibliografico |
Monografia |
Lingua di pubblicazione |
eng
|
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.
|
Record Nr. | UNINA-9910814971103321 |