MS-Office

• Introduction about computer
• How to use keyboard & mouse
• Use of Desktop Wallpaper
• How to change Properes
• How to change Screen Saver
• How to Create Folder and File
• Copy and Paste – File and Folder
• Accessories (Notepad, MS Paint)

INTERNET CONCEPT

• How to Create Email Account
• How to Check a Mail
• How to Send a Mail
• How to A2ach file to a Mail
• How to Open Website
• Online Shopping
• Online From Registraon

INTERNET CONCEPT

• Introducon to M S – Word
• Office Bu2on, Font Clipboard
• Format Painter, Undo and Redo
• Font Face, Size, Styles and Color
• Back Ground Color, Change Case
• Sub & Super Script, Bullet List
• Text Alignments and Borders
• Line Spacing, Data Eding
• Tables Creang, and Table Tools
• Inserng Picture, Shapes & Charts
• Creang Hyperlink, Bookmarks
• Header & Footer, Page Numbers
• Watermark, Page Color & Borders
• Table of Contents, Footnotes
• Labels Design, Mail Merge, Macros
• Word Count, Document Views
• Protect Document, Window
• Zoom, Funcon & Shortcut Keys

MICROSOFT POWERPOINT

• Introducon to M S – PowerPoint
• Creang Designing Slides & Numbers
• Creang Photo Album & Layouts
• Page Setup, Slide Orientaon, Themes
• Custom Animaons, Transion Sound
• Sound Effects & Music, Create Image
• Custom & Start Slide Show, Sorter
• Rehearse Timings, Arrange All
• New Window, Protect Presentaon

MICROSOFT ACCESS

• Introducon to M S – Access
• Tables Creaon, Table in Design View
• Creang Data Base Forms

MICROSOFT EXCEL

• Introducon to M S – Excel
• Office Bu2on, Paste Special
• Paste Link, Values, Transpose
• Clipboard and Font Se<ng
• Cell Borders and Alignment
• Wrap Text, Merge & Center
• Cell Styles, Cell Size, Visibility
• Insert & Delete, Eding
• Organize Sheet, Charts
• Time and Date Funcons
• Financial Logical Funcons
• Text & Stascal Funcons
• Math and Trig Funcons
• Hyperlink, Header & Footer
• Page Margins, Orientaon,
• Print Area, Breaks & Size
• Page Background, Print Titles
• Scale to Fit, Sheet Opons
• Name Manager, Define Name
• Formula Auding, Sorng
• Group & Ungroup, Comment
• Protect Sheet, Book Views
• Funcon & Shortcut Keys

ADVANCED EXCEL

• V Lookup and H Lookup Formulas
• V Lookup & H Lookup Sheet to Sheet
• V Lookup & H Lookup Book to Book
• Match and Index Formulas
• Match and Index Sheet to Sheet
• Match and Index Book to Book
• Auto Filter and Advanced Filter
• Sum if and Count if Formulas
• Count A & Count Blank Formulas
• Subtotal Funcons and Formulas
• Creaon of Pivot Table, Charts
• Refresh Data & Database Formulas
• Cell Condional Forma<ng
• Import Data from Access, Notepad
• Export Tables from Excel to Word
• Creaon Customs List for Text
• Text to Columns, Remove Duplicates
• Data Validaon, Consolidate Tables
• Scenario Manager, Data Table
• Goal Seek, Macros, Freeze Panes
• Data and Number Series FillingDuraon
• 30 DaysCreang Object, Creang Payrolls
• Duraon