LEARN MICROSOFT OFFICE

Basic Computer Course in Lahore Computer Architecture
Basic Computer Course in Lahore Microsoft Windows
image Internet
image Microsoft Office
– Microsoft Word
– Microsoft Excel
– Microsoft PowerPoint
image Urdu Typing (Inpage)

Major Topics.

MS-Word

Software Introduction
File Save, Save As, Open, Close, Protect Document, Recent, New Print,
Home Tab
Cut, Copy, Paste, Paste Special, Format Painter, Font Commands, Paragraph Commands, Bullets, Numbers, Line Spacing, Style, Editing, Find, Replace, Go To
Insert Tab
Cover Page, Blank Page, Break Page, Table, Illustrations, Hyperlink, Bookmark, Header Footer, Page Numbers, Text Box, Word Art,, Drop Cap, Date & Time, Object, Equations, Symbols
Page Layout
Margins, Orientation, Size, Columns, Breaks, Line Numbers, Hyphenation, Watermark, Page Color, Page Borders, Paragraph, Wrap Text, Position
References Tab
Table of Contents, Footnotes
Mailings / Mail Merge
Review Tab
Proofing Tab, Language, Comments, Track Changes, Changes, Restrict Editing
View Tab
Document Views, Show, Zoom, New Window, Arrange All, Split, View Side by Side, Switch Windows, Macros
MS-Excel

Software Introduction
File Save, Save As, Open, Close, Protect Document, Recent, New Print,
Home Tab
Chipboard, Cut, Copy, Paste, Paste Special, Format Painter, Font Options, Alignment, Numbers, Styles, Cells, Editing, Find, Replace, Go To, Auto Sum, Fill Series, Clear
Insert Tab
Pivot Table, Table, Illustrations, Charts, Sparklines, Links Text, Symbols
Page Layout Tab
Margins, Orientation, Size, Print Area, Breaks, Background, Print Titles, Scale to Fit, Sheet Options, Arrange
Formulas & Assignment Sheets
Result Sheet, Salary Sheet, Profit & Loss Sheet, Commission Sheet, Integer Sheet, Different Functions, SUM, PLUS, MINUS, MULTIPLY, DIVISION, AVERAGE, IF CONDITION, VLOOKUP, SHEETS LINKS, COMBINATION DIFFEENT SHEETS AND FILES, Name Manager and Define Name, Formula Auditing
Data
Get External Data, Connections, Sort & Filter, Text to Columns, Remove Duplicates, Data Validation, Consolidate, What-if Analysis, Goal Seek, Subtotal
Review Tab
Proofing, Language Translate, Comments, Protect Sheet, Protect Workbook, Allow Users to Edit Ranges, Track Changes
View
Workbook Views, Show, Zoom, New Window, Arrange All, Freeze Panes, Split, Hide Unhide, Vide Side by Side, Switch Windows, Macros
MS-PowerPoint

Software Introduction
File Save, Save As, Open, Close, Protect Document, Recent, New Print,
Home Tab ( Basic Commands of Word, Layout, Slides, Font, Paragraph, Drawings, Editing )
Insert Tab ( Tables, Images, Illustrations, Links, Text, Symbols, Media )
Design Tab (Page Setup, Themes, Background )
Transitions, Preview, Timings
Animation Tab (Animations, Advanced Animation, Timing )
Slide Show Tab ( Start Slide Show, Set Up )
Review Tab ( Proofing, Language, Comments, Compare )
View Tab (Presentation Views, Master Views, Show, Direction, Zoom, Window, Macros
File Format Creations pptx, pps, pdf, jpg etc.
In-Page (Urdu / Arabic ) Text Typing Tool

Software Introduction
Tools Use
Keyboard usage for typing of Urdu and Arabic
Document Settings
All menu standard commands

Formating, Documentation, Mail Merge, Restrictions, Track Changes, Macros, Page Setup, Sizing, Watermark, Borders, Table and Properties, Chart, Spread Sheet, Hyperlink, Bookmark, Equation, Symbols, Find, Replace, Go To, Header & Footer, Paste Special, Format Painter, Clipboard, Alignment, Wrapping, Merging, Conditional Formatting, Filling, Order, Pivot Table, Smart Art, Screenshot, Sparklines, Page Layout, Print Titles, What if Analysis, Goal Seek, Name Manager, Formula Auditing, Text to Column, Remove Duplicates, Data Validation, Consolidate, Subtotal, Protect Sheet, Protect Workbook, Allow Users to Edit Ranges, Comments, Freeze Pans, Sum, Average, Count, Min, Max, If Condition, lookup, Result Sheet, Salary Sheet, Profit and Loss Account, Over Time Sheet, Different Calculations etc.