Microsoft Office Course is a

Course No 02

Topics:

Microsoft Word

Microsoft Excel

Microsoft PowerPoint

Emailing Information

Printer Setting

Documents Requirement: 

4 Passport Size Pictures

CINC or B Form Copy

All Educational Certificates Copy

Additional information: 

Course Duration: 4 Month

Monthly Fee: 3,000

Class Time: 2 Hours

MS Office Course

(Course Outline)

Lecture # 00

MS Office Information and History

What is MS Office, Software History and its Used. MS Word, MS Excel, MS PowerPoint.

Click here to Find →Class Notes | →Video Lecture

MS Word

 (Course Outline)

Lecture # 01

MS Word Software Information

What are MS Word, History of MS Word, and Benefits of MS Word?

Click here to Find →Class Notes | →Video Lecture

Lecture # 02

MS Word Downloading and Installation

How to Free Download and Install MS Word Software on Computer

Click here to Find →Class Notes | →Video Lecture

Lecture # 03

MS Word Basic Overview or Screen Elements

Title Bar, Tab Bar, Property Bar, States Bar, Scroll Bar, Roller, Page

Click here to Find →Class Notes | →Video Lecture

Lecture # 04

MS Word – Home Tab → Font Group

Font Face, Font Size, Grow Font, Shrink Font, Clear Formatting, Bold, Italic etc…

Click here to Find →Class Notes | →Video Lecture

Lecture # 05

MS Word – Home Tab → Paragraph Group

Bullets, Numbering, Multilevel List, Decrease & Increase Indent, Text Direction etc…

Click here to Find →Class Notes | →Video Lecture

Lecture # 06

MS Word – Home Tab → Clipboard Group

Format Painter, Cut, Copy, Past and Past Special.

Click here to Find →Class Notes | →Video Lecture

Lecture # 07

MS Word – Home Tab → Style Group

Normal, No Spacing, Heading 1,2,3, Title, Chang Styles, Colors and Fonts etc…

Click here to Find →Class Notes | →Video Lecture

Lecture # 08

MS Word – Home Tab → Editing Group

Find, Replace, Replace Font, Select and Go to Options.

Click here to Find →Class Notes | →Video Lecture

Lecture # 09

MS Word – Insert Tab → Pages Group

How to Insert and Format Cover Page, Blank Page and Page Break

Click here to Find →Class Notes | →Video Lecture

Lecture # 10

MS Word – Insert Tab → Tables Group

How to Insert Table, Draw Table, Convert Text to Table, Excel Spreadsheet, Quick Tables.

Click here to Find →Class Notes | →Video Lecture

Lecture # 11

MS Word – Insert Tab → Illustrations Group - Shapes

How to Insert and format shapes in Microsoft Word.

Click here to Find →Class Notes | →Video Lecture

Lecture # 12

MS Word – Insert Tab → Illustrations Group – Picture

How to Insert and format Picture in Microsoft Word.

Click here to Find →Class Notes | →Video Lecture

Lecture # 13

MS Word – Insert Tab → Illustrations Group - Clip Art

How to add and format Clip Art in Microsoft Word.

Click here to Find →Class Notes | →Video Lecture

Lecture # 14

MS Word – Insert Tab → Illustrations Group - Smart Art

How to Insert and format Smart Art in Microsoft Word.

Click here to Find →Class Notes | →Video Lecture

Lecture # 15

MS Word – Insert Tab → Illustrations Group - Chart

How to create and format Chart in Microsoft Word.

Click here to Find →Class Notes | →Video Lecture

Lecture # 16

MS Word – Insert Tab → Links Group

Insert Hyperlink, Bookmark, Cross-reference

Click here to Find →Class Notes | →Video Lecture

Lecture # 17

MS Word – Insert Tab → Header & Footer Group

Insert Header, Footer and Page Numbers

Click here to Find →Class Notes | →Video Lecture

Lecture # 18

MS Word – Insert Tab → Text Group - WordArt

Insert Word Art in MS] Word

Click here to Find →Class Notes | →Video Lecture

Lecture # 19

MS Word – Insert Tab → Text Group

Text Box, Quick Parts, Drop Cap, Signature Line, Object, Date and Time

Click here to Find →Class Notes | →Video Lecture

Lecture # 20

MS Word – Insert Tab → Symbols Group

How to Insert Equation and Symbol

