Microsoft® Office Excel® 2007 Inside Out
You're beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Excel 2007-and chal...
| 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/alma991009627076206719 |
Tabla de Contenidos:
- Microsoft® Office Excel® 2007 Inside Out; About the CD; System Requirements; Support Information; Conventions and Features Used in This Book; Design Conventions; 1. Examining the Excel Environment; Graphic Enhancements; Improved Formatting and Output Tools; New Templates; Updated Conditional-Formatting Features; Increased Capacity and Speed; Better and Easier Tables; Improved PivotTables and PivotCharts; Better Database Connectivity; Formula AutoComplete; Tools for Creating Formulas; Built-In Analysis Toolpak Functions; Enhanced Charting Features; New XLSX File Format
- Improved Sorting and FilteringCollaboration Enhancements; Enhanced Security Features; Retired in 2007; If You Missed the Last Upgrade . . .; Onward . . .; 2. Exploring Excel Fundamentals; Getting Updates; Examining the Excel 2007 Workspace; Using the Workbook Window; Getting Around in the Workbook; Workbook Navigation Tips; Resizing the Window; Exploring the Ribbon; Drop-Down Lists and Dialog Box Launchers; Galleries and Live Preview; Introducing Contextual Tool Sets; Where Is the File Menu?; Using the Quick Access Toolbar; Accessing Commands with the Keyboard; The Joy of Shortcut Menus
- Meet the Formula BarFacts About the Status Bar; Exploring File Management Fundamentals; Create Your Own Template Tabs; Saving Files; File Formats; Ensuring File Compatibility with Previous Versions of Excel; Understanding the ""XL"" Formats; Specifying the Default File Format; Creating Automatic Backup Files; Protecting Files; Adding Summary Information to Files; Saving the Entire Workspace; Opening Files; Opening Files When You Start Excel; Recovering Corrupted Files; Importing and Exporting Files; Sharing Data with Excel for the Macintosh; Sharing Data Beyond Excel
- Importing and Exporting Text FilesOther File Formats; Using the Online Help System; Help In Depth; Recovering from Crashes; Calling Dr. Office; 3. Custom-Tailoring the Excel Workspace; Adding Tools to the Toolbar; Removing Tools; Adding and Organizing Tools; Identifying Items in the Customize Dialog Box; Too Many Tools?; Creating Your Own Buttons; Attaching Custom Toolbar Configurations to Workbooks; Restoring the Toolbar; Exploring Other Toolbar and Ribbon Options; Controlling Other Elements of the Excel 2007 Interface; Hiding Zeros; Enhancing Accessibility; 4. Security and Privacy
- Add-Ins, ActiveX Settings, and Macro SettingsMessage Bar; External Content; Privacy Options; File Security; Using Digital Signatures; Other Security Features; 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 for New Data?; 6. How to Work a Worksheet; Navigating Regions with the Mouse; Navigating with Special Keys; Understanding Selection; Selecting Columns, Rows, and Multiple Areas; Selecting Regions
- Using the Find & Select Commands
