Matthew Macdonald

Excel 2007 for Starters: The Missing Manual (eBook, PDF)

The Missing Manual

• Format: PDF

Produktbeschreibung

Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel's most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, Excel 2007 for Starters: The Missing Manual will quickly teach you to: Build spreadsheetsAdd and format informationPrint reportsCreate charts and graphicsUse basic formulas and functionsand moreThe new Excel is radically different from previous versions. Over the years, Excel has grown in power, sophistication and capability, but its once-simple toolbar has been packed with so many features that not even the pros could find them all. For Excel 2007, Microsoft redesigned the user interface completely, adding a tabbed toolbar that makes every feature easy to locate. Unfortunately, Microsoft's documentation is as scant as ever, so even if you find the features you need, you still may not know what to do with them. But with this book, you can breeze through the new user interface and its timesaving features in no time. Excel 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: O'Reilly Media
• Seitenzahl: 400
• Erscheinungstermin: 23. Januar 2007
• Englisch
• ISBN-13: 9780596515386
• Artikelnr.: 52980877

Autorenporträt

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.

Inhaltsangabe

Inhaltsverzeichnis The Missing Credits Introduction Part One: Worksheet Basics Chapter 1. Creating and Navigating Worksheets Creating a Basic Worksheet Starting a New Workbook Adding the Column Titles Adding Data Editing Data Navigating in Excel The Tabs of the Ribbon The Formula Bar The Status Bar Excel Options Saving Files The Excel 2007 File Format Saving Your Spreadsheet in Older Formats Saving Your Spreadsheet As a PDF Disaster Recovery Opening Files Opening Multiple Spreadsheets at Once Chapter 2. Adding Information to Worksheets Adding Different Types of Data Controlling Your Data Types Quick Ways to Add Data AutoComplete AutoCorrect AutoFill AutoFit Undo and Redo Chapter 3. Moving Data Around a Worksheet Selecting Cells Making Continuous Range Selections Making Non-Contiguous Selections Automatically Selecting Your Data Making Selections with the Keyboard Moving Cells Around A Simple Cut-and-Paste or Copy-and-Paste A Fancy Cut-and-Paste or Copy-and-Paste The Clipboard Special Pasting Adding and Moving Columns or Rows Inserting Columns Inserting Rows Inserting Copied or Cut Cells Deleting Columns and Rows Chapter 4. Managing Worksheets and Workbooks Worksheets and Workbooks Adding, Removing, and Hiding Worksheets Naming and Rearranging Worksheets Find and Replace The Basic Find Find All More Advanced Searches Finding Formatted Cells Finding and Replacing Values Spell Check Spell Checking Options Chapter 5. Formatting Cells Formatting Cell Values Formatting Numbers Formatting Dates and Times Special Formats for Special Numbers Formatting Cell Appearance Alignment and Orientation Fonts and Color Borders and Fills Drawing Borders by Hand Smart Ways to Apply Formatting The Format Painter Styles and Themes Chapter 6. Viewing and Printing Worksheets Controlling Your View Zooming Viewing Distant Parts of a Spreadsheet at Once Freezing Columns or Rows Hiding Data Saving View Settings Printing How to Print an Excel File Quick Printing Previewing Your Printout Creating Headers and Footers Customizing Print Settings Controlling Pagination Page Breaks Scaling Page Break Preview: A Bird's-Eye View of Your Worksheet Part Two: Worksheet power Chapter 7. Building Basic Formulas Creating a Basic Formula Excel's Order of Operations Cell References How Excel Formats Cells That Contain Cell References Functions Formula Errors Logical Operators Formula Shortcuts Point-and-Click Formula Creation Point-and-Click Formula Editing The Formulas Tab Using the Insert Function Button to Quickly Find and Insert Functions Copying Formulas Absolute Cell References Partially Fixed References Chapter 8. Tables: List Management Made Easy The Basics of Tables Creating a Table Formatting a Table Editing a Table Selecting Parts of a Table Sorting and Filtering a Table Applying a Simple Sort Order Sorting with Multiple Criteria Filtering with the List of Values Creating Smarter Filters Chapter 9. Creating Basic Charts Charting 101 Embedded and Standalone Charts Creating a Chart with the Ribbon The Chart Tools Ribbon Tabs Basic Tasks with Charts Moving and Resizing a Chart Creating a Standalone Chart Editing and Adding to Chart Data Changing the Chart Type Printing Charts Practical Charting Charts with Multiple Series of Numbers Controlling the Data Excel Plots on the X-Axis Non-Contiguous Chart Ranges Changing the Order of Your Data Series Changing the Way Excel Plots Blank Values Chart Types Column Bar Line Pie Area Appendix. Customizing the Quick Access Toolbar Index