Microsoft® Office Excel 2003 inside out
Hey, you know your way around a spreadsheet-so now dig into Excel 2003 and really put your data to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format. It's all muscle and no fluff. Discover...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Colección: | Inside out
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627878106719 |
Tabla de Contenidos:
- Microsoft® Office Excel 2003; We&d Like to Hear from You!; About the CD; Using the CD; System Requirements; Support Information; Conventions and Features Used in this Book; Design Conventions; About the Authors; 1. Examining the Excel Environment; Getting Software Updates; Comparing Worksheets Side by Side; Improved Statistical Functions; New Task Panes; Document Workspaces; Information Rights Management; Improved List Management; If You Missed the Last Upgrade ...; Onward ...; 2. Excel Fundamentals; Subscribing to Excel; Recovering from Crashes; Heroic Measures; Examining the Excel Workspace
- Using the Workbook WindowGetting Around in the Workbook; Workbook Navigation Tips; Resizing the Window; Exploring Menus and Dialog Boxes; Accessing Menus and Commands with the Keyboard; Dialog Boxes and Tabs; The Joy of Shortcut Menus; Understanding the Formula Bar; About the Status Bar; Introducing Toolbars; File Management Fundamentals; Use Your Own Folders for Templates; Changing the Default Book and Sheet; Saving Files; File Formats; Specifying the Default File Format; Creating Automatic Backup Files; Protecting Files; Adding Summary Information to Files; Saving the Entire Workspace
- Opening FilesOpening Files When You Start Excel; Recovering Corrupted Files; Searching for Files; Importing and Exporting Files; Importing and Exporting Text Files; Sharing Data with Excel for the Macintosh; Online Help Works-Really!; Managing the Assistant; Using the Assistant; Getting Answers to Unasked Questions; Browsing the Help System; Customer Feedback Options; Shared Workspace; What&s on the Help Menu; 3. Custom-Tailoring the Excel Workspace; Customizing Toolbars on the Fly; Rearranging Buttons and Commands; Controlling the Display of Button Faces; Giving Face to the Faceless
- Rearranging Menus and SubmenusChanging the Face of Buttons; Copying Button Faces; Does Size Matter?; Managing Toolbars; Creating New Toolbars and Menus; Attaching Custom Toolbars to Workbooks; Creating New Menus; Preserving Toolbar and Menu Changes; Restoring Toolbars and Menus; Other Toolbar and Menu Options; Controlling Other Elements of the Excel Interface; Hiding Zeros; Changing the Color Palette; Enhancing Accessibility; 2. Building Worksheets; Will You Need to Print the Worksheet?; Who Is the Audience?; Would Your Worksheet Survive Without You?; Does the Worksheet Rely on Imported Data?
- Do You Need More Than One Worksheet?Have You Allowed Room to Insert New Rows and Columns?; 5. How to Work a Worksheet; Navigating Regions with the Mouse; Navigating with Special Keys; Selecting Stuff; Selecting Columns, Rows, and Multiple Areas; Selecting Regions; Selecting with the Go To Command; Entering Stuff; Using Special Characters; Understanding the Difference Between Displayed Values and Underlying Values; Creating Long Text Values; Using Word Wrapping; Understanding Numeric Text Entries; Entering Symbols; Making Entries in Ranges; Editing and Undoing Entries; Managing Worksheets
- Naming and Renaming Sheets