Click here to Find →Class Notes | →Video Lecture

Lecture # 21

MS Word – Page Layout Tab → Themes Group

Uses of Theme Colors, Themes Fonts and Themes Effects

Click here to Find →Class Notes | →Video Lecture

Lecture # 22

MS Word – Page Layout Tab → Page Setup Group

Uses of Margins, Orientation, Page Size, Columns, Breaks, Line Numbers, Hyphenation

Click here to Find →Class Notes | →Video Lecture

Lecture # 23

MS Word – Page Layout Tab → Watermark

Insert Watermark in MS Word

Click here to Find →Class Notes | →Video Lecture

Lecture # 24

MS Word – Page Layout Tab → Page Color

How to Change Page Colors in MS Word

Click here to Find →Class Notes | →Video Lecture

Lecture # 25

MS Word – Page Layout Tab → Page Borders

Insert Page Borders in MS Word

Click here to Find →Class Notes | →Video Lecture

Lecture # 26

MS Word – Page Layout Tab → Paragraph Group

Uses of Indent and Spacing Options in MS Word

Click here to Find →Class Notes | →Video Lecture

Lecture # 27

MS Word – Page Layout Tab → Arrange Group

Position, Bring to Front, Sent to Back, Text Wrapping, Align, Group or Ungroup, Rotate

Click here to Find →Class Notes | →Video Lecture

Lecture # 28

MS Word – View Tab → Document View Group

Print Layout, Full Screen Reading, Web Layout, Outline, Draft

Click here to Find →Class Notes | →Video Lecture

Lecture # 29

MS Word – View Tab → Show/Hide Group

Ruler, Gridlines, Massage Bar, Documents Map, Thumbnails

Click here to Find →Class Notes | →Video Lecture

Lecture # 30

MS Word – View Tab → Zoom Group

Zoom, 100%, One Page, Two Pages, Page Width,

Click here to Find →Class Notes | →Video Lecture

Lecture # 31

MS Word – Office Button

Save and Print setting, Page range, Number of copies and Printer Properties

Click here to Find →Class Notes | →Video Lecture

Lecture # 32

Keyboard Shortcut Keys

Ctrl, Alt, Tab, Window button A to Z all important Shortcut Keys

Click here to Find →Class Notes | →Video Lecture

MS Excel

Lecture # 01

MS Excel Software Information

What are MS Excel, History of MS Excel, and Benefits of MS Excel?

Click here to Find →Class Notes | →Video Lecture

Lecture # 02

MS Excel Downloading and Installation

How to Free Download and Install MS Excel Software on Computer

Click here to Find →Class Notes | →Video Lecture

Lecture # 03

MS Excel Basic Overview or Screen Elements

Title Bar, Tab Bar, Property Bar, Formula Bar, Cell Name Box, Worksheet, States Bar, Scroll

Click here to Find →Class Notes | →Video Lecture

Lecture # 04

MS Excel Worksheet Overview

Worksheet, Rows, Columns and Cells information

Click here to Find →Class Notes | →Video Lecture

Lecture # 05

MS Excel Arithmetic Series

How or Draw Arithmetic Series in Excel

Click here to Find →Class Notes | →Video Lecture

Lecture # 06

MS Excel – Home Tab → Font Group

Font Face, Font Size, Grow Font, Shrink Font, Clear Formatting, Bold, Italic etc…

Click here to Find →Class Notes | →Video Lecture

Lecture # 07

MS Excel – Home Tab → Alignment Group

Bullets, Numbering, Multilevel List, Decrease & Increase Indent, Text Direction etc…

Click here to Find →Class Notes | →Video Lecture

Lecture # 08

MS Excel – Home Tab → Clipboard Group

Format Painter, Cut, Copy, Past and Past Special.

Click here to Find →Class Notes | →Video Lecture

Lecture # 09

MS Excel – Home Tab → Number Group

Number Format, Accounting Mumber Format, Percent Style, Comma Style etc…

Click here to Find →Class Notes | →Video Lecture

Lecture # 10

MS Excel – Home Tab → Styles Group

Conditional Formatting, Format as Table, Cell Styles.

Click here to Find →Class Notes | →Video Lecture

Lecture # 11

MS Excel – Home Tab → Cells Group

Insert Cells, Delete Cells, Format, Cell Size, Visibility, Organize Sheets, Protection.

Click here to Find →Class Notes | →Video Lecture

