Missing Manual

Sebastopol : : O'Reilly Media, , 2008.

1 online resource (864 p.)

Description based upon print version of record.. - Excel 2007: The Missing Manual; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; Excel&s New Face; Using the Ribbon with the Keyboard; The Office Menu; The Quick Access Toolbar; Excel&s New Features; About This Book; About → These → Arrows; Drop-down buttons; Dialog box launchers; Ordinary menus; About Shortcut Keys; About Clicking; Examples; About MissingManuals.com; Safari® Enabled; I. Worksheet Basics; 1.1.2. Adding the Column Titles; 1.1.3. Adding Data; 1.2. Editing Data; 1.3. Navigating in Excel; 1.3.2. The Formula Bar; 1.3.3. The Status Bar. - 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. - 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 has addressed this problem in Excel 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use. Unfortunately, Microsoft's documentation is as scant as ever, so even if users can find advanced features, they probably won't know what to do

Electronic books.

005.54 . - 005.36

0596527594. - 9780596527594