Skills for Success with Microsoft Office 2010, Volume 1

Kris Townsend is an Information Systems instructor at Spokane Falls Community College in Spokane, Washington. Kris earned a bachelor's degree in both Education and Business, and a master's degre in Education. He has also worked as a public school teacher and as a systems analyst. Kris enjoys working with wood, snowboarding, and camping. He commutes to work by bike and enjoys long rides in the Palouse country south of Spokane.   Robert L. Ferrett recently retired as the Director of the Center for Instructional Computing at Eastern Michigan University, where he provided computer training and support to faculty. He has authored or co-authored more than 70 books on Access, PowerPoint, Excel, Publisher, WordPerfect, Windows, and Word. He has been designing, developing, and delivering computer workshops for more than two decades.  Catherine Hain is an instructor at Central New Mexico Community College in Albuquerque, New Mexico. She teaches computer applications classes in the Business and Information Technology School, both in the classroom and through the distance learning office. Catherine holds a bachelor's degree in Management and Marketing and a master's degree in Business Administration.   Alicia Vargas is an Associate Professor of Business Information Technology at Pasadena City College on California. She holds a bachelor's and a master's degree in Business Education from California State University, Los Angeles and has authored numerous textbooks and training materials on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

Start! Common Features of Office 2010 Skill 1    Start Word and Navigate the Word Window

Skill 2    Start Excel and PowerPoint and Work with Multiple Windows

Skill 3    Save Files in New Folders

Skill 4    Print and Save Documents

Skill 5    Open Student Data Files and Save Copies Using Save As

Skill 6    Type and Edit Text

Skill 7    Cut, Copy, and Paste Text

Skill 8    Format Text and Paragraphs

Skill 9    Use the Ribbon

Skill 10  Use Shortcut Menus and Dialog Boxes

 

More Skills

More Skills 11 Capture Screens with the Snipping Tool

More Skills 12 Use Microsoft Office Help

More Skills 13 Organize Files

More Skills 14 Save Documents to Windows Live SkyDrive

 

Word Chapter 1 Create Documents with Word 2010

Skill 1 Create New Documents and Enter Text

Skill 2 Edit Text and Use Keyboard Shortcuts

Skill 3 Select Text

Skill 4 Insert Text from Other Documents

Skill 5 Change Fonts, Font Sizes, and Font Styles

Skill 6 Insert and Work with Graphics

Skill 7 Check Spelling and Grammar

Skill 8 Use the Thesaurus and Set Proofing Options

Skill 9 Create Document Footers

Skill 10 Work with the Print Page and Save Documents in Other Formats

 

More Skills

More Skills 11 Split and Arrange Windows

More Skills 12 Insert Symbols

More Skills 13 Use Collect and Paste to Create Documents

More Skills 14 Insert Screenshots into Documents

 

Word Chapter 2 Format and Organize Text

Skill 1 Set Document Margins

Skill 2 Align Text and Set Indents

Skill 3 Modify Line and Paragraph Spacing

Skill 4 Format Text Using Format Painter

Skill 5 Find and Replace Text

Skill 6 Create Bulleted and Numbered Lists

Skill 7 Insert and Format Headers and Footers

Skill 8 Insert and Modify Footnotes

Skill 9 Add Citations

Skill 10 Create Bibliographies

 

More Skills

More Skills 11 Record AutoCorrect Entries

More Skills 12 Use AutoFormat to Create Numbered Lists

More Skills 13 Format and Customize Lists

More Skills 14 Manage Document Properties

 

Word Chapter 3 Word with Graphics, Tabs, and Tables

Skill 1 Insert Pictures from Files

Skill 2 Resize and Move Pictures

Skill 3 Format Pictures Using Styles and Artistic Effects

Skill 4 Set Tab Stops

Skill 5 Enter Text with Tab Stops

Skill 6 Apply Table Styles

Skill 7 Create Tables

Skill 8 Add Rows and Columns to Tables

Skill 9 Format Text in Table Cells

Skill 10 Format Tables

 

More Skills

More Skills 11 Insert Text Boxes

More Skills 12 Format with Text Effects

