Ctrl+shift+enter : [mastering Excel array formulas] / Mike Girvin .
Material type: TextLanguage: English Publisher: Ohio : Holy Macro! Books, 2013Description: vii, 344 páginas : Ilustraciones ; 26 cmContent type: texto Media type: sin mediación Carrier type: volumenISBN: 9781615470075 Other title: Control plus shift plus enter | A book about building efficient formulas, advanced formulas, and array formulas for data analysis and calculating problemsSubject(s): Microsoft Excel (Programa para computador) | Procesamiento electrónico de datos | Procesamiento de datos | Herramientas (Programas para computador)DDC classification: 658.05425Item type | Current library | Collection | Call number | Copy number | Status | Date due | Barcode | Item holds |
---|---|---|---|---|---|---|---|---|
Libros |
Biblioteca CESA
Diagonal 34 A No. 5 A - 23 Casa Incolda PBX: 339 53 00 serviciosbiblioteca@cesa.edu.co |
General | 658.05425 / G529c 2013 (Browse shelf(Opens below)) | Ej.1 | Available | 7110001635 |
Incluye índice.
Incluye referencias bibliográficas.
Formula basics ; Introduction to array formulas ; Math array operations ; Comparative array operations and aggregate calculations with one or more conditions ; Join array operations ; Function argument array operations ; Array constants ;Array formulas that deliver more than one value...
This book systematically lists the aspects, elements and guidelines for array formulas. Array formulas can be insanely difficult. But there are times when an array formula is the only way to accomplish a task. Array formulas can beat filtering, sorting and pivot tables because array formulas will automatically update when the input cells change.
There are no comments on this title.