Provide the knowledge in Ms word, Ms PowerPoint, Ms Excel and open the world of Internet and Emailing

COURSE CONTENT

MS Windows, Computer basics

♦ Computer Basic, Creating Folder

♦ Paint,Directories,

♦ input units, Output unit

♦ Central Processing Units

♦ Hardware & Software

♦ Windows short cut keys

MS WORD

Module1:Text Basics ♦ Typing the text, Alignment of text ♦ Editing Text: Cut, Copy, Paste, Select All, Clear ♦ Find & Replace Module2: Text Formatting and Saving file ♦ New, Open, Close, Save, Save As ♦ Formatting Text: Font Size, Font Style ♦ Font Color, Use the Bold, Italic, and Underline ♦ Change the Text Case ♦ Line spacing, Paragraph spacing ♦ Shading text and paragraph ♦ working with Tabs and Intends Module3: Working with Objects ♦ Shapes, Clipart and Picture, Word Art, Smart Art ♦ Columns and Orderings - To Add Columns to a Document ♦ Change the Order of Objects ♦ Page Number, Date & Time ♦ Inserting Text boxes ♦ Inserting Word art ♦ Inserting symbols ♦ Inserting Chart Module 4: Header & Footers ♦ Inserting custom Header and Footer ♦ Inserting objects in the header and footer ♦ Add section break to a document Module 5: Working with bullets and numbered lists ♦ Multilevel numbering and Bulleting ♦ Creating List ♦ Customizing List style ♦ Page bordering ♦ Page background Module 6: Tables ♦ Working with Tables, Table Formatting ♦ Table Styles ♦ Alignment option ♦ Merge and split option Module 7: Styles and Content ♦ Using Build- in Styles, Modifying Styles ♦ Creating Styles, Creating a list style ♦ Table of contents and references ♦ Adding internal references ♦ Adding a Footnote ♦ Adding Endnote Module8:Merging Documents ♦ Typing new address list ♦ Importing address list from Excel file ♦ Write and insert field ♦ Merging with outlook contact ♦ Preview Result ♦ Merging to envelopes ♦ Merging to label ♦ Setting rules for merges ♦ Finish & Merge options Module9: Sharing and Maintaining Document ♦ Changing Word Options ♦ Changing the Proofing Tools ♦ Managing Templates ♦ Restricting Document Access ♦ Using Protected View ♦ Working with Templates ♦ Managing Templates ♦ Understanding building blocks Module10: Proofing the document ♦ Check Spelling As You Type. ♦ Mark Grammar Errors As You Type ♦ Setting AutoCorrect Options Module 11: Printing ♦ Page Setup, Setting margins ♦ Print Preview, Print

MS EXCEL

Module12:Introduction to Excel ♦ Introduction to Excel interface ♦ Understanding rows and columns, Naming Cells ♦ Working with excel workbook and sheets Module13: Formatting excel work book: ♦ New, Open, Close, Save, Save As ♦ Formatting Text: Font Size, Font Style ♦ Font Color, Use the Bold, Italic, and Underline ♦ Wrap text, Merge and Centre ♦ Currency, Accounting and other formats ♦ Modifying Columns, Rows, & Cells. Module14: Perform Calculations with Functions ♦ Creating Simple Formulas ♦ Setting up your own formula ♦ Date and Time Functions, Financial Functions ♦ Logical Functions, Lookup and Reference ♦ Functions Mathematical Functions ♦ Statistical Functions, Text Functions. Module15:Sort and Filter Data with Excel ♦ Sort and filtering data ♦ Using number filter, Text filter ♦ Custom filtering ♦ Removing filters from columns ♦ Conditional formatting Module16:Create Effective Charts to ♦ Present Data Visually ♦ Inserting Column, Pie chart etc. ♦ Create an effective chart with Chart Tool ♦ Design, Format, and Layout options ♦ Adding chart title ♦ Changing layouts ♦ Chart styles ♦ Editing chart data range ♦ Editing data series ♦ Changing chart Module17: Analyze Data Using PivotTables and Pivot Charts ♦ Understand PivotTables, Create a PivotTable . ♦ Framework Using the PivotTable and PivotChart ♦ Create Pivot Chart from pivot Table ♦ Inserting slicer ♦ Creating Calculated fields Module 18: Protecting and Sharing the work book ♦ Protecting a workbook with a password ♦ Allow user to edit ranges ♦ Track changes ♦ Working with Comments ♦ Insert Excel Objects and Charts in Word Document and Power point Presentation Module 19:Use Macros to Automate Tasks ♦ Creating and Recording Macros ♦ Assigning Macros to the work sheets ♦ Saving Macro enabled workbook. Module 20:proofing and Printing ♦ Page setup, Setting print area, Print titles ♦ Inserting custom Header and Footer ♦ Inserting objects in the header and footer ♦ Page Setup, Setting margins, Print Preview, Print ♦ Enable back ground error checking ♦ Setting AutoCorrect Options