More Skills 13 Create Tables from Existing Lists

More Skills 14 Insert Drop Caps

 

Word Chapter 4 Apply Special Text, Paragraph, and Document Formats

Skill 1 Create Multiple-Column Text

Skill 2 Insert a Column Break

Skill 3 Apply and Format Text Effects

Skill 4 Use and Create Quick Styles

Skill 5 Add Borders and Shading to Paragraphs and Pages

Skill 6 Insert and Format Clip Art Graphics

Skill 7 Insert SmartArt Graphics

Skill 8 Format SmartArt Graphics

Skill 9 Create Labels Using Mail Merge

Skill 10 Preview and Print Mail Merge Documents

 

More Skills

More Skills 11 Create a Resume from a Template

More Skills 12 Create Outlines

More Skills 13 Prepare Documents for Distribution

More Skills 14 Preview and Save Documents as Web Pages

 

Excel Chapter 1 Create Workbooks with Excel 2010

Skill 1    Create and Save New Workbooks

Skill 2    Enter Worksheet Data and Merge and Center Titles

Skill 3    Construct Addition and Subtraction Formulas

Skill 4    Construct Multiplication and Division Formulas

Skill 5    Adjust Column Widths and Apply Cell Styles

Skill 6    Use the SUM Function

Skill 7    Copy Formulas and Functions Using the Fill Handle

Skill 8    Format, Edit, and Check the Spelling of Data

Skill 9    Create Footers and Change Page Settings

Skill 10  Display and Print Formulas and Scale Worksheets for Printing

 

More Skills

More Skills 11    Create New Workbooks from Templates

More Skills 12    Use Range Names in Formulas

More Skills 13    Change Themes

More Skills 14    Manage Document Properties




Excel Chapter 2 Create Charts

Skill 1    Open Existing Workbooks and Align Text

Skill 2    Construct and Copy Formulas Containing Absolute Cell References

Skill 3    Format Numbers

Skill 4    Create Column Charts

Skill 5    Format Column Charts

Skill 6    Create Pie Charts and Chart Sheets

Skill 7    Apply 3-D Effects and Rotate Pie Chart Slices

Skill 8    Explode and Color Pie Slices, and Insert Text Boxes

Skill 9    Update Charts and Insert WordArt

Skill 10  Prepare Chart Sheets for Printing

 

More Skills

More Skills 11    Insert and Edit Comments

More Skills 12    Change Chart Types

More Skills 13    Copy Excel Data to Word Documents

More Skills 14    Fill Series Data into Worksheet Cells




Excel Chapter 3 Manage Multiple Worksheets in a Workbook

Skill 1    Work with Sheet Tabs

Skill 2    Enter and Format Dates

Skill 3    Clear Cell Contents and Formats

Skill 4    Move, Copy, Paste and Paste Options

Skill 5    Work with Grouped Worksheets

Skill 6    Use Multiple Math Operators in a Formula

Skill 7    Format Grouped Worksheets

Skill 8    Insert and Move Worksheets

Skill 9    Construct Formulas that Refer to Cells in Other Worksheets

Skill 10  Create Clustered Bar Charts

 

More Skills

More Skills 11    Create Organization Charts

More Skills 12    Create Line Charts

More Skills 13    Set and Clear Print Areas

More Skills 14    Insert Hyperlinks




Excel Chapter 4 Using Excel Functions and Tables

Skill 1    Use the SUM and AVERAGE Functions

Skill 2    Use the MIN and MAX Functions

Skill 3    Move Ranges with Functions, Add Borders, and Rotate Text

Skill 4    Use the IF Function

Skill 5    Apply Conditional Formatting with Custom Formats, Data Bars, and Sparklines

Skill 6    Use Find and Replace and Insert the NOW Function

Skill 7    Freeze and Unfreeze Panes

Skill 8    Create and Sort Excel Tables

Skill 9    Use the Search Filter in Excel Tables

Skill 10  Convert Tables to Ranges, Hide Rows and Columns, and Format Large Worksheets

 

More Skills

More Skills 11    Apply Conditional Color Scales with Top and Bottom Rules

