Description
Course Name: Certificate in M.S. Office
Course Id: MSO/Q0001.
Education Qualification: 8th Class.
Duration: 90 Hrs.
How You will Get Diploma Certificate:
Step 1- Select your Course for Certification.
Step 2- Click on Enroll Now.
Step 3- Proceed to Enroll Now.
Step 4- Fill Your Billing Details and Proceed to Pay.
Step 5- You Will be Redirected to Payment Gateway, Pay Course and Exam Fee by Following Options.
Card(Debit/Credit), Wallet, Paytm, Net banking, UPI and Google pay.
Step 6- After Payment You will receive Study Material on your email id.
Step 7- After Completion of Course Study give Online Examination.
Step 8- After Online Examination you will get Diploma Certificate soft copy(Scan Copy) and Hard Copy(Original With Seal and Sign).
Step 9- After Certification you will receive Prospect Job Opportunities as per your Interest Area.
Online Examination Detail:
Duration- 60 minutes.
No. of Questions- 30. (Multiple Choice Questions).
Maximum Marks- 100, Passing Marks- 40%.
There is no negative marking in this module.
Benefits of Certification:
- Government Authorized Assessment Agency Certification.
- Certificate Valid for Lifetime.
- Lifetime Verification of Certificate.
- Free Job Assistance as per your Interest Area.
Syllabus
Certifications in MS Office
MS WINDOWS, COMPUTER BASICS
MS WORD
MS EXCEL
MS POWER-POINT
INTERNET & E-MAIL
MICROSOFT OUTLOOK
MS WINDOWS, COMPUTER BASICS
Creating Folder, Paint Directories, input units, Output unit Central Processing Units What is hard ware, what is Software Windows short cut keys Using slide master Inserting layout option Creating custom layout Inserting place holders Formatting place holders 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 Apply a Slide Transition, Modifying a Reorder Animation Using Transitions Modify a Default or Custom Animation Default Animation, Custom Animation Merge and split option Alignment option Table Styles Working with Tables, Table Formatting Check Spelling As You Type Setting Auto Correct Options Save as video Save as JPEG files Save as PowerPoint Show file Print Preview, Print.
MS WORD
Creating, editing, saving and printing text documents, Font and paragraph formatting, Simple character formatting Ø Inserting tables, smart art, page breaks, Using lists and styles, Working with images Ø Using Spelling and Grammar check Ø Understanding document properties, Mail Merge, New, Open, Close, Save, Save As Formatting Text: Font Size, Font Style Font Colour, Use the Bold, Italic, and Underline Change the Text Case Line spacing, Paragraph spacing Shading text and paragraph Working with Tabs and Indents 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 Changing Word Options Changing the Proofing Tools Managing Templates Restricting Document Access Using Protected View Working with Templates Managing Templates Understanding building blocks.
MS EXCEL
Introduction to Excel interface Understanding rows and columns, Naming Cells Working with excel workbook and sheets New, Open, Close, Save, Save As Formatting Text: Font Size, Font Style Font collar, Use the Bold, Italic, and Underline Wrap text, Merge and Centre Currency, Accounting and other formats Modifying Columns, Rows & Cells 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. Sort and filtering data Using number filter, Text filter Custom filtering Removing filters from columns Conditional formatting 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 Adding Endnote Adding a Footnote Adding internal references Table of contents and references Creating Styles, Creating a list style Using Build- in Styles, Modifying Styles.
MS POWER POINT
New, Open, Close, Save, Save As Typing the text, Alignment of text Formatting Text: Font Size, Font Style Font collar, Use the Bold, Italic, and Underline Cut, Copy, Paste, Select All, Clear text Find & Replace Working with Tabs and Indents Understand PivotTables, Create a PivotTable Framework Using the PivotTable and PivotChart Create Pivot Chart from pivot Table Inserting slicer Creating Calculated fields Inserting new slide Changing layout of slides Duplicating slides Copying and pasting slide Applying themes to the slide layout Changing theme collar Slide background Formatting slide background Using slide views Multilevel numbering and Bulleting Creating List Page bordering Page background Aligning text text directions Columns option 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.
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 Using slide master Inserting layout option Creating custom layout Inserting place holders Formatting place holders Transition, Advancing to the Next Slide Apply a Slide Transition, Modifying a Reorder Animation Using Transitions Modify a Default or Custom Animation Default Animation, Custom Animation Merge and split option Alignment option Table Styles Working with Tables, Table Formatting Inserting Movie From a Computer File Inserting Audio file Audio Video playback and format options Video options, Adjust options Reshaping and bordering Video Understand PivotTables, Create a PivotTable Framework Using the PivotTable and PivotChart Create Pivot Chart from pivot Table.
Microsoft Outlook
Customize the appearance of the program window Configure program options Set defaults for outgoing messages Create and assign automatic signatures Configure options for multiple accounts Practice tasks Automatically reply to messages Automatically process messages Create and manage Quick Steps Practice tasks View and save messages and attachments Print Outlook items Practice tasks Search for items Use Search Folders Practice tasks Objective review Create messages Create and send messages Configure message options Respond to messages Delegate access Practice tasks Format tax Apply themes and styles Apply styles Create hyperlinks Insert images Manage schedules Insert memorized content Insert signatures Practice tasks Categorize messages Flag messages for follow-up Manage conversations Organize messages in folders Manage junk email Practice tasks Objective review Configure calendar settings Work with multiple calendars Share calendar information Practice tasks Create appointments and events.
