Microsoft Office Specialist (MOS) :: Vision Institute of IT Mardan

Instructors

Mr. Mustafa, Miss.Madeeha

Timing

Morning, Afternoon

Duration

2 Months

Fee

PKR 7,000

Contact

+92-331-5875434

Brief introduction

Microsoft Office Specialist (MOS) course helps student in academic institutions and business and government organizations in many ways. After completing this course student will able to apply for MOS exam, organized by Microsoft Company. Microsoft Office Specialist (MOS) certification gives you the tools to build a brighter future.

1. MS Word Outlines

Getting Started with Word

Getting to know Word 2010
The Ribbon

To minimize and maximize the Ribbon
To customize the Ribbon

Backstage view
The Quick Access toolbar

To add commands to the Quick Access toolbar

The Ruler
Creating and opening documents
Compatibility mode

Text Basics & Formatting

Working with text

To insert text
To delete text
To select text
To copy and paste text
To cut and paste text
To drag and drop text
To use format painter

Finding and replacing text

To find text
To replace text

Formatting text

To change the font size
To change the font
To change the font colour
To highlight text
To clear formatting
To apply text effects
To use subscript, superscript, strikethrough

To use the bold, italic, and underline commands
To use more options in underline
To change text case
To change text alignment
Typing Method

Saving Document & Modifying Page Layout

How to save documents
To use the Save As command
Auto Recover document
Other file formats
To change page orientation
To change page size
To format page margins
The Page Setup dialog box

Checking Spelling and Grammar

Using the spelling and grammar check
Ignoring "errors"
Automatic spelling and grammar checking
To use the spelling check feature
To use the grammar check feature
To change the automatic spelling and grammar check settings

Using Indents & Printing

Indenting text
To indent using the Tab key
To create or adjust a first-line indent or hanging indent
To use the Indent commands
The tab selector
Types of tab stops include
To view the Print pane
Quick Print

Line, Paragraph Spacing & Lists

Line spacing
Paragraph spacing
Using bulleted and numbered lists
Bullet options
Multilevel lists

Breaks, Columns & Hyperlinks

To insert and delete break
Inserting columns
Adding column breaks
To insert a hyperlink
To make an email address a hyperlink
To remove a hyperlink
To add watermark (text, image)
To apply page color
To apply page borders

Working with Shapes

Using shapes
To insert, rotate and resize a shape
To change the order of shape
To change to a different shape
To change the shape style
To change the shape fill color
To change the shape outline
To change shadow effects
Using 3D effects

Text Boxes and WordArt

To insert, Move, Resize a text box
To change the text box shape, Style, Outline & Shadow
Applying 3D effects
To use bevel
Creating WordArt

Inserting Clip Art and Pictures

To locate & insert clip art
To insert a picture from a file
To wrap text around an image
To use a predefined text wrapping setting
To crop an image
To crop an image to a shape
To add a border to a picture
To make image corrections
To adjust the color in an image
To apply an artistic effect
To apply a picture style
To compress a picture
To remove the background from an image

Styles and Themes

To select a style
To apply a style set
Create table of contents
To modify a style
To create a new style
To change the theme
Customizing a theme
To change theme fonts
To change theme effects
To save your theme
To insert endnote and footnote

Working with Headers and Footers

To insert a header or footer
To insert the date or time into a header or footer
To remove content controls
Other header and footer options
Adding page numbers

Reviewing Documents

Track Changes Introduction
To turn on Track Changes
To add & delete a comment
To accept or reject changes
To hide tracked changes
To show revisions in balloons
To compare two documents
To use the Document Inspector

Working with Tables

Inserting and modifying tables
To convert existing text to a table
To add a row or column
To delete a row or column
To apply a table style
To change table style options
To add borders to a table
Modifying a table using the Layout tab

SmartArt Graphics

To insert a SmartArt illustration
To add text to a SmartArt graphic
To add a shape to a graphic
To move shapes using the Promote and Demote commands
To change the SmartArt style
To change color scheme

Using a Template & Mail Merge

To insert a template
To insert text into a template
To change prefilled information
To use Mail Merge
To insert recipient data

