Office 2007 The Missing ManualCHM

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: Office 2007 The Missing Manual 版本: CHM 发行日期: 2006年12月01日 地区: 美国 对白语言: 英语 概述:

Word 2007: The Missing Manual By Guy Hart-Davis, Chris Grover ............................................... 出版: O'Reilly 日期: December 01, 2006 ISBN-10: 0-596-52739-X ISBN-13: 978-0-596-52739-6 页数: 504 Table of Contents | Index Copyright The Missing Credits Introduction Part I: Word Basics for Simple Documents Chapter 1. Creating, Opening, and Saving Documents Section 1.1. Launching Word Section 1.2. Creating a New Document Section 1.3. Opening an Existing Document Section 1.4. Your Different Document Views Section 1.5. Saving and Closing Documents Chapter 2. Entering and Editing Text Section 2.1. Typing in Word Section 2.2. Selecting Text Section 2.3. Moving Around Your Document Section 2.4. Cutting, Copying, and Pasting Section 2.5. Finding and Replacing Text Section 2.6. Saving Keystrokes with Quick Parts Chapter 3. Setting Up the Document: Margins, Page Breaks, and More Section 3.1. Choosing Paper Size and Layout Section 3.2. Setting Document Margins Section 3.3. Adding Page Background Features Section 3.4. Adding Headers and Footers Section 3.5. Working with Multiple Columns Section 3.6. Line Numbers Section 3.7. Hyphenation Chapter 4. Formatting Text, Paragraphs, and Headings Section 4.1. Formatting Basics Section 4.2. Formatting Characters Section 4.3. Formatting Paragraphs Section 4.4. Creating Bulleted and Numbered Lists Section 4.5. Setting Tabs Section 4.6. Using Word's Rulers Section 4.7. Fast Formatting with Format Painter Section 4.8. Formatting with Styles Section 4.9. Modifying Styles Section 4.10. Managing Style Sets Chapter 5. Themes and Templates Section 5.1. Choosing a Theme Section 5.2. Choosing a Template Chapter 6. Spelling, Grammar, and Reference Tools Section 6.1. Turning on Spelling and Grammar Checking Section 6.2. Checking Spelling Section 6.3. Checking Grammar and Style Section 6.4. Controlling AutoCorrect Section 6.5. Exploring Word's Research Tools Section 6.6. Accessing Word's Thesaurus Section 6.7. Translating Text Section 6.8. Checking Your Word Count Chapter 7. Printing Word Documents Section 7.1. Quick and Easy Printing Section 7.2. Print Preview Section 7.3. Choosing a Printer Section 7.4. Printing to an Adobe PDF File Section 7.5. Faxing with Word Section 7.6. Changing Print Settings Section 7.7. Printing Envelopes Section 7.8. Printing Labels Section 7.9. Setting Print Options Part II: Creating Longer and More Complex Documents Chapter 8. Planning with Outlines Section 8.1. Switching to Outline View Section 8.2. Promoting and Demoting Headings Section 8.3. Moving Outline Items Section 8.4. Showing Parts of Your Outline Chapter 9. Working with Long Documents Section 9.1. Navigating a Large Document Section 9.2. Understanding Sections Section 9.3. Creating a Table of Contents Section 9.4. Creating an Index Section 9.5. Navigating with Hyperlinks Section 9.6. Cross-Referencing Your Document Section 9.7. Cross-Referencing Figures Section 9.8. Creating Footnotes and Endnotes Section 9.9. Inserting Citations and Creating a Bibliography Section 9.10. Working with a Master Document Chapter 10. Organizing Your Information with Tables Section 10.1. Creating Tables Section 10.2. Moving Around a Table Section 10.3. Selecting Parts of a Table Section 10.4. Merging and Splitting Cells Section 10.5. Adjusting Column Width and Row Height Section 10.6. Formatting Tables Section 10.7. Doing Math in Tables Chapter 11. Adding Graphics, Video, and Sound to Your Documents Section 11.1. Drop Caps, Text Boxes, and WordArt Section 11.2. Working with Pictures and Clip Art Section 11.3. Working with SmartArt Section 11.4. Working with Shapes Section 11.5. Inserting Charts and Graphs Section 11.6. Inserting Sound, Video, and Other Objects Section 11.7. Adding Captions and Figure Numbers to Graphics Chapter 12. Mass Mailing with Mail Merge Section 12.1. Understanding Mail Merge Basics Section 12.2. Running the Mail Merge Wizard Section 12.3. Merging to E-Mail Section 12.4. Editing Your Recipient List Section 12.5. Sorting Your Recipient List Section 12.6. Applying Merge Rules Part III: Sharing Documents and Collaborating with Other People Chapter 13. Creating Web Pages and Blogs Section 13.1. Saving Word Documents As Web Pages Section 13.2. Creating a Web Page from Scratch Section 13.3. Web Page Design Tips Section 13.4. Blogging from Word Section 13.5. Setting Web Options Chapter 14. Creating Forms with Word Section 14.1. Creating a Paper Form Section 14.2. Creating a Computer Form Section 14.3. Setting Properties for Content Controls Section 14.4. Testing Your Form Chapter 15. Word's XML Connection Section 15.1. What's XML and Why Should I Care? Section 15.2. XML and Word's New File Format Section 15.3. Tagging Information with Content Controls Section 15.4. Attaching an XML Schema to Your Document Chapter 16. Collaborating with Other People Section 16.1. Adding Comments Section 16.2. Tracking Changes While Editing Section 16.3. Accepting and Rejecting Changes Section 16.4. Removing All Comments and Tracked Changes Section 16.5. Combining and Comparing Documents Section 16.6. Protecting Your Document from Changes Part IV: Customizing Word with Macros and Other Tools Chapter 17. Customizing Your Workspace Section 17.1. Customizing the Quick Access Toolbar Section 17.2. Creating Keyboard Shortcuts Section 17.3. Personalizing Word Options Section 17.4. Changing Word's Display Section 17.5. Customizing the Save Documents Settings Section 17.6. Changing Editing Options Chapter 18. Changing Your Security Settings Section 18.1. Using Digital Signatures Section 18.2. Customizing Trust Center Settings Section 18.3. Showing Warnings Section 18.4. Removing Personal Information Chapter 19. Introducing Macros and Visual Basic Section 19.1. Showing the Developer Tab Section 19.2. Recording Macros Section 19.3. Running Macros Section 19.4. Reading Visual Basic Code Section 19.5. Using Digital Signatures Chapter 20. Creating Your Own Themes and Templates Section 20.1. Designing Your Own Themes Section 20.2. Designing Document Templates Section 20.3. Using Global Templates Part V: Appendix Appendix A. Word Help and Beyond Section A.1. Using Word's Built-in Help Section A.2. Using Microsoft's Office Web Site Section A.3. Third-Party Web Sites Colophon Index Access 2007: The Missing Manual By Matthew MacDonald ............................................... 出版: O'Reilly 日期: December 01, 2006 ISBN-10: 0-596-52760-8 ISBN-13: 978-0-596-52760-0 页数: 600 Table of Contents | Index Copyright The Missing Credits Introduction Part I: Storing Information in Tables Chapter 1. Creating Your First Database Section 1.1. Understanding Access Databases Section 1.2. Getting Started Section 1.3. Saving and Opening Access Databases Section 1.4. The Navigation Pane Chapter 2. Building Smarter Tables Section 2.1. Understanding Data Types Section 2.2. Design View Section 2.3. Access Data Types Section 2.4. The Primary Key Section 2.5. Six Principles of Database Design Chapter 3. Mastering the Datasheet: Sorting, Searching, Filtering, and More Section 3.1. Datasheet Customization Section 3.2. Datasheet Navigation Section 3.3. Advanced Editing Section 3.4. Printing the Datasheet Chapter 4. Blocking Bad Data Section 4.1. Data Integrity Basics Section 4.2. Input Masks Section 4.3. Validation Rules Section 4.4. Lookups Chapter 5. Linking Tables with Relationships Section 5.1. Relationship Basics Section 5.2. Using a Relationship Section 5.3. More Exotic Relationships Section 5.4. Relationship Practice Part II: Manipulating Data with Queries Chapter 6. Queries That Select Records Section 6.1. Query Basics Section 6.2. Creating Queries Section 6.3. Queries and Related Tables Chapter 7. Essential Query Tricks Section 7.1. Calculated Fields Section 7.2. Query Functions Section 7.3. Summarizing Data Section 7.4. Query Parameters Chapter 8. Queries That Update Records Section 8.1. Understanding Action Queries Section 8.2. Update Queries Section 8.3. Append Queries Section 8.4. Delete Queries Section 8.5. Tutorial: Flagging Out-of-Stock Orders Chapter 9. Analyzing Data with Crosstab Queries and Pivot Tables Section 9.1. Understanding Crosstab Queries Section 9.2. Creating Crosstab Queries Section 9.3. Pivot Tables Section 9.4. Pivot Charts Part III: Printing Reports Chapter 10. Creating Reports Section 10.1. Report Basics Section 10.2. Printing, Previewing, and Exporting a Report Section 10.3. Formatting a Report Section 10.4. Filtering and Sorting a Report Chapter 11. Designing Advanced Reports Section 11.1. Improving Reports in Design View Section 11.2. The Report Wizard Section 11.3. The Label Wizard Section 11.4. Fine-Tuning Reports with Properties Section 11.5. Expressions Section 11.6. Grouping Part IV: Building a User Interface with Forms Chapter 12. Creating Simple Forms Section 12.1. Form Basics Section 12.2. Sorting and Filtering in a Form Section 12.3. Creating Better Layouts Section 12.4. The Form Wizard Chapter 13. Designing Advanced Forms Section 13.1. Customizing Forms in Design View Section 13.2. Taking Control of Controls Section 13.3. Forms and Linked Tables Chapter 14. Building a Navigation System Section 14.1. Mastering the Navigation Pane Section 14.2. Building Forms with Navigation Smarts Section 14.3. Linking to Related Data Part V: Programming Access Chapter 15. Automating Tasks with Macros Section 15.1. Macro Essentials Section 15.2. Macros and Security Section 15.3. Three Macro Recipes Section 15.4. Managing Macros Section 15.5. Connecting Macros to Forms Section 15.6. Conditional Macros Chapter 16. Automating Tasks with Visual Basic Section 16.1. The Visual Basic Editor Section 16.2. Putting Code in a Form Section 16.3. Understanding Objects Section 16.4. Using Objects Chapter 17. Writing Smarter Code Section 17.1. Exploring the VB Language Section 17.2. Dealing with Trouble Section 17.3. Deeper into Objects Section 17.4. Using VB to Run a Better Business Part VI: Sharing Access with the Rest of the World Chapter 18. Sharing a Database with Multiple Users Section 18.1. Opening Up Your Database to the World Section 18.2. Preparing Your Database Section 18.3. Playing Well with Others Section 18.4. Data Corruption Section 18.5. Securing Your Database Chapter 19. Importing and Exporting Data Section 19.1. Case for Importing and Exporting Section 19.2. Using the Clipboard Section 19.3. Import and Export Operations Section 19.4. Access and XML Section 19.5. Collecting Info by Email Chapter 20. Connecting Access to SQL Server Section 20.1. Should You Switch to SQL Server? Section 20.2. Getting Started: SQL Server 2005 Express Section 20.3. Creating a SQL Server Database Section 20.4. Adding Objects to a SQL Server Database Chapter 21. Connecting Access to SharePoint Section 21.1. Understanding SharePoint Section 21.2. Setting Up SharePoint Section 21.3. SharePoint and Access Part VII: Appendix Appendix A. Customizing the Quick Access Toolbar Section A.1. The Quick Access Toolbar Colophon Index Excel 2007: The Missing Manual By Matthew MacDonald ............................................... 出版: O'Reilly 日期: December 01, 2006 ISBN-10: 0-596-52759-4 ISBN-13: 978-0-596-52759-4 页数: 800 Table of Contents | Index Copyright The Missing Credits Introduction Part I: Worksheet Basics Chapter 1. Creating and Navigating Worksheets Section 1.1. Creating a Basic Worksheet Section 1.2. Editing Data Section 1.3. Navigating in Excel Section 1.4. Saving Files Section 1.5. Opening Files Chapter 2. Adding Information to Worksheets Section 2.1. Adding Different Types of Data Section 2.2. Quick Ways to Add Data Chapter 3. Moving Data Around a Worksheet Section 3.1. Selecting Cells Section 3.2. Moving Cells Around Section 3.3. Adding and Moving Columns or Rows Chapter 4. Managing Worksheets and Workbooks Section 4.1. Worksheets and Workbooks Section 4.2. Find and Replace Section 4.3. Spell Check Chapter 5. Formatting Cells Section 5.1. Formatting Cell Values Section 5.2. Formatting Cell Appearance Chapter 6. Smart Formatting Tricks Section 6.1. The Format Painter Section 6.2. Styles and Themes Section 6.3. Conditional Formatting Chapter 7. Viewing and Printing Worksheets Section 7.1. Controlling Your View Section 7.2. Printing Section 7.3. Controlling Pagination Part II: Formulas and Functions Chapter 8. Building Basic Formulas Section 8.1. Creating a Basic Formula Section 8.2. Formula Shortcuts Section 8.3. Copying Formulas Chapter 9. Math and Statistical Functions Section 9.1. Rounding Numbers Section 9.2. Groups of Numbers Section 9.3. General Math Functions Section 9.4. Trigonometry and Advanced Math Section 9.5. Advanced Statistics Chapter 10. Financial Functions Section 10.1. The World of Finance Section 10.2. Financial Functions Section 10.3. Depreciation Section 10.4. Other Financial Functions Chapter 11. Manipulating Dates, Times, and Text Section 11.1. Manipulating Text Section 11.2. Manipulating Dates and Times Section 11.3. Math with Dates and Times Section 11.4. Date and Time Functions Chapter 12. Lookup, Reference, and Information Functions Section 12.1. The Basic Lookup Section 12.2. Advanced Lookups Section 12.3. Information Functions Section 12.4. Tutorial: Quickly Generating Invoices from a Product Catalog Chapter 13. Advanced Formula Writing and Troubleshooting Section 13.1. Conditions in Formulas Section 13.2. Descriptive Names for Cell References Section 13.3. Variable Data Tables Section 13.4. Controlling Recalculation Section 13.5. Solving Formula Errors Part III: Organizing Worksheets Chapter 14. Tables: List Management Made Easy Section 14.1. The Basics of tablesTables Section 14.2. Sorting and Filtering a Table Section 14.3. Dealing with Duplicate Rows Section 14.4. Performing Table Calculations Chapter 15. Grouping and Outlining Data Section 15.1. Basic Data Grouping Section 15.2. Grouping Timesavers Chapter 16. Templates Section 16.1. Understanding Templates Section 16.2. Creating a New Workbook from a Template Section 16.3. Creating Templates Part IV: Charts and Graphics Chapter 17. Creating Basic Charts Section 17.1. Charting 101 Section 17.2. Basic Tasks with Charts Section 17.3. Practical Charting Section 17.4. Chart Types Chapter 18. Formatting and Perfecting Charts Section 18.1. Chart Styles and Layouts Section 18.2. Adding Chart Elements Section 18.3. Selecting Chart Elements Section 18.4. Formatting Chart Elements Section 18.5. Improving Your Charts Section 18.6. Advanced Charting Chapter 19. Inserting Graphics Section 19.1. Adding Pictures to a Worksheet Section 19.2. Excel's Clip Art Library Section 19.3. Drawing Shapes Part V: Advanced Data Analysis Chapter 20. Scenarios and Goal Seeking Section 20.1. Using Scenarios Section 20.2. Using Goal Seek Section 20.3. Solver Chapter 21. Pivot Tables Section 21.1. Summary Tables Revisited Section 21.2. Building Pivot Tables Section 21.3. Multi-Layered Pivot Tables Section 21.4. Fine-Tuning Pivot Table Calculations Section 21.5. Filtering a Pivot Table Section 21.6. Pivot Charts Part VI: Sharing Data with the Rest of the World Chapter 22. Protecting Your Workbooks Section 22.1. Understanding Excel's Safeguards Section 22.2. Data Validation Section 22.3. Locked and Hidden Cells Chapter 23. Worksheet Collaboration Section 23.1. Preparing Your Workbook Section 23.2. Adding Comments Section 23.3. Tracking Changes Section 23.4. Sharing Your Workbook Chapter 24. Querying Databases and XML Files Section 24.1. Excel and Databases Section 24.2. Understanding XML Section 24.3. Excel and XML Chapter 25. Exchanging Data with Other Programs Section 25.1. Sharing Information in Windows Section 25.2. Embedding and Linking Objects Section 25.3. Transferring Data Chapter 26. Connecting Worksheets to the Web Section 26.1. Putting Worksheets on the Web Section 26.2. Performing Web Queries Section 26.3. Using Hyperlinks Part VII: Programming Excel Chapter 27. Automating Tasks with Macros Section 27.1. Macros 101 Section 27.2. The Macro Recorder Section 27.3. Macro Security Section 27.4. Creating Practical Macros Chapter 28. Programming Spreadsheets with VBA Section 28.1. The Visual Basic Editor Section 28.2. Understanding Macro Code Section 28.3. Exploring the VBA Language Part VIII: Appendix Appendix A. Customizing the Quick Access Toolbar Section A.1. The Quick Access Toolbar Colophon Index PowerPoint 2007: The Missing Manual By Emily A. Moore ............................................... 出版: O'Reilly 日期: December 01, 2006 ISBN-10: 0-596-52738-1 ISBN-13: 978-0-596-52738-9 页数: 504 Table of Contents | Index Copyright Introduction Part 1: Slideshow Basics Chapter 1. Creating a Basic Presentation Section 1.1. Beginning a New Presentation Section 1.2. Choosing a Theme for Your Presentation Section 1.3. Adding Text Section 1.4. Adding More Slides Section 1.5. Moving Around Inside a Presentation Section 1.6. Adding Speaker Notes Section 1.7. Creating and Printing Handouts Section 1.8. Saving and Closing a Presentation Section 1.9. Running a Presentation Chapter 2. Editing Slides Section 2.1. Editing Text Section 2.2. Reversing an Action (Undo) Section 2.3. Finding and Replacing Text Automatically Section 2.4. Spell Check and Other Editorial Tools Section 2.5. Adding Special Characters Chapter 3. Formatting and Aligning Your Text Section 3.1. Automating Text Formatting Section 3.2. Manually Formatting Text Appearance Section 3.3. Manually Aligning and Indenting Text Section 3.4. Formatting Text Boxes Chapter 4. Formatting and Laying Out Your Slides Section 4.1. Changing Slide Layout Section 4.2. Changing Background Color Section 4.3. Reapplying Themes, Colors, and Fonts Chapter 5. Editing Your Slideshow Section 5.1. Viewing Multiple Slides Section 5.2. Adding, Deleting, and Moving Slides Section 5.3. Inserting Slides from Other Slideshows Section 5.4. Editing Slide and Layout Masters Section 5.5. Creating Slide Masters and Layout Masters Section 5.6. Adding Headers and Footers Chapter 6. Adding Charts, Diagrams, and Tables Section 6.1. Creating Charts Section 6.2. Creating Diagrams Section 6.3. Creating Tables Part 2: Presenting Your Slideshow Chapter 7. Delivering Presentations Section 7.1. Setting Up a Slideshow Section 7.2. Slideshows for Multiple Audiences Section 7.3. Presenting Your Slideshow Section 7.4. Creating PowerPoint Shows Section 7.5. Emailing Your Presentation Section 7.6. Packaging Presentations for CD Section 7.7. Presentations over the Web Section 7.8. Converting to Other Formats Section 7.9. Optimizing Presentations Chapter 8. Printing Presentations Section 8.1. Printing Slides (One Slide per Page) Section 8.2. Handouts (Multiple Slides per Page) Section 8.3. Overhead Transparencies Section 8.4. Speaker Notes Section 8.5. Presentation Outline Section 8.6. Tent Cards Part 3: Beyond Bullet Points: Multimedia, Animation, and Interactivity Chapter 9. Putting Images and Documents on Slides Section 9.1. Drawing on Slides Section 9.2. Modifying Drawings Section 9.3. Working with Multiple Drawings Section 9.4. Adding Pictures from Other Programs Section 9.5. Modifying Pictures Section 9.6. Adding Documents from Other Programs Chapter 10. Adding Sound and Video Section 10.1. Adding Sound Section 10.2. Adding Video Chapter 11. Slide Transitions and Animated Effects Section 11.1. Slide Transitions Section 11.2. Custom Animations Chapter 12. Make Your Slides Clickable Section 12.1. Adding Links Section 12.2. Adding Actions Section 12.3. Editing Links and Actions Part 4: Working Faster and More Effectively Chapter 13. Customizing PowerPoint Section 13.1. Customizing How PowerPoint Looks Section 13.2. Customizing How PowerPoint Behaves Section 13.3. Customizing the Way Your Slideshows Run Section 13.4. Installing Add-Ins Chapter 14. Macros: Putting Slideshows on Autopilot Section 14.1. Creating and Editing Macros Section 14.2. Running Macros Chapter 15. Collaborating with Others Section 15.1. Preparing for Collaboration Section 15.2. Sending Out a File for Review Section 15.3. Reviewing with Comments Section 15.4. Finalizing Presentations Section 15.5. SharePoint and Groove Section 15.6. Security Part 5: Appendix Appendix A. Getting Help Section A.1. Getting Help from PowerPoint Section A.2. Displaying Screen Tips Section A.3. Searching Help Topics Section A.4. Getting Help from Microsoft Section A.5. Help from the Community Colophon Index

