Table of Contents

Introducing Microsoft Office Professional 2010; Certification; For More Information; Let’s Get Started!; Modifying the Display of the Ribbon; Dynamic Ribbon Elements; Changing the Width of the Ribbon; Adapting Exercise Steps; Features and Conventions of This Book; Using the Practice Files; Getting Help; Getting Help with This Book; Getting Help with Office 2010; More Information; Part 1: Microsoft Office Professional 2010; Chapter 1: Explore Office 2010; 1.1 Working in the Program Environment; 1.2 Changing Program Settings; 1.3 Customizing the Ribbon; 1.4 Customizing the Quick Access Toolbar; 1.5 Key Points; Chapter 2: Work with Files; 2.1 Creating and Saving Files; 2.2 Opening, Moving Around in, and Closing Files; 2.3 Viewing Files in Different Ways; 2.4 Key Points; Part 2: Microsoft Word 2010; Chapter 3: Edit and Proofread Text; 3.1 Making Text Changes; 3.2 Finding and Replacing Text; 3.3 Fine-Tuning Text; 3.4 Correcting Spelling and Grammatical Errors; 3.5 Inserting Saved Text; 3.6 Key Points; Chapter 4: Change the Look of Text; 4.1 Quickly Formatting Text; 4.2 Changing a Document’s Theme; 4.3 Manually Changing the Look of Characters; 4.4 Manually Changing the Look of Paragraphs; 4.5 Creating and Modifying Lists; 4.6 Key Points; Chapter 5: Organize Information in Columns and Tables; 5.1 Presenting Information in Columns; 5.2 Creating Tabbed Lists; 5.3 Presenting Information in Tables; 5.4 Formatting Tables; 5.5 Key Points; Chapter 6: Add Simple Graphic Elements; 6.1 Inserting and Modifying Pictures; 6.2 Changing a Document’s Background; 6.3 Inserting Building Blocks; 6.4 Adding WordArt Text; 6.5 Key Points; Chapter 7: Preview, Print, and Distribute Documents; 7.1 Previewing and Adjusting Page Layout; 7.2 Controlling What Appears on Each Page; 7.3 Printing Documents; 7.4 Preparing Documents for Electronic Distribution; 7.5 Key Points; Part 3: Microsoft Excel 2010; Chapter 8: Set Up a Workbook; 8.1 Creating Workbooks; 8.2 Modifying Workbooks; 8.3 Modifying Worksheets; 8.4 Customizing the Excel 2010 Program Window; 8.5 Key Points; Chapter 9: Work with Data and Excel Tables; 9.1 Entering and Revising Data; 9.2 Moving Data Within a Workbook; 9.3 Finding and Replacing Data; 9.4 Correcting and Expanding Upon Worksheet Data; 9.5 Defining Excel Tables; 9.6 Key Points; Chapter 10: Perform Calculations on Data; 10.1 Naming Groups of Data; 10.2 Creating Formulas to Calculate Values; 10.3 Summarizing Data That Meets Specific Conditions; 10.4 Finding and Correcting Errors in Calculations; 10.5 Key Points; Chapter 11: Change Workbook Appearance; 11.1 Formatting Cells; 11.2 Defining Styles; 11.3 Applying Workbook Themes and Excel Table Styles; 11.4 Making Numbers Easier to Read; 11.5 Changing the Appearance of Data Based on Its Value; 11.6 Adding Images to Worksheets; 11.7 Key Points; Chapter 12: Focus on Specific Data by Using Filters; 12.1 Limiting Data That Appears on Your Screen; 12.2 Manipulating Worksheet Data; 12.3 Defining Valid Sets of Values for Ranges of Cells; 12.4 Key Points; Part 4: Microsoft PowerPoint 2010; Chapter 13: Work with Slides; 13.1 Adding and Deleting Slides; 13.2 Adding Slides with Ready-Made Content; 13.3 Dividing Presentations into Sections; 13.4 Rearranging Slides and Sections; 13.5 Key Points; Chapter 14: Work with Slide Text; 14.1 Entering Text in Placeholders; 14.2 Adding Text Boxes; 14.3 Editing Text; 14.4 Correcting and Sizing Text While Typing; 14.5 Checking Spelling and Choosing the Best Words; 14.6 Finding and Replacing Text and Fonts; 14.7 Key Points; Chapter 15: Format Slides; 15.1 Applying Themes; 15.2 Using Different Color and Font Schemes; 15.3 Changing the Slide Background; 15.4 Changing the Look of Placeholders; 15.5 Changing the Alignment, Spacing, Size, and Look of Text; 15.6 Key Points; Chapter 16: Add Simple Visual Enhancements; 16.1 Inserting Pictures and Clip Art Images; 16.2 Inserting Diagrams; 16.3 Inserting Charts; 16.4 Drawing Shapes; 16.5 Adding Transitions; 16.6 Key Points; Chapter 17: Review and Deliver Presentations; 17.1 Setting Up Presentations for Delivery; 17.2 Previewing and Printing Presentations; 17.3 Preparing Speaker Notes and Handouts; 17.4 Finalizing Presentations; 17.5 Delivering Presentations; 17.6 Key Points; Part 5: Microsoft OneNote 2010; Chapter 18: Explore OneNote 2010; 18.1 Navigating in the OneNote Program Window; 18.2 Working in the OneNote Program Window; 18.3 Exploring OneNote in the Default Notebook; 18.4 Customizing OneNote; 18.5 Key Points; Chapter 19: Create and Configure Notebooks; 19.1 Creaaaaaating a Notebook for Use by One Person; 19.2 Creating a Notebook for Use by Multiple People; 19.3 Creating Sections and Pages; 19.4 Key Points; Chapter 20: Create and Organize Notes; 20.1 Working with Note Containers; 20.2 Entering Content Directly onto a Page; 20.3 Sending Content to OneNote; 20.4 Capturing Audio and Video Notes; 20.5 Taking Notes on the Side; 20.6 Key Points; Part 6: Microsoft Outlook 2010; Chapter 21: Send and Receive E-Mail Messages; 21.1 Creating and Sending Messages; 21.2 Attaching Files to Messages; 21.3 Viewing Messages and Message Attachments; 21.4 Configuring Reading Pane Behavior; 21.5 Viewing Message Participant Information; 21.6 Responding to Messages; 21.7 Key Points; Chapter 22: Store and Access Contact Information; 22.1 Saving and Updating Contact Information; 22.2 Communicating with Contacts; 22.3 Displaying Different Views of Contact Records; 22.4 Printing Contact Records; 22.5 Key Points; Chapter 23: Manage Scheduling; 23.1 Scheduling and Changing Appointments; 23.2 Scheduling and Changing Events; 23.3 Scheduling Meetings; 23.4 Responding to Meeting Requests; 23.5 Displaying Different Views of a Calendar; 23.6 Key Points; Chapter 24: Track Tasks; 24.1 Creating Tasks; 24.2 Updating Tasks; 24.3 Removing Tasks and Items from Task Lists; 24.4 Managing Task Assignments; 24.5 Displaying Different Views of Tasks; 24.6 Key Points; Part 7: Microsoft Access 2010; Chapter 25: Explore an Access 2010 Database; 25.1 Working in Access 2010; 25.2 Understanding Database Concepts; 25.3 Exploring Tables; 25.4 Exploring Forms; 25.5 Exploring Queries; 25.6 Exploring Reports; 25.7 Previewing and Printing Access Objects; 25.8 Key Points; Chapter 26: Create Databases and Simple Tables; 26.1 Creating Databases from Templates; 26.2 Creating Databases and Tables Manually; 26.3 Manipulating Table Columns and Rows; 26.4 Refining Table Structure; 26.5 Creating Relationships Between Tables; 26.6 Key Points; Chapter 27: Create Simple Forms; 27.1 Creating Forms by Using the Form Tool; 27.2 Changing the Look of Forms; 27.3 Changing the Arrangement of Forms; 27.4 Key Points; Chapter 28: Display Data; 28.1 Sorting Information in Tables; 28.2 Filtering Information in Tables; 28.3 Filtering Information by Using Forms; 28.4 Locating Information That Matches Multiple Criteria; 28.5 Key Points; Part 8: Microsoft Publisher 2010; Chapter 29: Get Started with Publisher 2010; 29.1 Starting New Publications; 29.2 Storing Personal and Company Information; 29.3 Previewing and Printing Publications; 29.4 Key Points; Chapter 30: Create Visual Interest; 30.1 Working with Text Boxes; 30.2 Working with WordArt; 30.3 Working with Graphics; 30.4 Working with Shapes; 30.5 Working with Ready-Made Visual Elements; 30.6 Key Points; Chapter 31: Create Colorful Cards and Calendars; 31.1 Creating Folded Cards; 31.2 Creating Postcards; 31.3 Creating Calendars; 31.4 Key Points;

Joan Lambert is the author of more than a dozen books on Windows and Office, including several popular STEP BY STEP titles from Microsoft Press.

Curtis D. Frye is the author of several books on Access and Excel, including MICROSOFT OFFICE EXCEL 2007 STEP BY STEP, along with numerous online training courses.