Microsoft Office 2007 Basics

$49.00

Category:

Overview


Overview

Access 2007- The Database Management System in the Microsoft Office package. Smooth functioning of any business will require handling of huge amounts of data and this course intends to enable participants to manage corporate data by grasping the functions of the seven main components and also other features of Microsoft Access.

Excel 2007- Excel spreadsheet has become an industry standard, having replaced the others with its many tools for data analysis. The course will make it easier for the participants to represent data in multiple ways for the ease of management and also carry out calculations and even financial operations on the data using MS Excel.

Outlook 2007- Although Outlook is primarily a personal information manager there are other features which let you manage your work. The course will focus on the use of these features in the context of business application, including search tools, folders, junk e-mail filters, and organization tools. The course will be a detailed introduction to the major functions that Outlook supports (calendar, contacts, tasks, and e-mail).

PowerPoint 2007- PowerPoint, as a presentation program, has brought about a revolution in the domain of visual aid. This course has been designed to encourage learning from the basics, right from creating a slide to planning the ideas in a train of coherent thoughts which will help in presenting even complicated ideas comprehensively.

Word 2007 – In a sense knowledge of MS Word has become as essential as knowing how to hold a pen! We understand the need to start education ‘of the basics from the basics’ and the course is a result of this. Starting from word processing tasks the course will move on to formatting tools and all essentials required in working on the program at a corporate level.

Why MISP


Why MISP

Nothing can equal the years of experience the trainers at MISP has accumulated, in training professionals. A direct understanding of the trends in the industry helps us devise methodological training strategies that will hit the mark.

We have adapted well with the changes that has happened in the teaching-learning process in the present industrial scenario.

Our online system has been designed so that the participants can review their progress. We also facilitate telephonic, as well as face-to-face consultation and weekly workshops.

The online classroom system is a part of the upcoming educational system. Even working professionals can access our courses without disrupting their work schedule.

We understand the basic duty of an educator and strive to provide the best learning experience that will help them attain their goals.

Our helpdesk is open to any queries that you might have. Reach out to us for the assistance of an educational advisor.

Our promise is; we keep a track of your progress to your certification.

Program Details


Program Details

Access 2007 Course Outline:
Module One: Getting Started
Icebreaker
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 Database 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
Icebreaker
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
Icebreaker
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
Icebreaker
Housekeeping items
Pre-Assignment Review
Workshop objectives

Benefits of the Program


Benefits of the Program

The course will cover all the introductory aspects of working with all the programs in MS Office, the knowledge of which is an absolute necessity in the technology driven new world.

Delivery of the Program


Delivery of the Program

  • Printed copy of the power point presentation – same as used in physical workshops
  • Printed copy of the student manual or the training guide
  • Online step by step tutorials of the worksheet or exercise sheets
  • Printed copy of quick tips and tricks.
  • Online access of power point presentation – You can see on the web with your login anytime anywhere
  • Online access to test
  • Online access to carefully chosen relevant articles
  • Online access to carefully chosen audio video clips
  • Completion certificate is mailed to you 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 instructors are subject matter experts with immense industry experience.

Practice Test


Practice Test

MISP provides practice tests that can be taken online through the e-learning portal to prepare you for the real experience. Login details for the test will be sent to each participant after the completion of the course registration.

Batch Schedule


Batch Schedule

Please refer to the news and events section in the home page to find your favourite course and the next batch schedule.

Accreditation


Accreditation

This is a self development program and do not require an accreditation. However, every participant will receive a course completion certificate upon completion of the course.