Microsoft Office Series:

Microsoft Office 2007

Getting Know how to work in a PC based office environment using the Microsoft Products, Microsoft Office 2007 as easier and faster.

Target Audience

All those who wish to use Microsoft Office 2007 in their daily job functions easier as well as faster

Prerequisites

Ability to understand instructions in English

Modules

  1. Windows XP
  2. Microsoft Word 2007
  3. Microsoft Excel 2007
  4. Microsoft Powerpoint 2007
  5. Microsoft Access 2007
  6. Microsoft Outlook 2007

80 Hours

Rs. 12,000.00

 
Windows XP

  • GETTING TO KNOW WINDOWS XP

  • WORKING WITH THE START MENU

  • WORKING WITH FILES AND FOLDERS

  • WORKING WITH WINDOWS

  • CUSTOMIZING THE DESKTOP AND

  • TASKBAR

  • WORKING WITH WEB APPLICATIONS

  • WORKING WITH WINDOWS XP ACCESSORIES

  • GETTING HELP AND SUPPORT

Microsoft Word 2007

  • CUSTOMISING MICROSOFT WORD

  • TEXT EDITING

  • PARAGRAPH EDITING

  • STYLES

  • TEMPLATES

  • SECTION BREAKS

  • COLUMNS

  • TABLES

  • GRAPHICS

  • TEXT BOXES

  • MAIL MERGE

 

Microsoft Excel 2007

  • MANIPULATING DATA, & NAMED RANGES

  • TEMPLATES

  • FORMATTING & DISPLAY TECHNIQUES

  • SORTING AND QUERYING DATA

  • LINKING & CONSOLIDATING DATA

  • PROTECTION AND SECURITY

  • CHARTS FORMATTING TECHNIQUES

Microsoft PowerPoint 2007

  • PHOTO ALBUMS

  • MEDIA CLIPS

  • TABLES

  • SLIDE SHOW ANIMATION EFFECTS

  • SLIDE SHOW MANIPULATION

  • TEMPLATES AND SLIDE MASTERS

  • SLIDE MANIPULATION

  • MANIPULATING ILLUSTRATIONS

  • SHAPE FORMATTING

  • PICTURE FORMATTING

  • CHARTS AND FLOW CHARTS

  • LINKING OBJECTS

  • PRESENTATION PLANNING AND DESIGN CONCEPTS

 

Microsoft Access 2007

  • WHAT’S NEW

  • SECURITY ISSUES & THE TRUST CENTER

  • TABLES

  • MODIFYING FIELDS

  • LOOKUP FIELDS

  • VALIDATION RULES

  • INPUT MASKS

  • DEFAULT VALUES

  • MANDATORY FIELDS

  • CREATING A TABLE

  • RELATIONSHIPS

  • BASICS OF RELATIONSHIPS

  • TYPES OF JOINS IN A RELATIONSHIP

  • CREATING RELATIONSHIPS

  • APPLYING INNER AND OUTER JOINS

  • APPLYING AUTOMATIC DELETION OF RELATED RECORDS

  • APPLYING AND USING REFERENTIAL INTEGRITY

  • QUERIES

  • QUERY TYPES

  • GROUPING INFORMATION IN A QUERY

  • USING ARITHMETIC OR LOGICAL EXPRESSIONS IN A QUERY

  • REFINING A QUERY

  • FORMS

  • CREATING BOUND AND UNBOUND CONTROLS

  • CREATING A COMBO BOX, LIST BOX, CHECK BOX & OPTION GROUPS

 

  • CREATING ARITHMETIC / LOGICAL EXPRESSION CONTROLS

  • CREATING A FORM USING THE FORM WIZARD

  • SETTING SEQUENTIAL ORDER OF CONTROLS ON A FORM

  • CREATING FORM HEADERS OR FOOTERS

  • CREATING A SUBFORM AND LINKING TO THE MAIN FORM

  • MODIFYING THE SUBFORM TO CHANGE RECORDS DISPLAYED 

  • USING ARITHMETIC OR LOGICAL EXPRESSIONS IN A QUERY

  • REFINING A QUERY

  • REPORTS

  • CREATING ARITHMETIC / LOGICAL CALCULATION CONTROLS

  • USING FORMULAS AND EXPRESSIONS

  • CREATING RUNNING SUMMARIES

  • PRESENTATION

  • FORCING PAGE BREAKS FOR GROUPS ON

  • REPORTS

Microsoft Outlook 2007

  • WHAT’S NEW IN OUTLOOK 2007

  • A FIRST LOOK AT OUTLOOK

  • EMAIL CONCEPTS

  • SENDING MESSAGES

  • MANIPULATING MESSAGES

  • ANIPULATING TEXT AND FILES

  • CONTACTS

  • ORGANISING MAIL

  • CUSTOMISING SETTINGS