Microsoft Office 2007 Advanced






Access 2007: This is one among the top most popular database applications presently in the market. This course explains you clearly why Access 2007 is very popular. With Access 2007, it is easy to create, maintain and manage all the information because of it’s re-designed interface, better data management and intuitive controls.

Excel 2007: This course will show you how to do more with your data like adding graphics such as PivotTables and SmartArt, performing advanced data analysis and many more. This course is a must for people who work on excel on daily basis.

Outlook 2007: Many people make use of Outlook to manage their calendar, e-mail, tasks, and contacts. On the other hand, Outlook contains many features that will help you to save ample amount of time and makes you work smarter. You will learn how to use all those features in this course, including search tools, junk e-mail filters, organization tools and folders. We also give you a thorough introduction to each of Outlook’s key functions like contacts, calendar, tasks, and e-mail.

PowerPoint 2007: The PowerPoint 2010 course will educate you on everything you need to get up and running with PowerPoint, including how to create a basic slideshow, create a coherent show design, add specialized content and give an incredible presentation.

Word 2007: Microsoft Word is one of the most widely used applications in today’s world. So it is very important to have a firm grasp on its basics. To begin, you will learn the basic word processing tasks like how to type, edit and delete text. Then, we will have a look at some of Word’s essentials features, including themes, headers and footers, bullets and numbering and formatting tools.




  • At MISP, we completely understand the training requirements of MS office 2007 advanced training as we have over years of training experience. This has helped us discover more advanced methodical and strategic plans to train people and achieve their goals.
  • We have 360 degree view of the customer requirement and provide effective solutions.
  • We understand our clients and thus have compiled and consolidated all training’s to suit their requirements in more realistic approach.
  • Our online system allows you to review and grade your progress, combined by telephonic consultation, face to face meetings and weekly workshops.
  • With our online system; people do not need to waste their precious time and they can access our training program round the clock 24×7.
  • Our objective and goal is to see our clients achieve the desired goals and progress. We commit to extend all support to achieve the collective goals.
  • You can reach our help desk and an education advisor will call to resolve your query.
  • We track you throughout the process until we see you certified.

Program Details

Program Details

Access 2007 Course Outline:
Module One: Getting Started


Housekeeping Items

Pre-Assignment Review

Workshop Objectives

Action Plans And Evaluation Forms

Module Two: Opening And Closing Access

Common Database Terms

Opening Access

Understanding The Getting Started Window

Creating A Blank Database From A Template

Module Three: Using The Access Interface

Understanding Security Warnings

Interface Overview

Overview Of The Ribbon Interface

Using the Navigation Pane

Module Four: Working With Data

base Objects

Viewing Database Objects

Exporting An Object

Renaming An Object

Sorting And Filtering Your View

Module Five: Creating Tables

Creating A Blank Table In Datasheet View

Creating A Blank Table In Design View

Creating A Table From A Template

Adding A Table From A SharePoint List

Key Features On The Table Tools Tabs

Module Six: Working With Tables

Adding Information To A Table

Editing Records

Deleting Records

Searching For Records

Module Seven: Creating Forms

Types Of Controls

Creating A Form With The Wizard

Creating A Form In Layout View

Modifying Your Form In Design View

Key Features On The Form Tools Tabs

Module Eight: Working With Forms

Common Formatting Tasks

Using AutoFormat

Adding Controls

Moving Controls

Deleting Records

Module Nine: Creating Reports

Using The Report Wizard

Using Design View

Adding A Logo

Working With Controls

Key Features On The Report Tools Tabs

Module Ten: Creating Queries

Types Of Queries

Creating a Query With The Wizard

Executing A Query

Viewing The Query

Key Features On The Query Tools Tabs

Module Eleven: Managing Your Database

Using Alternate File Formats

Printing An Object

Backing Up Your Database

E-mailing Your Database

Module Twelve: Wrapping Up

Words from the Wise

Parking Lot

Action Plans and Evaluations

Excel 2007 Course Outline:

Module One: Getting Started


Housekeeping Items

Pre-Assignment Review

Workshop Objectives

Action Plans And Evaluation Forms

Module Two: Opening And Closing Excel

Opening Excel

Understanding The Interface

Understanding Worksheets

Understanding Workbooks

Closing Excel

Module Three: Your First Worksheet

Entering Data

Using The Wrap Command

Editing Data

Adding Rows And Columns

Checking Your Spelling

Module Four: Working With Excel Files

About the New File Format

Saving Files

Publishing Files To PDF

Sending Files via E-Mail

Opening Files

Module Five: Viewing Excel Data

An Overview Of Excel Views

Switching Views

