Excel 2010 formulas /

A reference collection of formulas for spreadsheet challenges covers operators, nesting, functions, error values, naming, cell formatting, protection options, array formulas, pivot tables, and auditing.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Walkenbach, John
Formato: Documento de Gobierno Electrónico eBook
Idioma:Inglés
Publicado: Hoboken, NJ : Wiley Pub., ©2010.
Colección:Mr. Spreadsheet's bookshelf.
Temas:
Microsoft Excel (Computer file)
Microsoft Excel (Computer software)
Business > Computer programs.
Electronic spreadsheets.
Tableurs.
COMPUTERS > Desktop Applications > Spreadsheets.
Business > Computer programs
Electronic spreadsheets
Excel.
Business > Computer software.
Spreadsheet software.
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Excel in a nutshell
  • Basic facts about formulas
  • Working with names
  • Introducing worksheet function
  • Manipulating text
  • Working with dates and times
  • Counting and summing techniques
  • Using lookup functions
  • Tables and worksheet databases
  • Miscellaneous calculations
  • Borrowing and investing formulas
  • Discounting and depreciation formulas
  • Financial schedules
  • Introducing arrays
  • Performing magic with array formulas
  • Intentional circular references
  • Charting techniques
  • Pivot tables
  • Conditional formatting and data validation
  • Creating megaformulas
  • Tools and methods for debugging formulas
  • Introducing VBA
  • Function procedure basics
  • VBA programming concepts
  • VBA custom function examples.

Ejemplares similares