Excel the missing manual
Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an intermediate-level plodder eager to hone your skills, Excel: The Missing Manual is sure to become your go-to resource for all things Excel. Covering all the features of Excel 2002 and 2003, the most recent ver...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
Beijing ; Sebastopol, California :
Pogue Press/O'Reilly
2004.
|
| Edition: | First edition |
| Series: | Missing manual
Missing manual. |
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626956806719 |
Table of Contents:
- 1.5. Opening Files2. Adding Information to Worksheets; 2.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 Rows3.3.3. Inserting Copied or Cut Cells; 3.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.1.4. Custom Formats; 4.1.4.2. Custom format string codes; 4.1.4.3. Date and time format strings; 4.1.4.4. Number format strings; 4.1.4.5. Text format strings; 4.2. Formatting Cell Appearance; 4.2.2. Fonts and Color; 4.2.3. Borders and Patterns
- 4.3. Smart Ways to Apply Formatting4.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 Formatting; 5. 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. Entering 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 worksheets5.1.4. Moving Worksheets from One Workbook 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 Check; 6. 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