Using Zoom

Switching Between Open Files

Module Six: Printing Excel Data

An Overview Of The Page Layout Tab

Setting Up Your Page

Using Print Preview

Printing Data

Module Seven: Building Formulas

The Math Basics Of Excel

Building A Formula

Editing A Formula

Copying A Formula

Relative vs Absolute Referencing

Module Eight: Using Excel Functions

Formulas vs Functions

Understanding The Formulas Tab

Using The SUM Function

Using Other Basic Excel Functions

Using The Status Bar to Perform Calculations

Module Nine: Using Time Saving Tools

Using AutoSum

Using AutoFill

Using AutoComplete

Sorting Data

Filtering Data

Module Ten: Formatting Your Data

Changing The Appearance Of Your Text

Changing The Appearance Of Numbers

Setting Alignment Options

Changing Cell Size

Using The Merge Command

Module Eleven: Working With Colors

Adding Borders

Adding Shading

Using Cell Styles

Using The Format Painter

Using Conditional Formatting

Module Twelve: Wrapping Up

Words from the Wise

Parking Lot

Action Plans and Evaluations

Outlook 2007 Course Outline:

Module One: Getting Started


Housekeeping items

Pre-Assignment Review

Workshop objectives

Action plans and evaluation forms

Module Two: Setting up Outlook

Opening Outlook

Interface Overview

Setting up an E-mail Account

Viewing Your Inbox

Closing Outlook

Module Three: Working with E-Mail

Sending and Receiving Mail

Viewing an E-mail

Replying To or Forwarding an E-mail

Deleting an E-mail

Module Four: Creating a New E-Mail

Creating an E-mail

Addressing an E-mail

Creating the Body

Attaching a File

Sending the Message

Module Five: Managing E-mail

Marking an Item as Read or Unread

Printing a Message

Creating Folders

Moving Messages to Folders

Renaming, Deleting, and Moving Folders

Module Six: Managing Junk Mail

About the Junk Mail Filter

Enabling Junk Mail Filtering

Enabling the Phishing Filter

Modifying Safe and Blocked Senders

Marking a Message as Junk or Not Junk

Module Seven: Outlook’s Organization Tools

Creating a Basic Rule

Creating an Advanced Rule

Using Categories

Flagging an Item for Follow-Up

Viewing Favorite Folders

Module Eight: Searching for Items

Setting Up Search Folders

Using Search Folders

Using Instant Search

Using Advanced Search

Using Contact Search

Module Nine: An Introduction to the Calendar

Getting Started

Creating an Appointment

Editing an Appointment

Managing Reminders

Changing Your Calendar View

Module Ten: An Introduction to Tasks

Getting Started

Creating a New Task

Editing a Task

Updating Task Status

Basic Task Views

Module Eleven: An Introduction to Contacts

Getting Started

Creating a New Contact

Editing a Contact

Navigating Through Tasks

Basic Contact Views

Module Twelve: Wrapping Up

Words from the Wise

Parking Lot

Action Plans and Evaluations

PowerPoint 2007 Course Outline:

Module One: Getting Started


Housekeeping items

Pre-Assignment Review

Workshop objectives

Benefits of the Program

Benefits of the Program

After attending our MS office 2007 advanced certification classes, the candidates will gain in-depth knowledge on MS Office 2007 advanced. The candidates will be able to apply all its features successfully while doing daily tasks.

Delivery of the Program

Delivery of the Program

  • You will be provided with a Printed copy of the power point presentation same as used in physical workshops
  • A Printed copy of the student manual or the training guide
  • We also provide online step by step tutorials of the worksheet or exercise sheets.
  • Printed copy of quick tips and tricks will be given which helps you remember terminologies, shortcuts and other important information.
  • You will be granted online access to the power point presentation.
  • You can see on the web with your login anytime anywhere
  • You will be granted access to the online tests.
  • We provide online access to carefully chosen relevant articles.
  • Online access will be given to carefully chosen audio video clips. This is not applicable for this course.
  • Completion certificate is mailed to the candidate on successful completion of the test.
  • Some programs have an original book by renowned authors.

Your Instructor

Your Instructor

This is a self study program. Same programs are conducted in workshops and as instructor led training. Our trainers are subject matter experts with immense industry experience.

Practice Test

Practice Test

The practice tests are taken online through the e-learning portal. After you register for the program; login details would be sent for the test. Call MISP consultants for any sort of additional information.

Batch Schedule

Batch Schedule

Please go through the news and events section in the home page to find your preferred course and the next batch schedule.



These are self development programs and do not require an accreditation. But we issue a certificate of completion after you have successfully completed the program.