Microsoft Word Completion Test

2. MS Excel

Getting Started with Excel

Introduction
The Excel interface
The Ribbon

To customize the Ribbon
To minimize and maximize the Ribbon

The Quick Access toolbar

To add commands to the Quick Access toolbar

Backstage view
Creating and opening workbooks
Compatibility mode

To convert a workbook

The cell

To select a cell

Cell content

To insert content
To delete content within cells
To copy and paste cell content
To cut and paste cell content
To access more paste options

To drag and drop cells
To use the fill handle to fill cells
To delete cells

Modifying Columns, Rows, and Formatting Cells

To modify column width
To set column width with a specific measurement
To modify row height
To set row height with a specific measurement
To insert rows
To insert columns
To delete rows
To delete columns
Wrapping text and merging cells

To wrap text
To merge cells using the Merge & Center command
To access more merge options

To change the font style
To change the font size
To use the bold, italic, and underline commands
To add a border
To change font color
To add a fill color
To change horizontal text alignment
To change vertical text alignment
Formatting numbers and dates

Worksheet Basics & Printing

Introduction to worksheets
To rename worksheets
To insert new worksheets
To delete worksheets
To copy a worksheet
To move a worksheet
To color code worksheet tabs
Grouping and ungrouping worksheets

To group worksheets
To ungroup all worksheets

Freezing worksheet panes

To freeze rows
To freeze columns
To unfreeze panes

Printing

To view the Print pane
To print active sheets
To print the entire workbook
To print a selection or set the print area

To change page orientation
To fit a worksheet on one page
To modify margins while in Print Preview
To use print titles
To insert a break

Saving workbooks and Formulas

To use the Save As command
To use the Save command
To use AutoRecover
To save as an Excel 97-2003 workbook
To save as a PDF
Creating simple formulas
To create a formula using cell references
To create a formula using the point-and-click method
To edit a formula
Creating complex formulas
The order of operations
To create a complex formula using the order of operations
Working with cell references

Relative references
Absolute references

To create and copy a formula using an absolute reference

Working with functions

What is Function?

The parts of a function
Working with arguments

To create a basic function in Excel
Using AutoSum to select common functions
The Function Library

To insert a function
Using AutoSum
Financial Functions
Logical Functions
Working with Text Functions
Date & Time Functions
Lookup & Reference
Math & Trig

Sorting & Outlining Data

Basic sorting

To sort in alphabetical order
To sort in numerical order
To sort by date or time

Custom sorting

To sort in the order of your choosing
To sort by cell color, font color, or cell icon

Sorting multiple levels

To add a level
To change the sorting priority

To outline data using Subtotal
Showing and hiding data

To show or hide a group
To view groups by level

Removing groups and subtotalling

To ungroup data
To ungroup data and remove subtotalling

To create and control your own group

Filtering Data & Formatting Tables

To filter data
To add another filter
To clear a filter
Advanced filtering

To filter using search
Using advanced text filters
Using advanced date filters
Using advanced number filters

To format information as a table
Modifying tables

To add rows or columns
To change the table style
To change table style options

Reviewing and Sharing Workbooks

Tracking changes

To turn on Track Changes
To turn off Track Changes

Adding and deleting comments

To add a comment
To edit a comment
To delete a comment

Accepting and rejecting changes
Adjusting how changes are viewed

To list changes on a separate worksheet
To show or hide comments

Finalizing and protecting your workbook

To check spelling
Ignoring spelling "errors"
To use the Document Inspector

Protecting your workbook

Using templates, Charts & Sparklines

To create a new workbook using a template
Charts

Types of charts
Identifying the parts of a chart
To create a chart

Chart tools

To change chart type
To switch row and column data
To change chart layout
To change chart style
To move the chart to a different worksheet

Creating sparklines

Types of sparklines
Why use sparklines?
To create sparklines

Changing the appearance of your sparklines

To show points on the sparkline
To change the style
To change the sparkline type

Changing the display range

To change the display range

Using Conditional Formatting & PivotTables

Conditional formatting

To create a conditional formatting rule

Conditional formatting presets

To use preset conditional formatting
To remove conditional formatting rules

