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...
Autor principal: | |
---|---|
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.