Excel 2007 the missing manual
Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early '90s is its user interface. The once-simple toolbar has been packed with so many features over the years that few users know where to find them all. Microsoft...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly
2007.
|
| Edición: | 1st edition |
| Colección: | Missing manual
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627217906719 |
Tabla de Contenidos:
- 1.3.4. Excel Options1.4. Saving Files; 1.4.2. Saving Your Spreadsheet in Older Formats; 1.4.2.2. The Compatibility Checker; 1.4.3. Saving Your Spreadsheet As a PDF; 1.4.4. Saving Your Spreadsheet with a Password; 1.4.5. Disaster Recovery; 1.5. Opening Files; 1.5.2. Opening Multiple Spreadsheets at Once; 2. 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 Selections3.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 Cells; 3.3.4. Deleting Columns and Rows; 4. Managing Worksheets and Workbooks; 4.1.2. Naming and Rearranging Worksheets; 4.1.3. Grouping Sheets; 4.1.3.2. Formatting cells, columns, and rows in grouped worksheets
- 4.1.3.3. Entering data or changing cells in grouped worksheets4.1.3.4. Cutting, copying, and pasting cells in grouped worksheets; 4.1.3.5. Adjusting printing and display options in grouped worksheets; 4.1.4. Moving Worksheets from One Workbook to Another; 4.2. Find and Replace; 4.2.2. Find All; 4.2.3. More Advanced Searches; 4.2.4. Finding Formatted Cells; 4.2.5. Finding and Replacing Values; 4.3. Spell Check; 5. Formatting Cells; 5.1.1.2. Number; 5.1.1.3. Currency; 5.1.1.4. Accounting; 5.1.1.5. Percentage; 5.1.1.6. Fraction; 5.1.1.7. Scientific; 5.1.1.8. Text
- 5.1.2. Formatting Dates and Times5.1.3. Special Formats for Special Numbers; 5.1.4. Custom Formats; 5.1.4.2. Custom format string codes; 5.1.4.3. Date and time format strings; 5.1.4.4. Number format strings; 5.1.4.5. Text format strings; 5.2. Formatting Cell Appearance; 5.2.2. Fonts and Color; 5.2.3. Borders and Fills; 5.2.4. Drawing Borders by Hand; 6. Smart Formatting Tricks; 6.2. Styles and Themes; 6.2.2. Modifying Styles; 6.2.3. Transferring Styles Between Workbooks; 6.2.4. Themes: A Package of Styles; 6.2.4.2. Colors; 6.2.4.3. Effects; 6.2.5. Modifying Themes; 6.3. Conditional Formatting
- 6.3.2. Highlighting Specific Values
