Advanced Excel Formulas : Unleashing Brilliance with Excel Formulas /

Enhance and upgrade your Excel knowledge with this comprehensive guide to formulas in Excel. Over 150 of the most useful Excel functions are covered with numerous practical examples of their use. This book is fully updated and includes examples of the most recently released functions in 2022. It is...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Murray, Alan
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Berkeley, CA : Apress L.P., 2022.
Temas:
Microsoft Excel (Computer file)
Electronic spreadsheets > Computer programs.
Tableurs > Logiciels.
Electronic spreadsheets > Computer programs
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Excel Formulas: A Quick Primer
  • Logical functions
  • Defined names
  • You need to start using tables
  • Manipulating text
  • Working with dates and time
  • The Infamous VLOOKUP Function
  • The Awesome SUMIFS, COUNTIFS, and Friends
  • Next-Level Aggregation Functions
  • Dynamic Array
  • Advanced Lookup Functions
  • XLOOKUP: The New Kid on the Block
  • FILTER Function: The Game Changer
  • Formulas with Data Types in Excel
  • LET, LAMBDA, and the Helper Functions.

Ejemplares similares