Lecture # 12

MS Excel – Home Tab → Editing Group

Sum, Fill, Clear, Sort & Filter, Find & Select etc...

Click here to Find →Class Notes | →Video Lecture

Lecture # 13

MS Excel – Important Formulas

Basic Calcolation, Income & Expences Sheet, Very Important Formulas.

Click here to Find →Class Notes | →Video Lecture

Lecture # 14

MS Excel – List Making

Any Type of List Making like Rate List, Employee List etc…

Click here to Find →Class Notes | →Video Lecture

Lecture # 15

MS Excel – Data Entry and Data Base Sheet

Student Record Data Entry and Data Base Sheet Making.

Click here to Find →Class Notes | →Video Lecture

Lecture # 16

MS Excel – Reference Sheet

Uses of Variable Reference and Fix Reference, Table of 2 basic Calculation.

Click here to Find →Class Notes | →Video Lecture

Lecture # 17

MS Excel – Insert Tab → Tables Group

Uses of Table and Pivot Table, Pivot Chart.

Click here to Find →Class Notes | →Video Lecture

Lecture # 18

MS Excel – Insert Tab → Illustrations Group – Picture & Clip Art

How to Insert Picture and Clip Art in Microsoft Excel.

Click here to Find →Class Notes | →Video Lecture

Lecture # 19

MS Excel – Insert Tab → Illustrations Group – Shapes & Smart Art

How to Insert Shapes and Smart Art in Microsoft Excel.

Click here to Find →Class Notes | →Video Lecture

Lecture # 20

MS Excel – Insert Tab → Illustrations Group - Chart

How to create and format Chart in MS Excel.

Click here to Find →Class Notes | →Video Lecture

Lecture # 21

MS Excel – Insert Tab → Links Group

Insert Hyperlink, Bookmark, Cross-reference

Click here to Find →Class Notes | →Video Lecture

Lecture # 22

MS Excel – Insert Tab → Text Group

Text Box, Word Art, Signature Line, Symbols.

Click here to Find →Class Notes | →Video Lecture

Lecture # 23

MS Excel – Page Layout Tab → Themes Group

Uses of Theme Colors, Themes Fonts and Themes Effects

Click here to Find →Class Notes | →Video Lecture

Lecture # 24

MS Excel – Page Layout Tab → Page Setup Group

Uses of Margins, Orientation, Page Size, Columns, Breaks, Line Numbers, Hyphenation

Click here to Find →Class Notes | →Video Lecture

Lecture # 25

MS Excel – Page Layout Tab → Scale to Fit

Width, Hight and Scale Sheet Options in Excel

Click here to Find →Class Notes | →Video Lecture

Lecture # 26

MS Excel – Page Layout Tab → Sheet Options

Sheet Right to Left, View Grid lines, Print Grid-lines, View Heading, Print Headings.

Click here to Find →Class Notes | →Video Lecture

Lecture # 27

MS Excel – Page Layout Tab → Arrange Group

Position, Bring to Front, Sent to Back, Text Wrapping, Align, Group or Ungroup, Rotate

Click here to Find →Class Notes | →Video Lecture

Lecture # 28

MS Excel – Account Work Part 1

Bill Book, Invoice, Result Sheet, Report Card etc…

Click here to Find →Class Notes | →Video Lecture

Lecture # 29

MS Excel – Account Work Part 2

Daily Balance Sheet and Monthly Balance Sheet Making.

Click here to Find →Class Notes | →Video Lecture

Lecture # 30

MS Excel – Result / Marks Sheet Making Part 1

Result Sheet Parentage and Result Making.

Click here to Find →Class Notes | →Video Lecture

Lecture # 31

MS Excel – Result / Marks Sheet Making Part 2

If Can-diction Grade Sheet Making.

Click here to Find →Class Notes | →Video Lecture

Lecture # 32

MS Excel – Office Button

Save and Print setting, Page range, Number of copies and Printer Properties

Click here to Find →Class Notes | →Video Lecture

MS PowerPoint

Lecture # 01

MS PowerPoint Software Information

What are MS Word, History of MS Word, and Benefits of MS PowerPoint?

Click here to Find →Class Notes | →Video Lecture

Lecture # 02

MS PowerPoint Downloading and Installation

How to Free Download and Install MS PowerPoint Software on Computer

Click here to Find →Class Notes | →Video Lecture

