Microsoft Office 2010 Advanced





Access 2010– The Database Management System in the Microsoft Office 2010 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. At the end of the course a participant will be able to create, manage, and maintain tables, forms, reports and queries.

Excel 2010– Excel spreadsheet has become an industry standard, having replaced the others with its many tools for data analysis. Excel 2010 comes with many features that make the analysis and representation of data easier with increased worksheet and workbook sizes. Better data analysis tools that let you work with even financial data means easier management of information!

Outlook 2010– 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. This elaborate course will also look into the other major functions of Outlook in detail (calendar, contacts, tasks, and e-mail).

PowerPoint 2010– PowerPoint, as a presentation program, has brought about a revolution in the domain of visual aid. This course has been designed to encourage an advanced 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 2010 – 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. Even the smallest of feature will be touched upon which will enable a participant to work on word data with utmost ease.





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

Excel 2010 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
Working with the Backstage View
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
Saving Files
Publishing Files to PDF
Sending Files via E-Mail
Opening Files

Module Five: Viewing Excel Data
An Overview of Excel’s Views
Switching Views
Creating Custom 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 References

Module Eight: Using Excel Functions
Formulas vs. Functions
Understanding the New Function Names
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 AutoFill
Using AutoComplete
Sorting Data
Filtering Data
Adding Sparklines

Module Ten: Formatting Your Data
Changing the Appearance of Text
Changing the Appearance of Numbers
Setting Alignment Options
Using Merge
Removing Formatting

Module Eleven: Advanced Formatting Tools
Adding Borders
Adding Shading
Using Cell Styles
Using Conditional Formatting
Changing the Theme

Module Twelve: Wrapping Up
Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Outlook 2010 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
Using the Backstage View
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
Using Quick Steps
Replying To or Forwarding an E-mail
Deleting an E-mail
Ignoring 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
Using Quick Steps
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 2010 Course Outline:

Module One: Getting Started
Housekeeping items
Pre-Assignment Review
Workshop objectives
Action plans and evaluation forms

Module Two: Opening and Closing PowerPoint
Opening PowerPoint
Interface Overview
Using the Backstage View
Creating a Blank Presentation
Closing PowerPoint

Module Three: Working with Presentations
Saving Files
Opening Files
Closing Files
Creating a Presentation from a Template
Using the Recent List

Module Four: Your First Presentation
Adding Text to a Slide
Using a Content Placeholder
Adding Slides
Using the Slides Tab

Module Five: Working with Text
Using Cut, Copy, and Paste
Using the Office Clipboard
Using Undo and Redo
Finding and Replacing Text

Module Six: Formatting Text
Changing Font Face and Size
Changing the Font Color
Changing Character Spacing
Adding Font Enhancements
Clearing Formatting
Using the Font Dialog

Module Seven: Formatting Paragraphs
Adding Bullets and Numbering
Changing Alignment
Adjusting the Indent
Using Indents and Tabs
Changing Line Spacing

Module Eight: Advanced Formatting Tasks
Using the Format Painter
Changing Slide Design
Changing Slide Layout
Changing the Theme
Changing the Background Design

Module Nine: Customizing Slide Elements
Adding a Header or Footer
Creating a Standard Animation
Creating a Custom Animation
Using the Animation Painter
Adding a Slide Transition
Setting Slide Advance Options

Module Ten: Setting Up Your Slide Show
Working with Sections
Using the Setup Slide Show Dialog
Recording a Narration
Timing Your Show
Hiding Slides

Module Eleven: Showtime!
Our Top Five PowerPoint Tips
Starting a Show
Navigating through the Show
Changing Your Pointer
Switching to a Blank Screen



Benefits of the Program:

Benefits of the Program

This advanced course will cover almost all the 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.






This advanced course in MS Office 2010 is certified by CPD, UK and has become a standard among industry professionals. Every participant will be issued a certificate after the completion of the course. MISP course accreditation numbers are listed below: