Upto 85% SCHOLARSHIP for all Computer Courses
Diploma in MS-Office - D.M.O Duration : 3 Months
INTRODUCTION TO COMPUTER, COMPUTER BASICS, MS WINDOWS
♦ Computer Basics ♦ Introduction to Computers ♦ Typing Text ♦ Creating Folder ♦ Paint ♦ Directories ♦ Input Units ♦ Output Unit ♦ Central Processing Units ♦ What is Hardware ♦ What is Software ♦ Windows short cut keys
ms-office
MS-WORD
MODULE 1: TEXT BASICS
♦ Typing the text, Alignment of text♦ Editing Text: Cut, Copy, Paste, Select All, Clear♦ Find & Replace
MODULE 2: 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
MODULE 3: 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 & FOOTER
♦ Inserting custom Header and Footer ♦ Inserting objects in the header and footer ♦ Add section break to a document.
MODULE 5: WORKING WITH BULLETING AND NUMBERING 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 CONTENTS
♦ 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
MODULE 8: MERGING DOCUMENTATION
♦ 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
MODULE 9: SHARING AND MAINTAING DOCUMENTS
♦ Changing Word Options ♦ Changing the Proofing Tools ♦ Managing Templates
♦ Restricting Document Access ♦ Using Protected View ♦ Working with Templates
♦ Managing Templates ♦ Understanding building blocks
MODULE 10: PROOFING THE DOCUMENTS
♦ Check Spelling As You Type. ♦ Mark Grammar Errors As You Type
♦ Setting AutoCorrect Options
MODULE 11: PRINTING
♦ Page Setup, Setting margins, Print Preview, Print ♦ Print Preview, Print
MS-EXCEL
MODULE 12: INTRODUCTION TO EXCEL
♦ Introduction to Excel interface ♦ Understanding rows and columns, Naming Cells ♦ Working with excel workbook and sheets
MODULE 13 : FORMATING EXCEL WORKBOOK:
♦ 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.
MODULE 14: PERFORM CALCULATION 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.
MODULE 15: SORT AND FILTER DATA WITH EXCEL:
♦ Sort and filtering data ♦ Using number filter, Text filter ♦ Custom filtering
♦ Removing filters from columns ♦ Conditional formatting
MODULE 16: CREARE 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
MODULE 17: 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:PROTECTION AND SHARING THE WORKBOOK
♦ 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 MACTRO 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 POWERPOINTENVIRONMENT
♦ New, Open, Close, Save, Save As ♦ Typing the text, Alignment of text ♦ Formatting Text:WI 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 SMARTARTS 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
INTERNET APPLICATIONS
INTERNET & EMAIL
♦ 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
