Module 1: Creating a Microsoft Word Document

• This module explains how to get started creating Microsoft Word documents.
• Topics
  • Starting a Microsoft Document
  • Creating a Document
  • Saving a Document
  • Importing a File
  • The Status Bar
  • Closing a Document
  • Exercise: Create a Microsoft Word Document

Module 2: The Ribbon

• This module explains how to work with the Ribbon in Microsoft Word.
• Topics
  • The Ribbon
  • Tabs
  • Groups
  • Commands
  • Exercise: Exploring the Ribbon

Module 3: The Backstage View (The File Menu)

• This module explains how to work with the many features located in the Backstage view.
• Topics
  • Introduction to the Backstage View
  • Opening a Document
  • Exercise: Open a Document
  • New Documents and Word Templates
  • Exercise: Write a Thank You Letter Using a Template Letter
  • Configuring Documents to Print
  • Exercise: Print a Document

• Adding Your Name to Microsoft Word
• Adding Values to Document Properties
• Working with Autosaved Versions of Documents

Module 4: The Quick Access Toolbar

• This module explains how to work with the Quick Access Toolbar in Microsoft Word.
• Topics
  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands and Groups
  • Placement
  • Exercise: Customize the Quick Access Toolbar

Module 5: Formatting Microsoft Word Documents

• This module explains how work with formatting in Microsoft Word.
• Topics
  • Selecting Text
  • Selecting Fonts
  • Exercise: Working with Fonts
  • Working with Lists
  • Exercise: Working with Lists
  • Inserting a Hyperlink in a Document
  • Exercise: Inserting a Hyperlink
  • Using Styles
  • Exercise: Applying and Creating Custom Styles
  • Using Themes
  • Using the Ruler
  • Exercise: Using Tabs
  • Setting Margins
  • Exercise: Setting Margins

Module 6: Editing Documents

• This module explains how to edit documents in Microsoft Word.
• Topics
  • Find
  • Find and Replace
  • Find and Replace Tips
  • Appending Text to a Document
  • Exercise: Using Find and Replace
  • Using the Clipboard

Module 7: Finalizing Microsoft Word Documents

• This module explains how to use various features to finalize Microsoft Word documents.
• Topics
  • Adding Page Numbers
  • Exercise: Adding Page Numbers
  • Headers and Footers
  • Exercise: Using Headers and Footers
  • Checking Spelling and Grammar
  • Exercise: Checking Spelling and Grammar

Module 8: Advanced Formatting

• This module explains how to work with formatting features in Microsoft Word.
• Topics
  • Shading and Borders
  • Exercise: Using Shading and Borders
  • Setting Line and Paragraph Spacing
  • Changing Styles
  • Exercise: Changing Styles
  • Paragraph Marks and Other Formatting Symbols
  • Exercise: Using Formatting Symbols

Module 9: Working with Tables

• This module explains how to work with tables.
• Topics
  • Inserting a Table.
  • Exercise: Insert a Table.
  • Table Styles
  • Exercise: Adding Styles to a Table
  • Formatting a Table
  • Exercise: Formatting a Table

MS Excel Modules:

Module 1: Creating a Microsoft Excel Workbook

• This module explains how to get started creating Microsoft Excel workbooks.
• Topics
  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets

• Copying and Moving Worksheets
• Changing the Order of Worksheets
• Splitting the Worksheet Window
• Closing a Workbook

Module 2: The Ribbon

• The Ribbon is the display you see at the top of the Microsoft Excel window. It is your primary interface with Excel. It allows you to access most of the commands available to you in Excel. The Ribbon is composed of three parts: Tabs, Groups and Commands. In this lesson, you will learn about all three.
• Topics
  • Tabs
  • Groups
  • Commands

Module 3: The Backstage View (The File Menu)

• This module explains how to work with the Backstage View (The File Menu).
• Topics
  • Introduction to the Backstage View
  • Opening a Workbook
  • New Workbooks and Excel Templates
  • Printing Worksheets
  • Adding Your Name to Microsoft Excel
  • Managing Workbook Versions