More Skills 12    Use the Payment (PMT) Function

More Skills 13    Create PivotTable Reports

More Skills 14    Use Goal Seek

 

Access Chapter 1 Work with Databases and Create Tables

Skill 1 Open and Organize Existing Database

Skill 2 Enter and Edit Table Data

Skill 3 Create Forms and Enter Data

Skill 4 Filter Data Queries

Skill 5 Create, Preview, and Print Reports

Skill 6 Create Databases and Tables

Skill 7 Change Data Types and Other Field Properties

Skill 8 Create Tables in Design View

Skill 9 Relate Tables

Skill 10 Enter Data in Related Tables

 

More Skills

More Skills 11 Compact and Repair Databases

More Skills 12 Import Data from Excel

More Skills 13 Work with the Attachment Data Type

More Skills 14 Work with the Hyperlink and Yes/No Data Types




Access Chapter 2 Manage Datasheets and Create Queries

Skill 1 Find and Replace Data

Skill 2 Filter and Sort Datasheets

Skill 3 Use the Simple Query Wizard

Skill 4 Format Datasheets

Skill 5 Add Date and Time Criteria

Skill 6 Create Queries in Design View

Skill 7 Add Calculated Fields to Queries

Skill 8 Work with Logical Criteria

Skill 9 Add Wildcards to Query Criteria

Skill 10 Group and Total Queries 

 

More Skills

More Skills 11 Export Queries to Other Fle Formats

More Skills 12 Find Duplicates Records

More Skills 13 Find Unmatched Records

More Skills 14 Create Crosstab Queries

 

Access Chapter 3 Create Forms

Skill 1    Use the Form Wizard

Skill 2    Format Forms in Layout View

Skill 3    Use Forms to Modify Data

Skill 4    Use the Blank Form Tool

Skill 5    Customize Form Layouts

Skill 6    Add Input Masks

Skill 7    Apply Conditional Formatting

Skill 8    Create One-to-Many Forms

Skill 9    Enter Data Using One-to-Many Forms

Skill 10  Create Forms from Queries

 

More Skills

More Skills 11    Validate Fields

More Skills 12    Add Combo Boxes to Forms

More Skills 13    Create Multiple Item Forms

More Skills 14    Create Macros




Access Chapter 4 Create Reports

Skill 1    Create Reports and Apply Themes

Skill 2    Modify Report Layouts

Skill 3    Prepare Reports for Printing

Skill 4    Use the Blank Report Tool

Skill 5    Group and Sort Reports

Skill 6    Format and Filter Reports

Skill 7    Create Label Reports

Skill 8    Use the Report Wizard

Skill 9    Modify Layouts in Design View

Skill 10  Add Totals and Labels to Reports

 

More Skills

More Skills 11  Export Reports to Word

More Skills 12  Export Reports to HTML Documents

More Skills 13  Create Parameter Queries

More Skills 14  Create Reports for Parameter Queries

 

PowerPoint Chapter 1 Getting Started with PowerPoint 2010

Skill 1 Open,View, and Save Presentations

Skill 2 Edit and Replace Text in Normal View

Skill 3 Format Slide Text

Skill 4 Check Spelling and Use the Thesaurus

Skill 5 Insert Slides and Modify Slide Layouts

Skill 6 Insert and Format Pictures

Skill 7 Organize Slides Using Slide Sorter View

Skill 8 Apply Slide Transitions and View Slide Shows

Skill 9 Insert Headers and Footers and Print Presentation Handouts

Skill 10 Add Notes Pages and Print Notes

 

More Skills

More Skills 11 Type Text in the Outline Tab

More Skills 12 Use Keyboard Shortcuts

More Skills 13 Move and Delete Slides in Normal View

More Skills 14 Design Presentations for Audience and Location

 

PowerPoint Chapter 2 Format a Presentation

Skill 1 Create New Presentations

Skill 2 Change Presentation Themes

Skill 3 Apply Font and Color Themes

Skill 4 Format Slide Backgrounds with Styles

Skill 5  Format Slide Backgrounds with Pictures and Textures

