Office Management Computer Operator Basic Diploma Short Course in Sialkot - Sialkot

OFFICE MANAGEMENT
Course Outline

MS EXCEL
Files & Worksheets
Making New Excel File
Saving, Opening Protecting, Excel Files
Worksheet-Adding, Deleting, Copy
Linking & Hyperlinking Worksheets
Data Entry in Excel
Selecting Cell, Delete, Coloring
Columns & Rows Setting
Home Tab
Paste
Cut
Copy
Format Painter
Font, Size, Bold, Italic, Underlining
Coloring Text Backgrounds
Text Alignment
Text Directions
Text Wrapping
Cell Merging
Currency, Percentage, Comma & Decimal
Conditional Formatting
Format as Table
Insert, Delete, Format
AutoSum
Fill
Clear
Sorting
Find
Insert Tab
Pivot Table
Table
Picture
Shapes
Charts
Text Box
Header & Footer
Word Art
Page Layout
Themes
Colors
Fonts
Effects
Margins
Orientation
Size
Formulas & Practice
Count
Sum
Average
Minimum
Maximum
Lookup
If
Date and Time
Percentage

Word outline
New Word File, Saving, Save as
Home Tab
Paste
Cut
Copy
Format Painter
Fonts, Size, Bold Italic, Underlining
Strikethrough
Text Effects
Color Text and Background
Erase
Bullets and Numbering
Text Alignment
Paragraph and Line spacing
Theme, Color Border
Sorting
Readymade Formatting
Find
Replace
Insert Tab
Cover Page
Blank Page
Page Break
Table
Picture
Shapes
Charts
Header
Footer
Page Number
Text Box
Word Art
Symbol
Design Tab
Themes
Colors
Fonts
Effects
Watermark
Page Color
Page Borders
Page Layout
Margins
Orientation
Size
Columns
View Tab
Read Mode
Print Layout
Rule
Guidelines
One Page
Multiple Pages

Powerpoint
Course Content

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
Insert a Chart from Microsoft Excel
Preparing to Deliver Your Presentation
Review Your Presentation
Apply Transitions
Print Your Presentation
Deliver Your Presentation


Inpage outline

01- Introduction and basic information
02- Creating new page
03- Settings the page layout
04- Document preferences
05– Keyboard preferences
06- Difference between English and Urdu typing
07- User defined keyboard
08- Aligning and formatting Text
09- Creating new color for text and borders
10- Text box & title text box
11- Formatting the page
12- Creating and using style sheet
13- Printing the document