Module 4: The Quick Access Toolbar

• This module explains how to work with the Quick Access Toolbar.
• Topics
  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement

Module 5: Entering Data in Microsoft Excel Worksheets

• This module explains how to enter data.
• Topics
  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle

Module 6: Formatting Microsoft Excel Worksheets

• This module explains how to format Microsoft Excel Worksheets.
• Topics
  • Selecting Ranges of Cells
  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group

Module 7: Using Formulas in Microsoft Excel

• This is the math lesson, and whether you love or hate math, by the end of this lesson you will agree that Excel makes math easy. We will start by explaining some of the basic concepts you need to understand regarding how Excel does math and then will get into entering formulas.
• Topics
  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References

Module 8: Working with Rows and Columns

• This module explains how to work with rows and columns.
• Topics
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes

Module 9: Editing Worksheets

• This module explains how to edit worksheets.
• Topics
  • Find

• Find and Replace
• Using the Clipboard
• Managing Comments

Module 10: Finalizing Microsoft Excel Worksheets

• This module explains how to finalize Microsoft Excel Worksheets.
• Topics
  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers

Module 11: Working with Lists

• This module explains how to work with lists.
• Topics
  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List
  • Grouping and Ungrouping Data in a List

MS Power Point Modules:

Module 1: Creating a PowerPoint Presentation

• This module explains how get started using Microsoft PowerPoint.
• Topics
  • Starting Microsoft PowerPoint
  • Normal View
  • Creating a Presentation
  • Saving a Document
  • Importing a File
  • The Status Bar
  • Closing a Presentation
  • Exercise: Creating a Microsoft PowerPoint Presentation

Module 2: The Ribbon

• This module explains how to work with the Ribbon in Microsoft PowerPoint.
• Topics
  • The Ribbon
  • Tabs
  • Groups
  • Commands
  • Exercise: Exploring the Ribbon

Module 3: The Quick Access Toolbar

• This module explains how to work with the Quick Access toolbar in Microsoft PowerPoint.
• Topics
  • Adding Common Commands
  • Adding More Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement
  • Exercise: Customize the Quick Access Toolbar

Module 4: The Backstage View (The File Menu)

• This module explains how to work with the Backstage View in Microsoft PowerPoint.
• Topics
  • Introduction to the Backstage View
  • Opening a Presentation
  • Exercise: Opening a Presentation
  • New Presentation and Presentation Templates
  • Exercise: Creating an Agenda Using a Template
  • Presentation Properties
  • Adding Your Name to a Microsoft PowerPoint

Module 5: Formatting Microsoft PowerPoint Presentations

• This module explains how work with formatting features in Microsoft PowerPoint presentations.
• Topics
  • Selecting a Slide Layout
  • Adding text
  • Adding Text from a Text File or Word Outline
  • Editing Text
  • Formatting Text
  • Formatting Text as WordArt
  • Creating Bulleted and Numbered Lists
  • Formatting Text Placeholder
  • Adding Slides to a Presentation
  • Arranging Slides
  • Exercise: Formatting Text

Module 6: Working with Images

• This module explains how to work with images in Microsoft PowerPoint.
• Topics
  • Adding Images to a Slide
  • Inserting a Picture
  • Inserting Clip Art
  • Capturing and Inserting a Snapshot
  • Editing an Image
  • Formatting Images
  • Applying a Style and Cropping an Image
  • Grouping and Ungrouping Images
  • Arranging Images
  • Adding Shapes
  • Exercise: Working with Images and Shapes

Module 7: Working with Tables and Charts

• This module explains how to work with tables and charts in Microsoft PowerPoint.
• Topics
  • Inserting a Table
  • Formatting Tables
  • Importing Tables from External Sources
  • Exercise: Working with a Table
  • Inserting a Chart
  • Formatting a Chart
  • Importing Charts from External Sources
  • Exercise: Working with Charts