 |
 |
|
|
The powerful software in Microsoft Office 2013 remains in Microsoft Office 2016, including features and shortcuts for the things you do most often, like creating professional-looking presentations, working on spreadsheets or word processing. And because Office 2016 allows you to open, save, modify or collaborate on documents in the cloud, you can maximise efficiencies and do great work anywhere, anytime. Microsoft Office is much more powerful and comes with better support than free software, like Open Office or Google Docs.
Microsoft office is a group of software developed by Microsoft for documentation purposes. It has a wide application in various fields including business, education, accounting etc. It was introduced in 1988 and gained a prodigious momentum due to its ease of use. Today Microsoft Office suite has more than one billion users around the world. Microsoft continuously updates these products according to the industrial needs. Now these applications are available in mobile platforms also.
Microsoft Word is used to create business documents, reports, bio data, letters etc. Its main advantage is the ability to format the documents as per our need. It additionally checks spelling and grammar in the content. It can support image, HTML guide, equation formats and other objects.
Usually abbreviated as PPT, is a presentation software used to create slide shows. It is mostly used in business as well as education fields. It supports images, animations, videos etc., which helps to make the presentation more appealing.
Microsoft Access is the database created by Microsoft. It allows you to collect, maintain and display the data as per your need. It is very useful in small business applications and software applications.
Microsoft Excel document consists of rows and columns, and data (text or numbers) can be entered in individual cells. It supports automatic calculation, graphical representation, pivot tables etc. MS Excel can create and edit spreadsheets and can save them with an extension of .xls or .xlsx.
Microsoft Outlook is the Microsoft software to allow the users to send and receive emails. It can also be used for information management. That is, it can store contact information including address, email etc.
Microsoft Publisher is used to design books, brochures, magazines etc. It is almost similar to MS Word, but has more compatible formats for designing publications.
Microsoft office is a software suite that has wide applicability at workplace, at schools and colleges and of course at home too. Having knowledge in Microsoft office is one of the basic need in almost all jobs since MS Office is using globally in business, education and other fields on a daily basis.
There is no prerequisite for this course. It is a beginner level training program that will help you to gain basic skillsets like working with MS Word, Excel, Power point etc. It is greatly beneficial as it enables you to do your own documentation needs, like preparation of resume, letters, reports and many more. It will be very much helpful to professionals, teachers, accountants and auditors
Trinity Technologies is one of the leading training institutes in Thiruvananthapuram. We offer training in Microsoft office suite to make you expertise in using specific software. This expertise will benefit you in work related matters and personal needs. Our dedicated tutors will introduce the tools and function of Microsoft Office suite and provide practical training.
MICROSOFT OFFICE
WORD
STARTING MS-WORD
Open an existing document
Understanding the different views
Print layout view.
Full screen reading view.
Web layout view.
Outline view.
Zoom.
Closing word
Saving your document
BASIC WORD
Scroll using the mouse
How to use the keyboard
Type text
Create a new document
Changing the default multiple line spacing
BASIC TEXT EDITING
Remove characterserror!
DEFINED.
Delete selected text
Replace selected text
Move text - cut and paste
Copy text – copy and paste
Move text with the mouse
Copy text with the mouse
Undo/repeat commands
CHECKING SPELLING AND GRAMMAR
Check spelling automatically
Use the ignore button
End the spell check
Check grammar as you type
Start the grammar checker
USING CHARACTER FORMATTING
Format characters
Change an existing font
Modify the font size
Change the font format
Underline text
Use quick styles
Copy character formats
Change character case
FORMATTING
Formatting paragraphs
Aligning paragraphs
Modifying paragraph spacing
Modifying line spacing
Copy paragraph formats
Applying a paragraph style
DOCUMENT FORMATTING
Format documents
Insert a manual page break
Remove a manual page break
Change the document margins
Change the page orientation
Change orientation for whole document
Change orientation for a part of the document
Change the paper size
Change the vertical alignment
WORKING WITH GRAPHICS
Inserting a clipart
Inserting a picture
Formatting graphics
Sizing a graphic
Wrapping a graphic
Re-colour your graphics
Correcting images
Adjust brightness and contrast
Remove background
SETTING TABS
Setting tab stops
Setting a left-aligned tab
Setting a center tab
Setting a right-aligned tab
Setting a first line indent
Setting hanging ind
Clearing all tabs
Removing a tab stop
Using the tabs dialog box
INDENTING PARAGRAPHS
Create a left indent
Indent the first line
Create a hanging indent
Create a right indent
Use indent and spacing tab
USING NUMBERS AND BULLETS
Creating numbered lists
Adding numbers to text
Deleting a numbered item
Removing numbers from text
Creating a bulleted list
Adding bullets to text
Removing bullets from text
HEADERS AND FOOTERS
Create a header
Create a footer
Create different first page
USING SECTION BREAKS
Work with section breaks
Insert a (section) next page break
Remove a section break
PRINTING FROM BACKSTAGE VIEW
Previewing a document
Printing a document to printer
USING HELP
New word 2010 help
Use help table of contents
Use search function
EXCEL
GETTING STARTED
Opening microsoft excel
what is excel used for?
Overview of excel
naming parts of the excel window
defining excel vocabulary
file new
file open
file close
file save/save as
PAGE SETUP
Margins
header/footer
print titles (printing and viewing)
scaling
PRINTING
Print preview
printing a selected parts
Print current page and pages
Set print area
Remove print area
MOVING AROUND IN EXCEL
Naming cells
find command
Replace command
Goto command
page view
ENTERING DATA AND SELECTING CELLS
Resizing columns and rows to fit data
Using macro
FORMATTING CELLS
Auto format
number
alignment
font
boarder
pattern
formatting columns or rows at a time
CUT, COPY, PASTE, INSERT
Menu bar
toolbar
right clicking
INSERTING, DELETING, AND MOVING
Rows
columns
sheets
Tab color
Copy sheet
CHARTING
Charting wizard
selecting objects in a chart
customizing a chart
resizing a chart
printing a chart on a whole page
Adding items in to chart
Coloring chart
Give names to axis
CALCULATIONS
copying a calculation using the fill handle
formula bar
Mathematical
Date functions
Text functions
editing formula
using preset functions
order of operations
combining words from different cells into one cell
Merging and spitting cells
DATA
Using pivot table
List
Table
Filter
Sort
Formula auditing
Scenario
Goalseek
INSERTING OBJECTS
Clipart
Picture
word art
Autoshapes
Diagram
USE WINDOW
Aranging different window
Freeze pane
POWERPOINT
STARTING MS POWERPOINT
Starting powerpoint
Opening an existing presentation
Understanding the presentation window
PRESENTATION BASICS
Creating a new presentation
inserting and deleting a slide and selecting a layout
opening a presentation
Navigating a presentation
using undo, redo and repeat
saving a presentation
Previewing and printing a presentation
closing a presentation
UNDERSTANDING THE PRESENTATION VIEWS
Normal view:
Slide sorter view:
Notes pages view:
Slide show view:
CREATE YOUR FIRST PRESENTATION
Entering and selecting text
Entering text
To move a placeholder on the slide
To resize the placeholder
Selecting text
FORMATTING TEXT
To change the font
To change the font size:
To change the font effect:
VIEWING A PRESENTATION
Changing views
Using the zoom controls
Using the outline pane
WORKING WITH BULLETED LIST
Inserting text
Emphasizing sub-topics using indents
Changing bullets
SMARTART GRAPHICS
What are smartart graphics?
Create organization chart
Add manager and subordinates boxes
To delete a shape.
Layout and design shape:
Format shape
WORKING WITH CHARTS
Using charts in slides
Creating a chart
Handling data
Edit data
Deleting data
Hide-unhide data
Changing chart type
Changing chart layout & styles
Changing chart layout
Changing chart style
Changing chart elements manually
CLIPARTS
Inserting a clipart
Modifying cliparts
Cropping cliparts
Re-sizing cliparts
3 copying cliparts
WORKING WITH TABLES
Creating a table
Working with a table
Adjusting column width and row height
Inserting and deleting rows and columns
merging and splitting cells
Working with borders and shading
Applying a table style
WORDART
Inserting wordart
Add text effects
ANIMATIONS AND EFFECTS
Animation effects
Prebuilt animations
Custom animations
SLIDE TRANSITION EFFECTS
Modyfy transition
Advance slide
SAVING A PRESENTATION
PRINTING A PRESENTATION