Using a PivotTable

Using a PivotTable to answer questions
To create a PivotTable
To add fields to the PivotTable

Pivoting data

To change row labels
To add column labels

Using report filters

To add a report filter

Slicers

To add a slicer
Using the slicer

Using a PivotChart

To create a PivotChart

Using Macros & Protect Formulas

Record & Run Macros
Protect formula cells

Excel Ending Test

3. MS PowerPoint Outlines

Getting Started with PowerPoint

Getting to know PowerPoint 2010
The Ribbon

To minimize and maximize the Ribbon
To customize the Ribbon

Backstage view
The Quick Access toolbar

To add commands to the Quick Access toolbar

Creating and opening presentation
Compatibility mode

Slide Basics

About slides
About slide layouts
Customizing slide layouts

To change the layout of an existing slide
To delete a placeholder
To add a text box
To use a blank slide

Working with slides

To insert a new slide
To copy and paste a slide
To duplicate a slide

Managing slides and presentations

About slide views

To view an outline of your presentation
To organize slides into sections

Text Basics

To insert text
To delete text
To select text
To copy and paste text
To cut and paste text
To drag and drop text
Find and Replace
Working with text

To add a text box
To move a placeholder or text box
To resize a placeholder or text box

Formatting text

To bold, italic, underline, change font style, size, color

Modifying text

To insert a bulleted list
To change horizontal text alignment
To change vertical text alignment
To change text direction

Applying a Theme

Theme elements

Theme Colors (available from every Color menu)
Theme Fonts (available from the Font menu)
Shape Styles (available in the Format tab when you click a shape)

Why use theme elements?
Themes and slide layouts
Applying themes

Inserting Images

To insert an image from a file
To locate clip art
To insert clip art
Inserting screenshots

To insert screenshots of a window
To insert a screen clipping from a window

Resizing and moving images

To resize an image
To move an image

Transitions

Applying transitions

About transitions
To apply a transition
To preview a transition

Modifying transitions

To modify the duration
To add sound
To remove a transition

Advancing slides

Checking Spelling & Presenting Slide Show

To run a spell check
Ignoring spelling "errors"
Automatic spell check
Modifying proofing options
Presenting a slide show

To start a slide show
To advance and reverse slides
To stop or end a slide show

Presentation tools and features

To access the pen or highlighter
To erase ink markings
To jump to a nonadjacent slide
To access the desktop

Slide show setup options

Saving and Printing

To use the Save As command
To use the Save command
AutoRecover
To save as a PowerPoint 97-2003 presentation
To save as a different file type
Printing

To view the Print pane
Quick Print

Modifying Lists, Indents and Line Spacing

To modify the bullet style
To modify a numbered list
To change the starting number
To modify the size and color
To use a picture as a bullet
To use a symbol as a bullet
Indentation and line spacing

To indent using the Tab key
To use the Indent commands

Fine-tuning indents

To show the ruler

Customizing bullet spacing
Line spacing

WordArt and Shapes

- To apply a WordArt style to text
- To add or modify text effects
Working with shapes and text boxes

To insert, Resize a shape

Formatting shapes and text boxes

To change to a different shape
To change the shape style
To change the shape fill color
To change the shape outline
To change shadow effects

3D effects
To use 3-D Rotation
To use bevel

Modifying Themes

To change theme colors
To create new theme colors
To change theme fonts
To create new theme fonts
To change theme effects
To save a theme
To apply a background style

Formatting Pictures

Basic image formatting

To crop an image
To crop an image to a shape
To add a border to a picture

Image adjustments

To make image corrections
To adjust the color in an image

Artistic effects and styles

To apply an artistic effect
To apply a picture style

Compressing pictures
Removing the background from an image

Arranging Objects

Aligning objects

To align two or more objects
To align objects to the slide
To distribute objects evenly

Ordering and rotating objects

To change the ordering by one level
To bring an object to the front or back
To rotate an object

Grouping objects

To group objects
To ungroup objects

Animating Text and Objects

The four types of animations
To apply an animation to an object
Effect options
Working with animations

To add multiple animations to an object
To copy animations with the Animation Painter
To reorder the animations
To preview animations