Skill 6 Format Text with WordArt

Skill 7 Change Character Spacing and Font Color

Skill 8 Modify Bulleted and Numbered Lists

Skill 9 Move and Copy Text and Objects

Skill 10 Use Format Painter and Clear All Formatting

 

More Skills

More Skills 11 Edit Slide Masters

More Skills 12 Save and Apply Presentation Templates

More Skills 13 Create Slides from Microsoft Word Outlines

More Skills 14 Design Presentation with Contrasts

 

PowerPoint Chapter 3 Enhance Presentations with Graphics

Skill 1 Insert Slides from Other Presentations

Skill 2 Insert, Size, and Move Clip Art

Skill 3 Modify Pictures Shapes, Borders, and Effects

Skill 4 Insert, Size, and Move Shapes

Skill 5 Add Text to Shapes and Insert Text Boxes

Skill 6 Apply Gradient Fills and Group and Align Graphics

Skill 7 Convert Text to SmartArt Graphics and Add Shapes

Skill 8 Modify SmartArt Layouts, Colors, and Styles

Skill 9 Insert Video Files

Skill 10 Apply Video Styles and Adjust Videos

 

More Skills

More Skills 11 Compress Pictures

More Skills 12 Save Groups as Picture File

More Skills 13 Change Object Order

More Skills 14 Design Presentations Using Appropriate Graphics

 

PowerPoint Chapter 4 Present Data Using Tables, Charts, and Animation

Skill 1 Insert Tables

Skill 2 Modify Table Layouts

Skill 3 Apply Table Styles

Skill 4 Insert Column Charts

Skill 5 Edit and Format Charts

Skill 6 Insert Pie Charts

Skill 7 Apply Animation Entrance and Emphasis Effects

Skill 8 Modify Animation Timing and Use Animation Painter

Skill 9 Remove Animation and Modify Duration

Skill 10 Navigate Slide Shows

 

More Skills

More Skills 11 Prepare Presentations to be Viewed Using Office PowerPoint Viewer

More Skills 12 Insert Hyperlinks in a Presentation

More Skills 13 Create Photo Albums

More Skills 14 Design Presentations with Appropriate Animation

 

Integrated Projects

Chapter 1 Integrating Word, Excel, Access, and PowerPoint

Skill 1 Move Text between Word Documents

Skill 2 Apply Heading Styles in Word

Skill 3 Create a PowerPoint Presentation from a Word Document

Skill 4 Insert and Modify a Shape in PowerPoint

Skill 5 Import a Word Table into an Excel Workbook

Skill 6 Insert a Shape from PowerPoint into Word and Excel

Skill 7 Create and Work with an Excel Table

Skill 8 Link Data between Office Applications Using OLE

Skill 9 Create Envelopes Using Data from Access

Skill 10 Create Name Tags Using Data in Excel

 

More Skills

More Skills 11 Insert Subtotals in Excel and Link Data to a Word Document

More Skills 12 Insert Slides from Another Presentation

More Skills 13 Move and Copy Excel Worksheets and Consolidate Data

More Skills 14 Compare Shared Excel Workbooks

 

Chapter 2 More Integrated Projects for Word, Excel, Access, and PowerPoint

Skill 1 Create an Access Append Query

Skill 2 Export Data from Access into Excel

Skill 3 Create an Excel PivotTable Report

Skill 4 Create External References between Excel Workbooks

Skill 5 Insert a SmartArt Organization Chart into PowerPoint

Skill 6 Insert an Excel PivotTable into PowerPoint

 

Skill 7 Insert a PowerPoint Outline in Word and Create a Cover Page and Table of Contents

Skill 8 Link and Embed Data from Excel into Word

Skill 9 Export Data from Access to an RTF File and Insert the File into Word

Skill 10 Insert Objects from PowerPoint into Word

 

More Skills

More Skills 11 Create an Excel PivotChart and Link the PivotChart to Word

More Skills 12 Create a Hyperlink between PowerPoint, Word, and Excel Files

More Skills 13 Insert a Total Row in an Excel Table and Link the Table to PowerPoint

More Skills 14 Compare Word Documents