MICROSOFT WORD

Getting Started with Wor

•   Navigate in Microsoft Word.
•   Create and Save Word Documents
•   Manage Your Workspace
•   Edit Documents
•   Preview and Print Documents
•   Customize the Word Environment

Formatting Text and Paragraphs

Apply Character Formatting
•   Control Paragraph Layout
•   Align Text Using Tabs
•    Display Text in Bulleted or Numbered Lists
•    Apply Borders and Shading

Working More Efficiently

•   Make Repetitive Edits
•   Apply Repetitive Formatting
•   Use Styles to Streamline Repetitive
•   Formatting Tasks

Managing Lists

•   Sort a List
•   Format a List

Adding Tables

•   Insert a Table
•    Modify a Table
•   Format a Table
•   Convert Text to a Table

Inserting Graphic Objects

•   Insert Symbols and Special Characters
•   Add Images to a Document

Controlling Page Appearance

•   Apply a Page Border and Color
•    Add Headers and Footers
•    Control Page Layout
•   Add a Watermark

Preparing to Publish a Document

•   Check Spelling, Grammar, and Readability
•   Use Research Tools
•   Check Accessibility
•    Save a Document to Other Formats

 MICROSOFT POWERPOINT

Getting Started with powerpoint

•   Navigate the PowerPoint Environment
•   Create and Save a PowerPoint Presentation
•   Use PowerPoint Help

Developing a PowerPoint Presentation

•   Select a Presentation Type
•   View and Navigate a Presentation
•   Edit Text
•   Build a Presentation

Performing Advanced Text Editing Operations

•   Format Characters
•   Format Paragraphs
•   Format Text Boxes

Adding Graphical Elements to Your Presentation

•   Insert Images
•   Insert Shapes

Modifying Objects in Your Presentation

•   Edit Objects
•   Format Objects
•   Group Objects
•   Arrange Objects
•   Animate Objects

Adding Tables to Your Presentation

•   Create a Table
•   Format a Table
•   Insert a Table from Other Microsoft Office Applications

Adding Charts to Your Presentation

•   Create a Chart
•   Format a Chart

 MICROSOFT EXCEL

Getting Started

•   Starting Excel
•   Opening a Workbook
•   Understanding the Display Screen
•   Working with the Ribbon
•   Exploring the File Tab
•   Working with the Quick Access Toolbar
•   Working with the Status Bar
•   Switching Between Opened Workbooks
•   Using Excel Help

Getting Started

•   Moving the Cell Pointer
•   Selecting a Range of Cells
•   Creating a New Workbook
•   Inserting, Renaming, and Deleting Worksheets
•   Entering Constant Values
•   Using Auto Fill to Enter Data
•   Saving a Workbook
•   Editing Cell Contents
•   Clearing Cell Contents
•   Working with Undo and Redo
•   Closing a Workbook

Using Formulas

•   Entering Formulas
•   Using Auto Fill with Formulas
•   Using the SUM Function
•   Summing Columns or Rows Automatically
•   Using Statistical Functions
•   Working with the Range Finder
•   Using Formula Error Checking

Working with Constant Values and Formulas

•   Copying and Pasting Constant Values and Formulas
•   Cutting and Pasting Constant Values and Formulas
•   Using Collect and Paste

Formatting Worksheets

•   Formatting Numbers
•   Changing the Font Format
•   Aligning Cell Contents
•   Merging Cells
•   Adding Borders
•   Applying Cell Styles

Modifying Columns and Rows

•   Changing Column Width
•   Changing Row Height
•   Inserting and Deleting Columns or Rows
•   Hiding Columns or Rows

Editing Workbooks

•   Working with AutoCorrect
•   Checking Spelling
•   using find and replace

Printing Worksheets

•   Using Print Preview
•   Working with Print Settings
•   Using Page Setup Tools
•   Working in Page Layout View
•   Creating a Header and Footer
•   Using Page Break Preview
•   Printing a Worksheet
•   Exiting Excel