Up up and array! : dynamic array formulas for Excel 365 and beyond /

Understand the power of dynamic arrays: a single formula can generate new and vastly more efficient spreadsheet possibilities. This book introduces spreadsheet users to dynamic array functions in Microsoft Excel 365, defines and details the distinctive ways in which they work, and shows how they can...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Katz, Abbott (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York, NY : Apress, [2023]
Temas:
Microsoft Excel (Computer file)
Electronic spreadsheets.
Tableurs.
Electronic spreadsheets
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Chapter 1: Whats an Array, Anyway?
  • Chapter 2: Array Formula Basics. Chapter 3: Dynamic Arrays
  • Time for Some Heavy Lifting
  • Chapter 4: The SEQUENCE Function: Made to Order
  • Chapter 5: UNIQUE
  • A Singular Function
  • Chapter 6: SORT and SORTBY: The ABCs (and the CBAs)
  • Chapter 7: The FILTER Function: Cutting the Data Down to Size
  • Chapter 8: RANDARRAY: Unpredictably Useful
  • Chapter 9: The Implicit Intersection Operator: The Function You'll Probably Never Use
  • Chapter 10: TEXTSPLIT, TEXTBEFORE, and TEXTAFTER: Putting Words in Their Places
  • Chapter 11: TOCOL and TOROW
  • Straightening Out the Data
  • Chapter 12: WRAPCOLS and WRAPROWS: Giving Some Direction to the Data
  • Chapter 13: VSTACK and HSTACK: What They're About
  • Chapter 14: CHOOSECOLS and CHOOSEROWS: Less is More
  • Chapter 15: TAKE and DROP: Selecting and Rejecting the Data
  • Chapter 16: EXPAND: Bulking Up the Data.

Ejemplares similares