Cargando…
Excel 2007 pocket guide /
Moving to Excel 2007 is not a routine upgrade. Microsoft's radical redesign of the application's user interface has led to confusion among many who people who have relied on Excel for years. Our new edition of the Excel 2007 Pocket Guide has been written from the ground up to help newcomer...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Calif. :
O'Reilly,
2007.
|
| Edición: | 2nd ed. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Excel 2007 Pocket Guide, 2nd Edition; The Excel 2007 Interface; Contextual Tabs; Dialog Expanders; The Office Button; Quick Access Toolbar; The Excel Program Window; New Excel 2007 File Format; Workbook, Template, and Workspace Files; Tips on Using Templates; The Anatomy of an Excel File; A Worksheet; Sheet Tabs; Formatting; Columns and Rows; Cells; Characters; Styles; Shortcut Menus and the Mini Toolbar; How Excel Tries to Help; AutoComplete; Smart Tags; 2. Excel Tasks; Printing; Moving Around in a Workbook or Worksheet; Manipulating Workbooks and Worksheets.
- Manipulating Rows, Columns, and CellsEntering and Editing Data; Creating, Managing, and Formatting Excel Tables; Entering Data with a Data Entry Form; Using AutoCorrect and AutoComplete; Inserting Text and Other Elements; Selecting Text and Data; Cutting, Copying, and Pasting Data; Clearing Cell Contents and Formulas; Formatting; Formatting Numbers and Dates; Formatting Cell Borders and Areas; Formatting a Workbook; Working with Hyperlinks; Working with Headers and Footers; Summarizing Data; Adding Formulas to Cells; Auditing Formulas; Using Named Ranges; Defining Alternative Data Sets.
- Controlling How Data Is DisplayedFiltering Worksheet Data; Using Subtotals to Summarize Data; Creating Custom Views; Protecting All or Part of a Workbook; Spelling and Other Tools; Customizing Excel; Customizing the Quick Access Toolbar; Collaborating; Tracking Changes; Sharing Workbooks; Working with the Web; Summarizing Data with Charts; Analyzing Data with PivotTables and PivotCharts; 3. Formula Reference; Math Formulas; Date and Time Formulas; Financial Formulas; Lookup and Reference Formulas; Logical Formulas; Text Formulas; Statistical Formulas; 4. Excel Reference; Native Formats.
- Startup SwitchesWildcards in Filters and Searches; Default File Locations; Keyboard Shortcuts; 5. Excel Resources; Books; Excel Utilities.