The Animation pane

To open the Animation pane
To reorder effects from the Animation pane
To preview effects from the Animation pane
To change an effect's start option

The Effect Options dialog box

To open the Effect Options dialog box
To change the effect timing

Inserting Videos

To insert a video from a file on your computer
Embedding a video from a website
Working with the video

To preview the video
To resize the video

Editing and formatting videos

To trim the video
To add a fade in and fade out
To add a bookmark
To remove a bookmark
Video options

Formatting the appearance of a video

To create a poster frame
To apply a video style

Inserting Audio

To insert audio from a file on your computer
To insert clip art audio
Recording your own audio
Working with audio

To trim the audio
To add a fade in and fade out
To add a bookmark
To remove a bookmark
Audio options

Formatting the audio icon

SmartArt Illustrations

To insert a SmartArt graphic
To add text to a SmartArt graphic
To convert existing text to SmartArt
Changing the organization of a SmartArt graphic

To add a shape to a graphic
To move shapes to a higher or lower level
To rearrange shapes on the same level

Modifying the SmartArt graphic's appearance

To change the SmartArt layout
To change the SmartArt style
To change the color scheme

Hyperlinks and Action Buttons

About hyperlinks
To insert a hyperlink
To insert a hyperlink to an email address
To open and test a hyperlink
To remove a hyperlink
To insert a hyperlink to another slide
To insert a hyperlink to another file
Inserting action buttons

To insert an action button on one slide
To insert an action button on all slides
To test an action button
To edit an action button
To change the appearance of an action button

Working with Tables

To insert a blank table
To move a table
Modifying tables

To resize a table
To add a column or row
To delete a row or column

Modifying the table style

To apply a table style
To change table styles options
To add borders to a table

Modifying a table using the layout tab

Working with Charts

Types of charts
Identifying the parts of a chart
Inserting charts
To enter chart data
Copying and pasting existing Excel data
Importing a chart from Excel
Modifying charts with chart tools

To change the chart type
To switch row and column data
To change the chart layout
To change the chart style

Reviewing Presentations

Reviewing presentations
Commenting on presentations

To add a comment
To edit a comment
To respond to a comment
To delete a comment

Comparing presentations

To compare two presentations

Using the reviewing features safely

To use the Document Inspector

Advanced Presentation Options

Rehearse and record slide shows
Rehearsing slide show timings
To rehearse timings
Recording your slide show

To record a slide show
To remove narration or timings from a recorded slide show

Sharing presentation options
Presenting your slide show as a video
To broadcast a slide show
Customizing your slide show
Creating hand outs of a presentation

Slide Master View

What is Slide Master View?
Using Slide Master view
To make changes to all slides
Customizing slide layouts
Customizing text formatting
Creating new slide layouts

To insert a new slide layout
To rename a custom layout
To use a custom layout

Using custom layouts in other presentations

Creating Photo Albums in PowerPoint

To create a photo album

Adding Callouts to Images

To add callouts to an image

4 free alternatives to Microsoft Office

Google Docs
Office Online
OpenOffice and LibreOffice

4. MS Outlook Outlines

Getting Started with Outlook

Getting to know the Outlook interface
The Ribbon

To minimize and maximize the Ribbon

Backstage view
Setting up Outlook 2010
Using Outlook with a personal email account

Sending and Receiving Email

Mail View
Sending emails
To create an email signature
To set an automatic reply
To use Spell Check
To print email messages

Organizing and Managing Email

Using folders

To create a new folder

Using categories

To customize categories
To apply a category
To filter messages by categories

Applying rules
Keeping your messages organized

Using flags
To delete messages permanently

Managing Contacts

Contacts view
Adding contacts

To add a new contact manually
To import contacts
To send an email to contact groups
To assign tasks
To print contacts

Managing Your Calendars

Contacts view
To create an appointment
Using multiple calendars

To create a new calendar

Doing more with calendars

To apply categories to appointments
To create multiple-day appointments
To create appointment reminders
To print calendars

Collaborating with Calendars

Sharing calendars
To open a shared calendar
Scheduling meetings

