Monday, May 16, 2011

MS Office Course (both Online and home tution)

OFFICE AUTOMATION (course Outline)

COURSE 1 : Microsoft Windows XP

*      Learning the Basics
*      Exploring Window Features
*      Background and Appearance Settings
*      Arranging icons, resizing and moving windows
*      Using Programs
*      Working with Views and Toolbars
*      Organizing Files and Folders
*      Creating, Moving, Copying and Deleting Files and Folders
*      Working with Multimedia Files
*      Working with Multiple Windows
*      Using the Search Companion
*      Using the Desktop and Recycle Bin
*      Working with Storage Devices
*      Formatting and Managing Disks
*      Using the Control Panel
*      Working with Printers and Hardware
*      Customizing the Display
*      Using the Start Menu
*      Using the Taskbar
*      Using Accessories
*      Using the Help and Support Center
*      Getting Started with Internet Explorer
*      Using Accounts and Shutting Down

COURSE 2 : Microsoft WORD

*      Introduction to MS Word
Basic editing techniques
Formatting concepts
Review of system defaults
Using speller and Thesaurus

*      Graphs, Lines and Equation
Figure Options
Box Options
Horizontal and Vertical Lines
Customizing Vertical/Horizontal Lines
*      Creating a Basic Document
Get Help Using Word
Enter Text
Save a New Document
Preview a Document
Print a Document

*      Headers and Footers
Understanding headers and footers
Creating/editing headers and footers

*      Editing a Document
Insert Text
Select Text
Create an AutoText Entry
Move and Copy Text
Delete Blocks of Text
Undo Changes
Find and Replace Text

*      Footnotes and Endnotes
Understanding footnotes and endnotes
Footnotes / endnotes options menu
Creating/editing footnotes and endnotes

*      Formatting Text
Apply Font Styles and Effects
Change Text Color
Highlight Text
Copy Formats
Clear Formatting
Find and Replace Text Formatting

*      Macros
Understanding macros
Location of Macros files
Creating/using macros
Macro Chaining and nesting
Editing/replacing a macro

*      Advanced Character Formatting
Selecting/Using fonts
Spacing punctuation
Print size and attributes

*      Styles
Understanding styles
Outline Styles
Using Styles to customize a document

*      Advanced Line Formatting
Line Height
Line Numbering
Flush Right Command
Aligning Columns

*      Merge Documents
Understanding merge
Creating Primary Document
Creating a Secondary Document
Merging Primary/Secondary Document
Understanding Merge Codes
Specialized Merge Codes

*      Special Features
Line Draw
Document Comparison
Inserting the date

*      Table of Contents/Authority, Indexes and Lists
Creating a table of contents
Creating a list
Creating an index
Regenerating a table, list or index
Table of Authorities

*      Advanced Page Formatting
Creating Forms
Deleting/editing forms
Setting up/selecting page size and type

*      Sort and Select

*      Paragraph Numbering/Outline
Paragraph Numbering
Outline Numbering
Bullets Settings

*      Other Features
Shell Features
Text in/out Feature
Save as Feature
Using Passwords

*      Tables
Using MS Word Table Feature
Setting up columns
Adjusting cell size
Format within columns
Changing line type and deleting table lines
Using gray shading within cells
Creating tables and graphs in Excel

*      Text Columns
Creating newspaper-style columns
Creating parallel columns
Editing columnar text
Cursor movement with columns

COURSE 3 : Microsoft EXCEL

*      Getting Started with Excel an Overview of Excel
Excel Navigate in
Select Data
Enter Data
Save a Workbook

*      Developing a Workbook Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Copy a Workbook

*      Modifying a Worksheet Move and Copy Data Between Cells
Fill cells with series of data
Edit cell data
Insert and Delete cells, columns and rows
Find, replace, and go to cell data
Spell Check a Worksheet

*      Printing Workbook Contents Set a Print Title
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Insert and Remove Page Breaks
Print a Range

*      Performing Calculations Create Basic Formulas
Calculate with functions
Copy Formulas and Functions
Create an Absolute Reference

*      Customizing Layout Split a Worksheet
Arrange Worksheets
Freeze and Unfreeze Rows and Columns
Hide and Unhide Worksheets

*      Formatting a Worksheet Change Font Size and Type
Add borders and color to cells
Change column width and row height
Merge Cells
Apply Number Formats
Create a Custom Number Format
Align Cell Contents
Find and Replace Formats
Apply and AutoFormat
Apply Styles


*      Introduction to PowerPoint Environmnet
Orientation to Views
Navigate Through a Presentation
Edit Slide Text
Save the Presentation
Run a Slide Show

*      Modifying Objects Resize Objects
Copy and Duplicate Objects
Move Objects
Changing Object Orientation
Format Objects
Group and Ungroup Objects
Change the Order of Objects

*      Creating a New Presentation
Change Background Color
Add Slides to a Presentation
Enter Text
Create a Presentation from a MS Word Outline

*      Adding Images to a Presentation Add Clip Art
Add a Picture from a File
Draw Lines and Shapes
Insert WordArt

*      Formatting Text Slides “Apply Character Formats”
Align Text
Change Line Spacing
Change Indents

*      Applying Animation

*      Adding Tables to a Presentation
Format Tables
Insert a Table From MS Word

*      Preparing to Deliver a Presentation Spell Check
Arrange Slides
Add Transitions
Create Speaker Notes
Send a Presentation to MS Word
Print the Presentation
Package a Presentation for CD

*      Charting Data Create a Column Chart
Edit Chart Data
Change Chart Type
Insert a Chart from MS Excel

COURSE 5 : Orientation to Hardware, Software & Networking

*      Hardware and its Types
Storage Devices
Input Devices
Output Devices
Processing Devices and Units

*      Networking
Introduction to Networking
Types of Networks
File Sharing
Printer Sharing
Workgroups and Domains
IP Addressing and Subletting

*      Software and its Types
System Software
Application Software


*      Making Internet Accounts *      Browsing
*      Working on Searching       *      Searching Techniques
*      Uploading                            *      Downloading
*      Managing Web Based E-Mail Accounts
*      Chatting                                *      Security Techniques

 MS Office Course (both Online and home tution available )
Call: 0092-321-2248975

Course Total Duration:           2-3 Months
Tution Days:                          3 Alternate Days (e.g. Monday, Wednesday, Friday)
Fee for Online:                       3000/- Pak Rupees   ,  35 $
Fee for On Spot:                    4000/- Pak Rupees   ,  50 $  (only in Karachi city Pakistan)
For Additional Software:           Extra Charges apply.
Requirement for Online:          Internet connection with Team viewer Installed for students
Language of Tution:                  Urdu, English

Email: (prefer call)

No comments: