Certificate Course in Office Automation & Internet

Certificate

by Compufield Computer Institute

Mumbai

View Contact

Starting from:

INR 6,200
Per Course
(Taxes As Applicable)

Request Info

Medium of instruction:

English

Request Info

Topic Covered

Microsoft Word
Microsoft Excel
Microsoft Powerpoint
Windows
Internet

MICROSOFT WORD

Microsoft Word for Windows is a full-feature Word processor designed to help you work more efficiently. Microsoft Word shows you how to create effective documents using its features. You will learn how to edit, format, print documents, insert and manage tables and graphics into documents.

Salient Features

Easy and Fast Tool to create a one page Letter, a hundred page Report, etc.
You could add Graphics to your Letters and Reports to make it more attractive.
Automatic Spelling check as well as Grammar check facility.
Freeform Table Draw.
Document Mapping.
You can also link to Excel numbers and Charts.
You can link your Word documents to World Wide Web or Intranet sites.

Applications

With Word you can create and type Letters, Reports, Memos, Proposals, Newsletters, Brochures, Graphical Presentation, Web pages, etc.

Syllabus

PHASE - I

How to open a new document in Word 2007
How to find a word
How to replace a word
How to save a file
How to close a file
How to open an existing file
How to use cut and paste
How to use copy and paste
How to select the whole text
Overview home tab
How to clear formats
How to go to different views
Overview Insert tab
How to exit from word

PHASE 2

Work with insert option
Cover page
Blank page
Page break
Insert Table
Insert excel sheet
Insert Pictures from folders
Insert clip-art
Insert shapes
Insert smart art
Insert chart
Use of hyperlink
Bookmark
Header and Footer
Text box
Word art
Drop cap
Insert object and symbols

PHASE 3

Working in page layout
Set up themes
Color themes
Text themes
Page set up
Use of columns
Watermarks
Page Color
Page border

PHASE 4

Work in references tab
Insert foot note
Insert end note
Insert next note
Bibliography
Insert caption

PHASE 5

Work in review tab
Spelling and grammer
Translate
Thesaurus
Comments
Protect document

PHASE 6

Work in view window
Split
Arrange all
Macros
Zoom
Show\hide items
Document views

MICROSOFT EXCEL

Microsoft Excel for Windows is a powerful electronics spreadsheet application that can be used for managing, analyzing and presenting data in graphical manner.

Salient Features

Excel has three components that perform in three different manners:

1. The Spreadsheet.

2. The Data sheet.

3. The Chart.

Create formulas on worksheets. It's easy and fast.
Enhanced formatting and layout features help you get the printed report or online form with the look you want.
You can quickly find the information you need and create automatic subtotals of your data.
Increased capacity, high-end formatting options, and a mapping feature give you powerful ways to analyze your data visually.
Explore the power of the Internet from your familiar Microsoft Excel spreadsheet.
When you want to analyze data from outside Microsoft Excel, there's no need to retype. In a few keystrokes, you can bring the data right onto your worksheet.

Application

Excel is used for preparing Company profiles in the form of Charts and Graphs.
Excel stores the accounting spreadsheets in Electronic form.

Syllabus

Module 1: Getting Started

Understanding the Excel screen
Navigating in a spreadsheet
Understanding worksheets, columns, rows and cells
Saving, opening, and closing workbooks

Module 2: Formatting a Spreadsheet

Changing column widths and row heights
Changing alignment of cells
Undoing and redoing actions
Formatting numbers
Clearing formats
Applying borders to cells
Merging cells

Module 3: Formulas and Functions

Entering formulas
Copying data and formulas
Using AutoSum
Understanding functions
Using simple aggregate functions (Sum, Count, Average, Min, Max)
Copying formulas
Applying conditions in a formula (The IF function)
Working with ranges

Module 4: Editing Features

Using cut , copy, and paste operations
Using paste special with values
Selection techniques
Navigation techniques

Module 5: Working with Large Worksheets

Freezing and unfreezing panes
Splitting windows
Inserting page breaks for printing

Module 6: Working with Charts

Creating charts using Chart Wizard
Creating different types of charts
Including titles and values in charts
Formatting of charts

Module 7: Previewing and Printing

Previewing worksheets
Page setup
Printing of worksheets in multiple pages
Repeating rows and columns for multiple pages
Printing multiple worksheets

Module 8: Simple Database Operations

Sorting tables
Filtering data with auto filter
Referring data from other worksheets

MICROSOFT POWERPOINT

PowerPoint is the most famous and powerful presentation Program. Impressive colorful slide shows can be designed.

Salient Features

Quick and Easy, High impact visual to accompany a talk.
Fact-filled presentation with plenty of Graphs and Charts.
Sophisticated Electronic presentation.
You can assemble existing text and graphics from other Microsoft Office Application.
You can time your Presentations.
You can save as Web Animation.

Application

With Microsoft Powerpoint you can create Company Presentations and Profiles

Syllabus

PHASE - I

Introduction

To Start the Program
What is powerpoint
Parts of powerpoint window
Overview of Menu bar

File Menu

New autocontent wizard
New blank presentation
To Save the File
Save As
Open
Close Exit

Edit Menu

Cut & Paste
Copy & Paste

PHASE - II

Edit Menu

Find
Replace

View Menu

Normal
Slide Sorter
Notes Page
Slide Show
Slide Master
Title Master
Black and White
Toolbars
Ruler
Header and Footer

Insert Menu

New Slide

Slide Number
Date & Time
Comment
Slide Number
Date & Time
Comment
Picture
Text Box
Table
Object
Picture
Text Box
Table
Object

PHASE - III

Format Menu

Font
Bullet and Numbering
Slide Layout
Slide Color Scheme
Background
Design Templates
Colors and lines

Tool Menu

Auto Correct
Macro
Customize
Option

Slide Show Menu

View Show
Set Up Show
Action Buttons
Preset Animation
Custom Animation
Slide Transition
Custom Shows .

WINDOWS

The operating system is a master Program that takes care of proper functioning of the computer. Window operating system is a (GUI) Graphical User Interface in which user can click the 'icons' to perform a specific task. Windows has increased the speed and efficiency of your Computer related tasks.

Salient Features

With Windows, you can work with several Programs at once. You can switch between Programs with a couple of keystrokes or a click of a mouse, reducing the time required to move from one application to another.
You can give any name to a file; you are not limited to eight characters with a three-character extension as in DOS. You can even use spaces.
Windows now supports the use of drives greater than 2 GB (gigabytes) in capacity. The maximum supported drive size is 2 TB (terabytes).
Windows prints your documents "in the background," so you can get back to work quickly after you send your document to the printer.

Application

Nowadays all the software are Windows based.

INTERNET

Internet is Worldwide network with over 200 million Worldwide users. Internet gives you absolute access to information on any subject under the sky.

Why Use The Internet?

Business : Marketing, selling and publishing product literature world wide.

Professional: Provide and get technical support, bug fixes and product information, communication or collaborate on project in almost zero time.

Students: Information regarding Universities, their rating & procedures for admission all over the world, access to over 40 million library files your own computer.

Communication Power Of The Internet: WWW, E-mail, Usenet, Telnet, FTP, IRC

Request Info

Classroom - Regular
When	Duration	Where	Remarks	Price
Not Specified	30 Sessions	All Venues	Not Specified	INR 6,200 Per Course (Taxes As Applicable)

Request Info

Mumbai, Warden Road (Head Office):- Chinoy Mansion, First Floor, Block #2 Opp. St.Stephen's Church Warden Road, Mumbai - 400036, Maharashtra, India

View Phone

Mumbai, Bandra West (Branch):- 1st Floor. O'Priya Building, Near Mehboob Studio Peter Dias Road Bandra West, Mumbai - 400050, Maharashtra, India

View Phone

Mumbai, Andheri West (Branch):- Wembley Society, Shop No 3 Shastri Nagar, Lane no2, Lokhandwala Andheri West, Mumbai - 400053, Maharashtra, India

View Phone

Request Info

Compufield Computer Institute

COMPUFIELD® Computer Institute was started in 1985 by Mr. M. E. Khairaz to impart training in Internet, Digital Art, Multimedia, Software and Network Engineering. Today we offer many different courses covering the latest and most widely used software worldwide.

Creative courses, Designing and Digital Video courses
Multimedia and Internet courses
Programming courses
Network Engineering, MCSE, CCNA, CCNP
Office Automation & Financial Application
Kids courses

Our Training

Our courses are upgraded frequently to meet the ever changing standards of the Industry.
Our Students design galleries substantiate our claim of providing our students a creative and informative learning environment directed at all round growth.
Our faculty are highly experienced in the respective software and help the students in the best possible manner.
We have state of the art Hardware and Software facilities.
We offer Crash courses of 6-10 hours per day to students who wish to complete their learning in a short period.
Professional Job Assignments and Tutorials have been devised to help students practically apply what they learn.
After successful completion of the course, job assistance is provided by us.;

We offer a unique style of learning -

One computer : One student : One Instructor
Maximum Instructor to Student Ratio 1:4
Sessions : Each session will be of 1 hour
Fees is for one course and it includes instructions, practicals,practice, project, preparation for exam (if any)
Overseas / local Students take 5 to 10 hours per day to complete their courses earlier.
The timing can be fixed based on our mutual convenience,
between 9.00 a.m. to 7.00 p.m.
Course duration in working days = Total sessions divided by number of sessions (hours) per day.
No extra charges/refund for more/less time taken to complete the course.
Lodging, boarding and travelling not included in the fees.
Management has full right to change courses, contents, tuition fees without prior notice.

Visit Provider Site