Head first Excel

Do you use Excel for simple lists, but get confused and frustrated when it comes to actually doing something useful with all that data? Stop tearing your hair out: Head First Excel helps you painlessly move from spreadsheet dabbler to savvy user. Whether you're completely new to Excel or an e...

Descripción completa

Detalles Bibliográficos
Autor principal: Milton, Michael (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Beijing ; Sebastopol, California : O'Reilly 2010.
Edición:First edition
Colección:Head first series
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628428106719
Tabla de Contenidos:
  • Introduction to formulas ; Excel's real power
  • Visual design : spreadsheets as art
  • References : point in the right direction
  • Change your point of view : sort, zoom, and filter
  • Data types : make Excel value your values
  • Dates and times : stay on time
  • Finding functions : mine Excel's features on your own
  • Formula auditing : visualize your formulas
  • Charts : graph your data
  • What if analysis : alternate realities
  • Text functions : letters as data
  • Pivot tables : hardcore grouping
  • Booleans : TRUE and FALSE
  • Segmentation : slice and dice
  • Leftovers : the top ten things (we didn't cover)
  • Install Excel's Solver : the solver.