Lecture # 03

MS PowerPoint Basic Overview or Screen Elements

Title Bar, Tab Bar, Property Bar, States Bar, Scroll Bar, Roller, Page

Click here to Find →Class Notes | →Video Lecture

Lecture # 04

MS PowerPoint – Home Tab → Slides Group

New Slids, Layout, Reset and Delete Slides in MS PowerPoint.

Click here to Find →Class Notes | →Video Lecture

Lecture # 05

MS PowerPoint – Home Tab → Font Group

Font Face, Font Size, Grow Font, Shrink Font, Clear Formatting, Bold, Italic etc…

Click here to Find →Class Notes | →Video Lecture

Lecture # 06

MS PowerPoint – Home Tab → Paragraph Group

Bullets, Numbering, Multilevel List, Decrease & Increase Indent, Text Direction etc…

Click here to Find →Class Notes | →Video Lecture

Lecture # 07

MS PowerPoint – Home Tab → Clipboard Group

Format Painter, Cut, Copy, Past and Past Special.

Click here to Find →Class Notes | →Video Lecture

Lecture # 08

MS PowerPoint – Home Tab → Drawing Group

Uses of Shapes, Arrange, Quick Styles, Shape Fill, Shape Outline and Shape Effects.

Click here to Find →Class Notes | →Video Lecture

Lecture # 09

MS PowerPoint – Home Tab → Editing Group

Find, Replace, Replace Font, Select and Go to Options.

Click here to Find →Class Notes | →Video Lecture

Lecture # 10

MS PowerPoint – Insert Tab → Tables Group

How to Insert Table, Draw Table, Convert Text to Table, Excel Spreadsheet, Quick Tables.

Click here to Find →Class Notes | →Video Lecture

Lecture # 11

MS PowerPoint – Insert Tab → Illustrations Group

Picture, Clip Art, Shapes, Smart Art, Chart..

Click here to Find →Class Notes | →Video Lecture

Lecture # 12

MS PowerPoint – Insert Tab → Photo Album

How to Insert Photo Album in PowerPoint

Click here to Find →Class Notes | →Video Lecture

Lecture # 13

MS PowerPoint – Insert Tab → Links Group

Insert Hyperlink and Action

Click here to Find →Class Notes | →Video Lecture

Lecture # 14

MS PowerPoint – Insert Tab → Text Group

Text Box, Hadar & Footer, Word Art, Date and Time, Side Number, Symbol, Object.

Click here to Find →Class Notes | →Video Lecture

Lecture # 15

MS PowerPoint – Insert Tab → Media Group

How to Insert Movie and Sound

Click here to Find →Class Notes | →Video Lecture

Lecture # 16

MS PowerPoint – Design Tab → Page Setup Group

Uses of Page Setup and Side Orientation

Click here to Find →Class Notes | →Video Lecture

Lecture # 17

MS PowerPoint – Design Tab → Themes Group

Uses of Advance Themes in MS PowerPoint.

Click here to Find →Class Notes | →Video Lecture

Lecture # 18

MS PowerPoint – Design Tab → Background Group

Background Styles and Hide Background Graphics.

Click here to Find →Class Notes | →Video Lecture

Lecture # 19

MS PowerPoint – Animations Tab → 1

How to Custom Animations and Preview

Click here to Find →Class Notes | →Video Lecture

Lecture # 20

MS PowerPoint – Animations Tab → 2

Tranition to this Slide and Advance Slide Automatically After

Click here to Find →Class Notes | →Video Lecture

Lecture # 21

MS PowerPoint – Slide Show Tab

Start Slide Show Form Beginning, Form Current Slide, Custom Slide Show

Click here to Find →Class Notes | →Video Lecture

Lecture # 22

MS PowerPoint – View Tab → 1

Uses of all Presentation Views.

Click here to Find →Class Notes | →Video Lecture

Lecture # 23

MS PowerPoint – View Tab → 2

Show/Hide, Zoom and Color/Grayscale.

Click here to Find →Class Notes | →Video Lecture

Lecture # 24

MS PowerPoint – Office Button

Save and Print setting, Page range, Number of copies and Printer Properties

Click here to Find →Class Notes | →Video Lecture

Lecture # 25

Keyboard Shortcut Keys

Ctrl, Alt, Tab, Window button A to Z all important Shortcut Keys

Click here to Find →Class Notes | →Video Lecture