Microsoft® Office Excel® 2007 Plain & Simple
Here's WHAT You'll Learn Easily navigate the new user interfaceCeate formulas and functionsUse charts and diagrams to display information visuallyEnhance your spreadsheet with graphic effectsReuse data from other Microsoft Office documentsTeam up and share spreadsheets with colleagues...
Autor principal: | |
---|---|
Otros Autores: | |
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Sebastopol :
Microsoft Press
2009.
|
Edición: | 1st edition |
Colección: | Plain & Simple
|
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627072906719 |
Tabla de Contenidos:
- Microsoft® Office Excel® 2007 Plain & Simple; 1. Introduction: About This Book; ...And the Easiest Way to Do Them; A Quick Overview; A Few Assumptions; A Final Word (or Two); 2. What's New in Excel 2007?; Arranging Data into Tables; Introducing Galleries; Using the Mini Toolbar; Creating Formulas Using New Functions; Using More Colors; Creating Better Conditional Formats; Creating More Attractive Charts; 3. Getting Started with Excel 2007; Working with Galleries; Starting Excel; Open an Existing Workbook; Finding and Opening Existing Workbooks; Open a Recently Used Workbook
- Search for a Workbook and Open ItUsing File Properties; Define Custom Properties; Creating a New Workbook; Working with Multiple Workbooks; Show More than One Workbook; Sizing and Viewing Windows; Zooming In or Out on a Worksheet; Zoom In or Out to a Custom Zoom Level; Viewing a Worksheet in Full Screen Mode; Turn Full Screen Mode Off; Saving and Closing an Excel Workbook; Save a Workbook with a New Name; Change the Default File Folder; Close a Workbook; Exit Excel; Using the Excel Help System; Get Suggested Commands from Shortcut Menus; Get Help on the Web; 4. Building a Workbook
- Navigating the WorksheetSelecting Cells; Select a Noncontiguous Group of Cells; Select Rows or Columns; Select Noncontiguous Rows or Columns; Entering Text in Cells; Enter Text with Forced Line Breaks; Entering Numbers in Cells; Enter Numbers Using Scientific Notation and Exponents; Entering Dates and Times in Cells; Enter a Time; Enter a Date and Time; Enter the Current Date and Time; Entering Data Using Fills; Fill Data with AutoFill; Use AutoFill to Enter a Series of Values; Entering Data with Other Shortcuts; Pick Data from a List; Creating a Data Table; Add Data to a Data Table
- Rename a Data TableResize a Table; Select a Table Column; Editing Cell Contents; Edit Cell Contents Directly in the Cell; Inserting a Symbol in a Cell; Creating Hyperlinks; Add a Hyperlink to Another File; Add a Hyperlink to a Web Page; Add a Mailto Hyperlink; Cutting, Copying, and Pasting Cell Values; Copy a Cell Value; Pasting Values with More Control; Paste Values with More Control; Clearing Cell Contents; Clear a Cell; Using the Office Clipboard; Display the Contents of the Office Clipboard; Paste an Item from the Office Clipboard; Clear an Item from the Office Clipboard
- Undoing or Redoing an ActionFinding and Replacing Text; Replace a Word or Value; Checking the Spelling of Your Worksheet; 5. Managing and Viewing Worksheets; Renaming Worksheets; Moving Worksheets; Move Worksheets to Another Workbook; Copying Worksheets; Copy Worksheets to Another Workbook; Inserting and Deleting Worksheets; Delete One or More Worksheets; Hiding or Showing a Worksheet; Unhide a Hidden Worksheet; Changing Worksheet Tab Colors; Inserting, Moving, and Deleting Cells; Moving Cells in a Worksheet; Deleting Cells in a Worksheet; Inserting, Moving, and Deleting Columns and Rows
- Insert a Column in a Worksheet