To send a meeting request
To accept a meeting request

Using Schedule view

Setting availability

5. MS Access Outlines

Introduction to Databases

What is a database?
Why use a database?
The Access objects

Tables
Forms
Queries
Reports
Putting it all together

Getting to know Access 2010
Working with your Access environment

The Ribbon
The Quick Access toolbar
Backstage view
The Navigation pane

To minimize and Maximize the Navigation pane
To sort objects in the Navigation pane

Databases with navigation forms

Managing Databases and Objects

Opening and closing databases
Working with objects

To open an object
Saving objects
To close an object
To rename an object

Working with Tables

Understanding tables
To open an existing table
Navigating within tables
To add and save record
Editing records
To delete a record

Sorting and Filtering Records

Sorting records
Filtering records
Creating a filter from a selection
Creating a filter from a search term

Modifying table appearance

Resizing fields and rows
Hiding fields
Alternating row color
Modifying gridlines
To customize which gridlines appear
Additional formatting options

Working with Forms

Why use forms?
To open an existing form
To add a new record
To find an existing record to view or edit
To save the current record
To delete the current record
Using form features

Designing a Query

What are queries?
How are queries used?
One-table queries
Designing a multi-table query
Planning our query
Joining tables in queries
Creating a multi-table query
Modifying queries
Sorting queries
Hiding fields within queries
More types of queries

Creating reports

Deleting fields
Printing and saving reports in Print Preview
To export a report

Advanced Report Options

The Report Wizard
Formatting reports
Enhancing report appearance

Modifying Tables

Adding and rearranging fields
Advanced field options

To change the data type for existing fields
Field character limits
Validation rules

More table options

Creating Forms & Formatting Forms

To create a form
About sub forms
Adding additional fields to a form
Adding design controls
Customizing form settings with the Property Sheet
Modifying form settings
Formatting Forms

Command buttons

Modifying form layout

To resize form components
To move form components

Modifying the colors and fonts of form components

Designing Your Own Database

Creating a database from a template
More resources on database design

Students Overview
Enrolled: 128	Certified: 114
Certified are those students who get greater than 60% Marks

Who Are We

Admission Information

Web Technologies

Microsoft Technologies

Networking

Programming Languages

Graphics Designing

Diploma Courses

Computerized Accounting

Mobile Technologies

English Language

Students Information

Microsoft Office Specialist (MOS)

Instructors

Timing

Duration

Fee

Contact

Brief introduction

Getting Started with Word

Text Basics & Formatting

Saving Document & Modifying Page Layout

Checking Spelling and Grammar

Using Indents & Printing

Line, Paragraph Spacing & Lists

Breaks, Columns & Hyperlinks

Working with Shapes

Text Boxes and WordArt

Inserting Clip Art and Pictures

Styles and Themes

Working with Headers and Footers

Reviewing Documents

Working with Tables

SmartArt Graphics

Using a Template & Mail Merge

Microsoft Word Completion Test

Getting Started with Excel

Modifying Columns, Rows, and Formatting Cells

Worksheet Basics & Printing

Saving workbooks and Formulas

Working with functions

Sorting & Outlining Data

Filtering Data & Formatting Tables

Reviewing and Sharing Workbooks

Using templates, Charts & Sparklines

Using Conditional Formatting & PivotTables

Using Macros & Protect Formulas

Getting Started with PowerPoint

Slide Basics

Text Basics

Applying a Theme

Inserting Images

Transitions

Checking Spelling & Presenting Slide Show

Saving and Printing

Modifying Lists, Indents and Line Spacing

WordArt and Shapes

Modifying Themes

Formatting Pictures

Arranging Objects

Animating Text and Objects

Inserting Videos

Inserting Audio

SmartArt Illustrations

Hyperlinks and Action Buttons

Working with Tables

Working with Charts

Reviewing Presentations

Advanced Presentation Options

Slide Master View

Creating Photo Albums in PowerPoint

Getting Started with Outlook

Sending and Receiving Email

Organizing and Managing Email

Managing Contacts

Managing Your Calendars

Collaborating with Calendars

Introduction to Databases

Managing Databases and Objects

Modifying Tables