MicroSoft Office Training in Chennai

Training Content:

Module 1: Basic Computer Concepts

1. Introduction
What is a Computer
Software and Hardware
Hardware Components
Hardware Accessories
Operating System Software
Software Applications
2. Working with Computers
Computer Terminology
Starting and Stopping the Computer
Using the Mouse
3. Computer Tools & Utilities
Disk Utilities
Files & Directories
Manipulating Files & Folders
Working with the Windows Environment
Computer Network
LAN
Internet
E-Mail
Browsers, E-Mail Clients

Module 2 : MicroSoft Word
1 Introduction
Introduction to MSWord
Menus
Shortcuts
Document types

2 Working with Documents
Opening Files – New & Existing
Saving Files
Formatting page and Setting Margins
Converting files to different formats
Importing
Exporting
Sending files to others
Editing text documents
Inserting
Deleting
Cut, Copy, paste
Undo, Redo
Find, Search, Replace
Using Toolbars, Ruler
Using Icons
Using help
3 Formatting Documents
Setting Font Styles
Font selection – style, size, color etc.,
Type face – Bold Italic, underline
Case settings
Highlighting
Special symbols
4 Setting Paragraph Style
Alignments
Indents
Line space
Margins
Bullets and Numbering
Setting Page Style
Formatting
Border & Shading
Columns
Header & footer
Setting Footnotes
Inserting manual Page break, Column break and line break.
Creating sections and frames
Inserting Clip arts, pictures, and other files
Anchoring & Wrapping
Setting Document Styles
Table of Contents
Index
Page Numbering, data &Time, Author etc.,
Creating Master Documents
Web page
5 Creating Tables
Table settings
Borders
Alignments
Insertion, deletion
Merging
Splitting
Sorting
Formula
6 Drawing
Inserting Pictures/Files etc.,
Drawing Pictures
Formatting &Editing pictures
Grouping and ordering
Rotating
7 Tools
Word Completion
Spell Checks
Macros
Mail merge
Templates
Using Wizards
Tracking Changes
Security
8 Printing Documents
Printing Documents

Module 3: MS Excel

1 Introduction
Spreadsheet & its Applications
Opening spreadsheet
Menus & Toolbars & icons
Shortcuts
Using help
Shortcuts
2 Working with Spreadsheets
Opening a File
Saving Files
Setting Margins
Converting files to different formats
Importing, Exporting and Sending files to others
Spreadsheet addressing
Rows, Columns & Cells,
Referring cells and Selecting cells
Entering and Editing Data
Entering Data
Cut, Copy, paste, Undo, Redo, Find, Search & Replace
Filling continuous rows, columns
Inserting – Data, cells, column, rows & sheets
Manual breaks
Computing data
Setting Formula
Finding total in a column or row
Mathematical operations (Addition, Subtraction,
Multiplication, Division, Exponentiation)
Using other Formulas
3 Formatting Spreadsheets
Formatting – Cell, row, column & Sheet
Alignment, Font, Border &shading
Highlighting values
Hiding/Locking Cells
Worksheet
Sheet Name
Row & Column Headers
Row Height, Column Width
Visibility – Row, Column, Sheet
Security
Formatting – worksheet
Sheet Formatting & style – background, color, Borders & shading
Anchoring objects
Formatting layout for Graphics, Clipart etc.,
4 Working with sheets
Sorting
Filtering
Validation
Consolidation
Subtotal
5 Creating Charts
Selecting charts
Formatting charts, label, scaling etc.,
6 Using Tools
Error Checking
Spell Checks
Macros
Formula Auditing
Creating & using Templates
Tracking Changes
Customization
7 Printing worksheet

Module 4: MS Power Point
1 Introduction
Opening new Presentation
Different presentation templates
Setting backgrounds
Selecting presentation layouts
2 Creating a presentation
Setting presentation style
Adding Text to the presentation
3 Formatting a presentation
Adding style
Color, gradient fills
Arranging objects
Adding Header & Footer
Slide Background
Slide layout
4 Adding Graphics to the presentation
Inserting pictures, movies, tables, etc. into the presentation
Drawing Pictures using Draw
5 Adding effects to the presentation
Setting Animation & transition effect
Adding audio and video
6 Printing Handouts

Module 5: MS Access
1 Introduction
Database concepts
Tables
Queries
Forms
Reports
2 Opening & saving database files
Creating Tables
Table Design
Indexing
Entering data
Importing data
3 Creating Queries
SQL statements
Setting relationship
Using wizards
4 Creating Forms
GUI
Form
5 Creating & printing reports

Module 6: Outlook
Microsoft Outlook (Latest version 2012 & 2013)
Configuring Outlook for your email.
Sending, receiving and managing the email, mail polling, and mail
merge to a database file.
Sending and viewing attachments.
Acting on messages
Recalling, printing, and moving messages
Searching for, and subscribing to, mailing lists.
Using Outlook to subscribe to, and viewing Newsgroups

Microsoft Office Training in Chennai

Summary
Microsoft Office Training in Chennai
Service Type
Microsoft Office Training in Chennai
Provider Name
PSP Technologies Private Limited,
45 South Usman Road,T Nagar,Chennai-600017,
Telephone No.+919841321679
Area
Chennai, India, Online
Description
MicroSoft Office Training in Chennai | MS Office Training in Chennai | MS Word Training in Chennai | MS Excel Training in Chennai