Word 2010

UNIT 1 Basic Skills

• LESSON 1: CREATING AND EDITING A DOCUMENT
• LESSON 2: FORMATTING CHARACTERS
• LESSON 3: WRITING TOOLS
• UNIT 1 APPLICATIONS

UNIT 2 Paragraph Formatting, Tabs, and Advanced Editing

• LESSON 4: FORMATTING PARAGRAPHS
• LESSON 5: TABS AND TABBED COLUMNS
• LESSON 6: MOVING AND COPYING TEXT
• LESSON 7: FIND AND REPLACE
• UNIT 2 APPLICATIONS

UNIT 3 Page Formatting

• LESSON 8: MARGINS AND PRINT OPTIONS
• LESSON 9: PAGE AND SECTION BREAKS
• LESSON 10: PAGE NUMBERS, HEADERS, AND FOOTERS
• LESSON 11: STYLES AND THEMES
• LESSON 12: TEMPLATES
• UNIT 3 APPLICATIONS

UNIT 4 Tables and Columns

• LESSON 13: TABLES
• LESSON 14: ADVANCED TABLES
• LESSON 15: COLUMNS
• UNIT 4 APPLICATIONS

UNIT 5 Graphics and Charts

• LESSON 16: GRAPHICS
• LESSON 17: TEXT BOXES AND DESKTOP PUBLISHING
• LESSON 18: SMARTART AND CHARTS
• UNIT 5 APPLICATIONS

UNIT 6 Advanced Topics

• LESSON 19: MAIL MERGE
• LESSON 20: FIELDS AND FORMS
• LESSON 21: MACROS
• UNIT 6 APPLICATIONS

UNIT 7 Long Documents and Document Sharing

• LESSON 22: FOOTNOTES AND ENDNOTES
• LESSON 23: OUTLINES, INDEXES, AND TABLES OF CONTENTS
• LESSON 24: SHARING YOUR WORK AND HYPERLINKS
• UNIT 7 APPLICATIONS

Excel 2010

UNIT 1 Introduction to Excel

• LESSON 1: GETTING ACQUAINTED WITH EXCEL
• LESSON 2: DEVELOPING WORKBOOKS
• LESSON 3: DEVELOPING EDITING AND FORMATTING SKILLS
• UNIT 1 APPLICATIONS

UNIT 2 Working with Formulas and Functions

• LESSON 4: EXPLORING FORMULA BASICS
• LESSON 5: EXPLORING FUNCTION AND ARGUMENT BASICS
• LESSON 6: USING DATES, TIMES, AND LOGICAL FUNCTIONS
• UNIT 2 APPLICATIONS

UNIT 3 Presenting and Analyzing Worksheet Data

• LESSON 7: BUILDING WORKSHEET CHARTS
• LESSON 8: WORKING WITH EXCEL TABLES
• LESSON 9: USING WHAT-IF ANALYSIS TOOLS
• UNIT 3 APPLICATIONS

UNIT 4 Expanding Workbook Skills

• LESSON 10: AUDITING AND VALIDATING WORKBOOK DATA
• LESSON 11: EXPANDING SKILLS WITH FUNCTIONS AND OBJECTS
• LESSON 12: CONSOLIDATING DATA AND LINKING WORKBOOKS
• UNIT 4 APPLICATIONS

UNIT 5 Exploring List, Data, and Table Features

• LESSON 13: EXPLORING DATA COMMANDS AND TOOLS
• LESSON 14: WORKING WITH EXTERNAL DATA SOURCES
• LESSON 15: USING DATA TABLES AND PIVOTTABLES
• UNIT 5 APPLICATIONS

UNIT 6 Exploring Macros, Templates, and Collaboration

• LESSON 16 WORKING WITH MACROS
• LESSON 17: USING TEMPLATES
• LESSON 18: SHARING WORK
• UNIT 6 APPLICATIONS

PowerPoint 2010

UNIT 1 Basic Skills

• LESSON 1: GETTING STARTED IN POWERPOINT
• LESSON 2: DEVELOPING PRESENTATION TEXT
• LESSON 3: REVISING PRESENTATION TEXT
• UNIT 1 APPLICATIONS

UNIT 2 Presentation Illustration

• LESSON 4: WORKING WITH IMAGES
• LESSON 5: CREATING TABLES
• LESSON 6: CREATING CHARTS
• LESSON 7: CREATING SMARTART GRAPHICS
• UNIT 2 APPLICATIONS

UNIT 3 Visual Impact

• LESSON 8: CUSTOMIZING COLORS AND EFFECTS
• LESSON 9: LAYERING AND GROUPING TECHNIQUES
• LESSON 10: ANIMATING AND USING MULTIMEDIA EFFECTS
• LESSON 11: CUSTOMIZING THEMES AND SLIDE MASTERS
• UNIT 3 APPLICATIONS

UNIT 4 Development and Distribution

• LESSON 12: INTEGRATING WITH OTHER PROGRAMS
• LESSON 13: PREPARING A PRESENTATION FOR DELIVERY
• LESSON 14: PREPARING FOR ELECTRONIC DISTRIBUTION
• UNIT 4 APPLICATIONS

Access 2010