Course Description:

MS-Office suite of office application software allows organizations to efficiently and effectively undertake daily office operations to support and connect disparate business systems.  It is an essential certification for beginners, novices and professionals to portray their skill competence in using MS-Office software for day to day office work. Currently there is a huge demand for MS-Office professionals. This certification will concentrate on Computer Basics, MS-DOS, MS-Windows and MS-Office that are used extensively in office environment. A Vskills Certified Computer Fundamentals (MS Office) professional would have employment opportunities in all offices using MS Office for their day to day work.

Why should one take this certification?
This certification is intended for professionals and technical novices seeking career in corporates and wanting to excel in chosen areas. It is also well suited for those who are already working and would like to take certification for further career progression. Indian companies are moving up the value curve, and today’s scenario demands more specialization and that is where a certification of this type will add value.

Who will benefit from taking this certification?
This certification benefits students who wish to make a career in office administration, facility management and front office management. This certification is also beneficial for professionals who are already working and want to acquire knowledge in this segment of industry. Students will be ready for jobs from day 1 since this is a high demand skill in companies. Professionals already employed and looking for job switch will also benefit from the certification.

How to Access:

Curriculum

Computer Appreciation

• Classification of Computers as per processing speed
• Applications of Computer
• Illustrating Computer Terms like hardware, software, etc.
• Computer Operations of Input, Process and Output
• Various units of a computer system
• Representation of information in bytes, KB, MB, etc.
• Input devices used with computer
• Output devices used by computer
• Storage Devices of computer
• Types of Software in computer
• Disk Organization in computer and terms about it
• Explaining Operating System's roles, and types

MS-DOS

• What is DISK OPERATING SYSTEM?
• Organization of MS-DOS
• File naming rules to be followed in MS-DOS
• Types of DOS commands
• Various DOS Commands
• Using COPYCON to build a file
• Introduction to simple batch files

WINDOWS-XP

• Windows Basics and its elements
• The User Interface components in MS-Windows
• Accessories in MS-Windows under Entertainment, Games, System Tools, Calculator and Date-Time.
• Using Notepad, its menus and their usage
• Paintbrush, WordPad and windows explorer menus and their usage.
• Common operations like browsing, copy-cut-paste files and shutting down Windows

MS - WORD 2003

• MS- Word Window Elements
• File Management for new, open, close, save, save as and exit MS-Word
• Moving and selection by mouse and keyboard
• Different files in MS-Word as windows and their arrangement and views
• Printing document and using the page setup options
• Using the Interface of toolbars and menu bar
• Editing Text for cut-copy-paste, undo and redo, delete and find-replace
• Different views of a document, setting the header and footer and show or hide optional window component like toolbars, ruler, etc.
• Break and its type explaining usage of each
• Steps for inserting pictures, clip art, word art, and auto shapes in the document
• Insertion options for miscellaneous items like symbol, date-time and page number
• Formatting font, paragraph of a document
• Setting the format of bullet and numbering, border and shading, columns and tabs
• Using MS-Word Tools like Spell and Grammar Check, Thesaurus, AutoCorrect, AutoText, AutoComplete and Macros
• Document protection
• Utilizing Mail Merge facility in MS-word for letter, envelopes and labels
• Using Wizards of MS-Word like The Letter Wizard
• Document Templates use in MS-Word
• Using Reference in a Document
• Tables creation, sorting and formatting in MS-Word
• Creating Charts and Web Pages in MS-Word

MS - EXCEL 2003

• Basics of Worksheet and MS-Excel window
• Split Windows and Freeze Panes in MS-Excel
• File Management for create, open, save, save as, close of workbook in MS-Excel
• Setting for Printing, Page setup, break and Header and Footer in MS-Excel
• Working with workbooks for moving and selecting data and worksheet
• Menus and toolbars of MS-Excel
• Using of Cut-copy-paste, redo-undo, drag-drop, paste special operations of data
• Steps to insert, delete row, column and cell
• Using find-replace and go to facility of MS-Excel
• Following rules for sheet names
• Steps to Rename, add, delete worksheets and how to move worksheet in multiple open workbook
• Using AutoFill facility by mouse and fill option
• Explaining the different Views of worksheet and show or hide of optional components like toolbar, formula bar, etc.
• Explaining formula, different data types, operators and MS-Excel in-built functions
• Using auto sum and function wizard facility of MS-Excel
• Working with cell Ranges and names
• Relative and Absolute Reference in MS-Excel
• Formatting Cells by Auto formatting, by toolbar, Format Dialog Box and Conditional Formatting in MS-Excel
• Hide and Display Sheets, Rows and Columns
• Setting Styles in MS-Excel
• Various tools of MS-Excel like Spell Check, Workbook Sharing, What If Analysis, Scenario Manager, Goal Seek, Macros and Workbook protection
• Explaining Data and list Operations of sort, find by criteria, filter and advanced filter
• Using pivot table
• Working with graphs and charts
• Creating and using multiple worksheets and linking workbooks
• Linking and embedding in MS-Excel

MS - POWER POINT 2003

• Accessing PowerPoint
• Basics of starting, opening and closing a presentation
• Different Views of presentation in MS-Powerpoint
• Slide Management for creating, deleting and changing order of slides
• Editing the slide master
• Formatting Color Scheme and Background
• Adding Clip Art and Drawing Objects
• Setting the Customs Animation and transitions in Slide Show
• Setting up a Slide Show and Slide Timings Creating common language set

Miscellaneous Topics

• Explaining Virus and it’s types, spread and preventive measures to follow.
• Data Processing concepts explaining input, process and output cycle
• Illustrating Networking concepts about networks(LAN,WAN), topology(Bus, Ring, Star), internet and intranet

Here is a sample for the course completion certificate which you will receive after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address