Microsoft Office 2010 Basic

$49.00

Category:

Overview


Overview

Overview:

Access 2010: This is one among the top most popular database applications presently in the market. This course explains you clearly why Access 2010 is very popular. In this course, you will also learn how to create, maintain and manage reports, tables, queries and forms.

Excel 2010: Excel is the world’s leading spreadsheet software. You can use Excel to analyze numbers, graphically represent your information and keep track of data. With Excel 2010, you can manage much more data than ever because of the improved worksheet and workbook sizes. Excel’s easy to use interface also makes your work easier. The array of powerful tools helps you turn your data into useable information and better information leads to better decision making!

Outlook 2010: 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 plus a close look at the extended ribbon interface.

PowerPoint 2010: 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 2010: 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.

 

 

 

Why MISP


Why MISP

  • At MISP, we completely understand the requirements of Microsoft Office 2007 Basics 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 trainings 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 helpdesk 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 2010 Course Outline:

Module One: Getting Started

  • Icebreaker
  • Housekeeping items
  • Pre-Assignment Review
  • Workshop objectives
  • Action plans and evaluation forms

Module Two: Getting Started With Access

  • Common Database Terms
  • Opening Access
  • Understanding the Getting Started Window
  • Creating a Blank Access Database
  • Creating a Database from a Template

Module Three: Using the Access Interface

  • Understanding Security Warnings
  • Interface Overview
  • Overview of the Ribbon Interface
  • Working with the Backstage View
  • Using the Navigation Pane

Module Four: Working with Database Objects

  • Viewing Database Objects
  • Exporting an Object
  • Renaming an Object
  • Sorting and Filtering Your View
  • Understanding Application Parts

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 Navigation Form
  • 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 Themes
  • Adding Controls
  • Moving Controls
  • Deleting Controls

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 2010 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
  • 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 Email
  • 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 Spark lines

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

  • Icebreaker
  • 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

Benefits of the Program


Benefits of the Program

After attending our Microsoft Office 2007 Basics certification course, the candidates will gain in-depth knowledge on MS Office 2007 Basics. 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.

Accreditation


Accreditation

We issue a certificate of completion after you have successfully completed the program. This course and certificate is accredited by CPD from UK and is globally accepted as benchmark of professional standards. Here are MISP course accreditation numbers – 1215C1,1215C2,1215C3,1215C4,1215C5,1215C6,1215C7,1215C8,1215C9,1215C10,1215C11,1215C12,1215C13.