MS POWERPOINT

Module 21:Setting Up PowerPoint Environment ♦ New, Open, Close, Save, Save As ♦ Typing the text, Alignment of text ♦ Formatting Text: Font Size, Font Style ♦ Font Color, Use the Bold, Italic, and Underline ♦ Cut, Copy, Paste, Select All, Clear text ♦ Find & Replace ♦ working with Tabs and Intends Module 22:Creating slides and applying themes ♦ Inserting new slide ♦ Changing layout of slides ♦ Duplicating slides ♦ Copying and pasting slide ♦ Applying themes to the slide layout ♦ Changing theme color ♦ Slide background ♦ Formatting slide background ♦ Using slide views Module 23:Working with bullets and numbering ♦ Multilevel numbering and Bulleting ♦ Creating List ♦ Page bordering ♦ Page background ♦ Aligning text ♦ Text directions ♦ Columns option Module 24:Working with Objects ♦ Shapes, Clipart and Picture, Word Art, Smart Art ♦ Change the Order of Objects ♦ Inserting slide header and footer ♦ Inserting Text boxes ♦ Inserting shapes, using quick styles ♦ Inserting Word art ♦ Inserting symbols ♦ Inserting Chart Module 25:Hyperlinks and Action Buttons ♦ Inserting Hyperlinks and Action Buttons ♦ Edit Hyperlinks and Action Button ♦ Word Art and Shapes Module 26:Working With Movies and Sounds ♦ Inserting Movie From a Computer File ♦ Inserting Audio file ♦ Audio Video playback and format options ♦ Video options, Adjust options ♦ Reshaping and bordering Video Module 27: Using SmartArt and Tables ♦ Working with Tables, Table Formatting ♦ Table Styles ♦ Alignment option ♦ Merge and split option ♦ Converting text to smart art Module 28: Animation and Slide Transition ♦ Default Animation, Custom Animation ♦ Modify a Default or Custom Animation ♦ Reorder Animation Using Transitions ♦ Apply a Slide Transition, Modifying a ♦ Transition, Advancing to the Next Slide Module 29: Using slide Master ♦ Using slide master ♦ Inserting layout option ♦ Creating custom layout ♦ Inserting place holders ♦ Formatting place holders Module 30: Slide show option ♦ Start slide show ♦ Start show from the current slide ♦ Rehearse timing ♦ Creating custom slide show Module 31: Proofing and Printing ♦ Check Spelling As You Type ♦ Setting AutoCorrect Options ♦ Save as video ♦ Save as JPEG files ♦ Save as PowerPoint Show file ♦ Print Preview, Print

MS ACCESS

Module 32: Get Acquainted with Access ♦ What is access ♦ Introduction to Database ♦ Relational Database management system ♦ Introduction to Database objects ♦ Components of Access User interface ♦ Ribbon, Navigation pane, Back stage view Module 33: Access startup screen ♦ Creating new blank Database ♦ Closing Database ♦ Creating Database from Template ♦ Opening an existing Database ♦ Backing up Database Module 34: Using Navigation Pane ♦ Viewing object, Copying object ♦ Renaming Object, Deleting object Module 35: Access Tables ♦ Planning Tables ♦ Planning fields ♦ Creating tables in Design view ♦ Modifying Tables in Design view ♦ Selecting a primary key ♦ Importing data from excel into new table ♦ Importing data as a linked table Module 36: ♦ Relationship types ♦ Creating relationship in database ♦ Creating look up filed ♦ Viewing related data Module 37: Creating Queries ♦ Creating Query in design view ♦ Creating Query with Query Wizard ♦ Modifying Queries ♦ Adjusting Query field ♦ Sorting Query field ♦ Hiding Query field ♦ Adding Query criteria ♦ Adding calculated field to Query ♦ Creating crosstab Query Module 38: Using Forms ♦ Form views ♦ Creating form with form Wizard ♦ Working with forms in design view ♦ Working with forms in Layout view ♦ Working with padding, Margins and Anchoring Module 39: Creating Reports ♦ Report sections ♦ Designing a report ♦ Report views, print view, and layout view ♦ Using the report tool ♦ Working with reports in layout view ♦ Working with reports in design view ♦ Creating blank report ♦ The field list pane ♦ Grouping and sorting report ♦ Previewing and printing reports

INTERNET & E-MAIL

♦ What is Internet?, Receiving Incoming Messages ♦ Sending Outgoing Messages, Email addressing ♦ Email attachments, Browsing, Search engines ♦ Text chatting, Job Searching ♦ Downloading video and Music ♦ Uploading Video or Music, Voice chatting, Webcam Chatting etc., ♦ Introduction to Blogging, Facebook