Excel 2010 : the missing manual /
Offering an updated overview of the latest version of the spreadsheet program, a manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions.
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Sebastopol, Calif. :
O'Reilly Media,
Ã2010.
|
Colección: | Missing manual.
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 50 Part 1: Worksheet basics. Creating your first spreadsheet
- Adding information to worksheets
- Moving data
- Managing worksheets
- Formatting cells
- Smart formatting tricks
- Viewing and printing worksheets
- Part 2: Formulas and functions. Building basic formulas
- Math and statistical functions
- Financial functions
- Manipulating dates, times, and text
- Lookup, reference, and information functions
- Advanced formula writing and troubleshooting
- Part 3: Organizing worksheets. Tables: list management made easy
- Grouping and outlining data
- Templates
- Part 4: Charts and graphics. Creating basic charts
- Formatting and perfecting charts
- Inserting graphics
- Part 5: Advanced data analysis. Visualizing your data
- Scenarios and goal seeking
- Pivot tables
- Analyzing databases, XML, and web pages
- Part 6: Sharing data with the rest of the world. Protecting your workbooks
- Worksheet collaboration
- Using Excel on the web
- Exchanging data with other programs
- Part 7: Programming Excel. Automating tasks with macros
- Programming spreadsheets with VBA
- Part 8: Appendix. Customizing the ribbon.