MS Office
 

Power Point Presentation

Microsoft Power Point is the name of a non-free commercial software program developed by Microsoft. It was developed by Microsoft and officially launched on May 22, 1990. It is part of the Microsoft Office suite, and runs on Microsoft Windows and Apple's Mac OS X operating system.

Duration : Two Days

Objectives:
  • Open, move around in, and close a Presentation.
  • Display different views of a Presentation.
  • Save a Presentation.
  • Quickly create a Presentation.
  • Create a Presentation based on a ready-made Design.
  • Convert an outline to a Presentation.
  • Reuse existing Slides
  • Create a Photo Album
  • Add and Manipulate Text Boxes
  • Correct and Size while tying
  • Check spelling and choose the best words
  • Find and replace Text and Fonts
  • Change the size, alignment, spacing, and look of Text
  • Change the Layout of Slide
  • Rearrange Slides in a Presentation
  • Switch to a different Color Scheme
  • Use colors that are not part of the Scheme
  • Add Shading and Texture to the background of a Slide
 
Methodology
Hands on PowerPoint.
 

Advance Excel

Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has almost completely replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office. The current versions are 2010 for Microsoft Windows and 2011 for Mac OS X.

Duration : Two Days

Objectives :
  • Formulas with Several Operators and Cell Ranges
  • Using the Formula Palette to Enter and Edit Formulas
  • Creating and Using Range Names
  • Creating a List
  • Using the Data Form to Add Records
  • Finding Records
  • Deleting Records
  • Sorting a List
  • Filtering a List with the AutoFilter
  • Recording a Macro
  • Playing a Macro and Assigning a Macro a Shortcut Key
  • Adding a Macro to a Toolbar
  • Creating a PivotTable
  • Modifying a PivotTable's Structure
  • Adding a Page Field to a PivotTable
  • Adding, Positioning, and Removing Toolbars
  • Creating and Using Custom Toolbars
  • Password Protecting a Workbook
  • File Properties and Finding a File
  • Sharing a Workbook and Tracking Changes
 
Methodology:
Getting hands on Ms excel.
 

MS - Access

Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. On May 12, 2010, the current version of Microsoft Access 2010 was released by Microsoft in Office 2010; Microsoft Office Access 2007 was the prior version.

MS Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.

Duration : Two Days

Objectives:
  • How to understand and navigate an access database
  • How to create and use tables
  • Using forms and queries
  • Understand how to work with reports
  • Creating and enhancing reports
 
Methodology
Hands on practice, Exercises, Basic concept Knowledge
 

MS - Project

Introduction
Microsoft Project (MSP, MSOP or WinProj) is a project management software program, developed and sold byMicrosoft, which is designed to assist a project manager in developing a plan, assigning resources to tasks, tracking progress, managing the budget, and analyzing workloads.

Duration : Two Days

The program, which has many different versions, allows users to :
  • Understand and control project schedules and finances.
  • Communicate and present project information.
  • Organize work and people to make sure that projects are completed on schedule.
 
Objectives
  • Understanding Project, configuring Project Essentials.
  • Reviewing different views – Gantt, Network (PERT), Calendar.
  • Starting on a Sample Project.
  • Understanding tasks, task Categories, relations, constraints and types.
  • Understanding different ways of Resource Entry
  • Understanding Resource Sheet – reviewing all columns
  • Understanding various aspects of resource usage, cost etc
  • Resource Pool – sharing resources among multiple projects
  • Understanding Baseline, Interim Plan, Progress Lines, Tracking etc
  • Understanding different views – Baseline, Cost, Work +
  • How to create, modify different Reports
  • Handling multiple Projects – different ways of sharing tasks among Projects
 
Methodology
Hands on practice on MS Project
 

MS - Visio

Microsoft Visio is a specialized Drawing package which creates professional Flowcharts, Organization Charts, Floor Plans and many other drawings. It is a commercial diagramming program for Microsoft Windows that uses vector graphics to create diagrams. People who have been attempting these things in Word or PowerPoint would greatly benefit from this course.

Duration : Two Days

Content :
  • Customizing Visio
    • Working with Toolbars
    • Working with Windows
  • Using the Drawing Tools
    • Drawing Basics
    • Advanced Drawing Techniques
  • Custom Shapes
    • Using Custom Shapes
    • Using Custom Shapes in a Drawing
  • Advanced Stencil Techniques
    • Custom Stencils
    • Customizing Stencil Masters
    • The Document Stencil
  • Templates, Styles, and Layers
    • Working with Templates
    • Formatting and Linking Shapes
    • Layers
  • Sharing Your Work
    • Object Linking and Embedding
    • Working with External Data
    • Creating HTML Documents
    • Printing Techniques
 
Methodology
Hands on practice on MS Visio