Beginner's Project Package(MOUS)

Mastering Microsoft Office 2010 Tools - Phase I

(MICROSOFT WORD, EXCEL, POWERPOINT)
 
Course Objective:
  • The Hands on Microsoft Office 2010 Tools course is designed to give in-depth exposure to effectively use the MS Word 2010, MS Excel 2010 and Powerpoint 2010 Tools .
  • At end of the course the project work gives the audience to explore the techniques .

Pre-Requisites for the Course:

 

Comfortable of using PCs with Microsoft Windows Operating systems.

An Introduction to Microsoft Word 2010
  • Word 2010 - Basics
  • How Word 2010 Works
  • Customizing Word
  • Menu Reference
  • Create simple and Complex Documents
  • Creating a Template
  • Making the most of the word's proofing tools
  • Automating your documents
  • Tables-Organizing your pages
  • Using Mail Merge
  • Foot notes, Book marks and cross-references
  • Exercise I
  • Case Study I
An Introduction to Microsoft Word 2010 - Continued..
  • Printing , Faxing and Email Features
  • Streamlining your Formatting with Styles
  • Templates, Wizards and Add-ins
  • The best way to organize a document
  • Word Desktop Publishing
  • Integrating with  Microsoft Office.
  • Exercise II

  • Case Study II

An Introduction to Microsoft Excel 2010
  • Getting Started with Excel
  • Entering and Saving Worksheet data
  • Selecting and Naming Cells  and ranges
  • Editing Cell Content
  • Moving, Copying, Linking and Embedding  Information
  • Formatting Worksheets
  • Modifying Numbers and Dates
  • Exercise III

  • Case Study III

An Introduction to Microsoft Excel 2010 - Continued..
  • Printing Excel Worksheets
  • Constructing Excel Formulas
  • Using Formulas and Functions
  • Working with named Ranges
  • Building Charts with Excel
  • Using Excel with Power point and MS Word.
  • Customizing Excel to fit your work style
  • Exercise IV
  • Case Study IV

An Introduction to Microsoft PowerPoint 2010
  • Introduction to PowerPoint 2010
  • Creating a Basic Presentation
  • Editing and Formatting the Presentations
  • Making Presentations
  • Working with Charts, Graphs and Multi-media
  • Working with the Powerpoint on the Web
  • Integrating with Office 2010 Products
  • Exercise VII

  • Case Study V

Project Work

 


Mastering Microsoft Office 2010 Tools - Phase II

(MICROSOFT ACCESS 2010)
Course Objective:
  • The Hands on Microsoft Office 2010 Tools course is designed to give in-depth exposure to effectively use the Access 2010 as a database environment and as well as client server application developmental tool. Also helps to master the techniques to build form, reports, query and client server applications by using Access 2010.
  • At end of the course the project work gives the audience to explore the techniques.
Pre-Requisites for the Course:

Comfortable of using PCs with Microsoft Windows 95 / 98 Operating systems.

An Introduction to Microsoft Access 2010
  • Access 2010 - Overview
  • Access  as a Development Tool
  • Database, Tables, Queries, Forms, Reports, Data Access Pages
  • Object Naming Conventions
  • Building a New Table
  • Selecting  Field Data Types
  • Working with Field properties
  • Primary Key - Importance
  • Working with Table properties
  • Indexes - To improve Performance
  • Data Integrity - Relationships
  • Establishing the Relationships
  • Referential Integrity - Implementation
  • Benefits of Relationships
  • Indexes and Relationships
  • Exercise I

  • Case Study I

Microsoft Access 2010 - Continued
  • Queries
  • Query Basics
  • Ordering Query Results
  • Query Refinement with Criteria
  • Updating the Query Results
  • Multiple tables Query
  • Creating Calculated Fields
  • Nulls and Query Results
  • Building Parameter Queries
  • Exercise II 

  • Case Study II

Microsoft Access 2010 - Continued
Forms
  • Uses of Forms
  • Anatomy of Form
  • Creating a New Form
  • Working with Form Design Window
  • Selecting the Correct Control for the job
  • Control Morphing
  • Conditional Formatting
  • Form Properties
  • Building Forms- Based on More tables
  • Exercise III

  • Case Study III

Microsoft Access 2010 - Continued
 Reports
  • Report Types
  • Anatomy of Report
  • Creating a New Report
  • Working with Report Design Window
  • Selecting the Correct Control for the job
  • Report Properties
  • Page Breaks
  • Building Reports - More than a Table
  • Working with Reports - Sorting and Grouping
  • Exercise IV 
  • Case Study IV

Project Work

Introduction to Outlook

Quickbooks as an Accounting tool