Excel for starters the missing manual
The dominant spreadsheet program and one of the most widely used software applications in the world, Microsoft Excel is unbelievably powerful--and can be downright intimidating. If you're new to Excel or among the many existing Excel users who are dazed and confused by all that the program can...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly
2005.
|
| Edición: | First edition |
| Colección: | Missing manual
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626935106719 |
Tabla de Contenidos:
- 2. Adding Information to Worksheets2.1.1.2. How Excel decides your data is numeric; 2.1.1.3. How Excel decides your data is a date or time; 2.2. Quick Ways to Add Data; 2.2.2. AutoCorrect; 2.2.3. AutoFill; 2.2.4. AutoFit; 2.2.5. Undo and Redo; 3. Moving Data Around a Worksheet; 3.1.2. Making Non-Contiguous Selections; 3.1.3. Automatically Selecting Your Data; 3.1.4. Making Selections with the Keyboard; 3.2. Moving Cells Around; 3.2.2. A Fancy Cut-and-Paste or Copy-and-Paste; 3.2.3. The Clipboard; 3.2.4. Special Pasting; 3.3. Adding and Moving Columns or Rows; 3.3.2. Inserting Rows
- 3.3.3. Inserting Copied or Cut Cells3.3.4. Deleting Columns and Rows; 4. Formatting Worksheets; 4.1.1.2. Number; 4.1.1.3. Currency; 4.1.1.4. Accounting; 4.1.1.5. Percentage; 4.1.1.6. Fraction; 4.1.1.7. Scientific; 4.1.1.8. Text; 4.1.2. Formatting Dates and Times; 4.1.3. Special Formats for Special Numbers; 4.2. Formatting Cell Appearance; 4.2.2. Fonts and Color; 4.2.3. Borders and Patterns; 4.3. Smart Ways to Apply Formatting; 4.3.1.2. Formatting individual characters; 4.3.2. AutoFormat; 4.3.3. The Format Painter; 4.3.4. Using Styles; 4.3.4.2. Applying a style; 4.3.4.3. Transferring styles
- 4.3.5. Conditional Formatting5. Managing Worksheets and Workbooks; 5.1.2. Naming and Rearranging Worksheets; 5.1.3. Grouping Sheets; 5.1.3.2. Formatting cells, columns, and rows in grouped worksheets; 5.1.3.3. Typing in data or changing cells in grouped worksheets; 5.1.3.4. Cutting, copying, and pasting cells in grouped worksheets; 5.1.3.5. Adjusting printing and display options in grouped worksheets; 5.1.4. Moving Worksheets from One Workbook (Excel File) to Another; 5.2. Find and Replace; 5.2.2. More Advanced Searches; 5.2.3. Finding Formatted Cells; 5.2.4. Finding and Replacing Values
- 5.3. Spell Check6. Viewing and Printing Worksheets; 6.1.2. Viewing Distant Parts of a Spreadsheet at Once; 6.1.3. Freezing Columns or Rows; 6.1.4. Hiding Data; 6.1.5. Saving View Settings; 6.1.6. Viewing Multiple Workbooks at Once; 6.2. Printing; 6.2.2. Customizing Print Settings; 6.2.2.2. Margins settings; 6.2.2.3. Creating headers and footers; 6.2.2.4. Sheet settings; 6.2.3. Getting a Print Snapshot; 6.2.4. Page Break Preview: A Bird&s-Eye View of Your Worksheet; Two. Worksheet Power; 7.1.2. Cell References; 7.1.3. How Excel Formats Cells that Contain Cell References; 7.1.4. Functions
- 7.1.5. Specifying Cell Ranges
