Microsoft's Word is a Word Processor that is used primarily to create and edit text-based documents.
Prerequisites:
·Basic Understanding of Microsoft Windows
Course Outline:
Getting Started
·Understanding Word
·Examining Word's Working Screen
·The Office Assistant
·Navigating Documents
·Entering Text
·Editing Text
·Saving Files
Using Editing Functions
·Selecting & Replacing Text
·Using the Clipboard
·Finding & Replacing Text
·Checking Spelling & Grammar In Documents
Formatting Text
·Understanding Fonts
·Choosing Fonts
·Adjusting Font Size
·Changing Font Attributes
·Aligning Text
Examining Other Formatting Techniques
·Applying Borders & Shading
·Applying Bullets & Numbers
·Indenting Paragraphs
·Using Format Painter
·Inserting Graphics
·Resizing Graphics
Working with Documents
·Finding Files
·Previewing Files
·Using Multiple Windows
·Exploring Views
·Using Help
Creating Documents from Document Templates
·Understanding Templates
·Using Template Wizards
·Replacing Fields in Templates
·Understanding Non-printing Characters
Printing Documents
·Previewing Documents
·Adjusting Margins
·Printing Documents
·Adjusting Print Settings
Drawing Tools
·Understanding the Drawing Toolbar
·Applying Fill Effects
·Using AutoShapes
·Adjusting Drawing Objects
INTRODUCTION TO MICROSOFT EXCEL
Microsoft's Excel is a Spreadsheet application that allows user to enter, analyze and calculate data. The Excel files are Workbooks where the work is stored. Worksheets are electronic ledgers in a Workbook where one actually lists and analyzes data. This course teaches the participant the skills required to effectively work with application software.
Prerequisites:
·Basic Understanding of Microsoft Windows
Course Outline:
Getting Started
·Understanding Excel
·Examining Excel's Working Screen
·The Office Assistant
·Navigating Workbooks
·Entering & Editing Data
·Widening columns
·Saving Worksheets
Using Formula and Functions
·Understanding Formulas
·Entering Formulas
·Understanding Functions
·Entering Function
·Using Paste Function
·Using Subtraction
Relocating and Reusing Data
·Using Clipboard
·Understanding Fills
·Filling a Series
Exploring Formula Construction
·Understanding Cell References
·Using Relative Addressing
·Inserting Absolute Addresses
·Using Mixed Addresses
·Reusing a Formula
·Dragging Ranges in Functions
Formatting Worksheet Appearance
·Understanding Formatting
·Adjusting Column Widths
·Applying Colors to Cells
·Formatting Numbers
·Aligning Text
·Changing Fonts & Font Size
·Changing Font Styles
·Applying Borders
·Using Format Painter
Printing Worksheets
·Previewing before Printing
·Understanding Page Setup
·Adjusting Page Setup Options
·Setting Print Areas
·Adjusting Margins
·Printing Worksheets
Working with Charts
·Understanding Charts
·Creating Charts
·Editing Charts
·Editing Titles
Using Help
·Viewing the Help Contents
·Working with the Index
·Finding Help Text
·Using Context-sensitive Help
INTRODUCTION TO MICROSOFT ACCESS
Microsoft's Access is a relational database program that allows one to store and analyze database records or data. Unlike other databases, Access allows one to store a number of related tables and options in a single database instead of creating a new database for each table.
Prerequisites:
·Basic Understanding of Microsoft Windows
Course Outline:
Getting Started
·Understanding Access
·Examining Access's Working Screen
·Understanding Database Objects
·The Office Assistant
·Closing Access
Examining Tables
·Understanding Tables
·Moving around in Tables
·Viewing Multiple Tables
·Moving Columns
·Adjusting Columns and Rows
·Saving and Closing Tables
Using Tables
·Entering Data
·Using AutoCorrect
·Sorting Records
·Deleting Records
·Finding Records in Tables
·Editing Records
Creating Tables
·Deciding What to Include
·Opening Table Wizard
·Selecting Fields
·Renaming Fields
·Naming Tables
·Adding Table Relationships
·Adding Fields
Using Forms
·Opening Forms
·Navigating Through Forms
·Finding Records in Forms
·Editing Records using Forms
·Creating Auto Forms
·Adding Records using Forms
·Switching Views
·Saving and Naming Forms
Using Filters
·Understanding Filters
·Creating Filters By Selection
·Sorting Filtered records
·Creating Filters By Forms
Using Queries
·Understanding Queries
·Running Queries
·Closing Record sets
·Creating Select Queries
·Modifying Queries
·Creating Summary Queries
·Finding Duplicate Records
·Deleting Records within Record sets
Working with Reports
·Understanding Reports
·Creating Auto Reports
·Creating Groups/Totals Reports
·Creating Single-Column Reports
·Modifying Reports
·Changing Borders
·Previewing Multiple Pages
·Changing Margins and Printing
Using Timesavers
·Using Database Wizards
·The Office Assistant
·Using AutoFormat
·Creating Shortcuts
INTRODUCTION TO MICROSOFT POWERPOINT
Microsoft's PowerPoint is a powerful presentation program. It provides all necessary tools for creating an online presentation. These tools can be used to manipulate both text and graphics.
