Cargando…

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.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: MacDonald, Matthew
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.