简介：微软最新版Office2007问世以来，一直受到众多网民的关注。新版本不仅功能更加强大，还增添了许多更实用的功能。在此四部书籍详细介绍Office2007中的Word、Excel、PowerPoint、Access的全部内容，从入门到高级，构建你的技能、学习所需的一切，相信可以让各位同学更加精通！ There are many compelling reasons to upgrade to Microsoft Office 2007 suite of programs soon - vastly overhauled interfaces, newly designed menus and toolbars, jazzy new features, time-saving templates, and animated effects. Unfortunately, the only thing missing was quality documentation. That is until now. Four new books in the Missing Manual series - the books that should have been in the box - step in to help students, teachers, business professionals, and regular folks of every skill level create slick and professional documents, efficiently manage information and data, and produce polished presentations that are sure to impress. Microsoft Office 2007 programs are designed to run on both Microsoft Windows (XP Service Pack 2 or later) and Windows Vista - and these new resources are there to answer every question. Word 2007: The Missing Manual by Chris Grover clearly addresses getting around the radically redesigned user interface with a tabbed toolbar. Readers also discover how to produce sophisticated page layouts, insert forms and tables, use graphics, and generate book-length documents. Practical, jargon-free text makes sharing documents with other people and programs, crafting web pages, automating documents with fields, and automating tasks with macros easy. Excel 2007: The Missing Manual by Matthew MacDonald covers building spreadsheets, adding and formatting information, printing reports, creating charts and graphics, and using basic formulas and functions. Like its siblings in The Missing Manual series, this book crackles with humor and insight about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, timesaving advice. It’s the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information. Access 2007: The Missing Manual by Matthew MacDonald ably illuminates this redesigned application. Readers learn about designing complete databases, maintaining them, searching for information, and building attractive forms for quick-and-easy data entry. Even novice Access users are sure to pick up valuable tricks and techniques to automate common tasks - even if they’ve never touched a line of code before. With plenty of downloadable examples, this objective and witty book helps transform Access enthusiasts into power users. PowerPoint 2007: The Missing Manual by Emily A. Vander Veer specifically covers this new version of the software. The book details all the basics - from creating, saving, setting up, running, and printing a bullets-and-background slideshow to the world of multimedia, animation, and interactivity. Readers learn how to add pictures, sound, video, animated effects, and controls (buttons and links) to their slides, along with ways to pull text, spreadsheets, and animations created in other programs. Created by popular New York Times columnist and O’Reilly author David Pogue, The Missing Manual series sheds light on their subjects with technical insight, plenty of wit, and hard-nosed objectivity for beginners, veteran stand-alone PC users, and those who know their way around a network. Simplify the challenges of today’s workplace and get more out of the programs you use daily by keeping these latest titles handy and within reach. 上传的书籍均来自网络，仅作为阅读交流之用，并无任何商业目的。如果喜欢请购买正版。 已通过安全检测：KAV 20070819 共享服务器：DonkeyServer No1 在线时间：8点-17点