Microsoft Office

Course details

Objective

Microsoft Office Word 2010: to provide students to create and edit professionallooking documents for a variety of purposes and situations in their daily life work or studies.

Microsoft Office Excel 2010: to provide students to perform basic calculation and edit professionallooking spreadsheets for a variety of purposes and situations in their daily life work.

Microsoft Office Powerpoint 2010: to provide students to generate slide shows, such as product plans, reports, and marketing materials.

Microsoft Office Access 2010: to provide students with basic knowledge, skills and concepts of the features of Microsoft Office Access.

Microsoft Office 2010

Microsoft Word 2010

• Introduction to Microsoft Word
• Getting Started in Microsoft Word
• Setting Up Your Screen
• Working with Text, Graphics, and Text Boxes
• Viewing the Document
• Character Formatting
• Paragraph Formatting
• Page Layout and Styles
• Language Formatting
• Boarders and Shading
• Style Formatting
• Page Setup
• Section Formatting
• Using Auto Format
• Headers and Footers
• Using Print Preview
• Printing a Document
• Columns
• Tables
• Sorting Information
• Mail Merge
• Creating the Main Document
• Specifying the Data Source
• Adding Merge Fields to the Main Document
• Setting Merge Options
• Outlines
• Finding and Replace
• AutoText
• Automatic Bullets and Numbering
• Captioning
• Using Bookmarks

Microsoft PowrPoint 2010

• Introduction To Microsoft PowerPoint
• Getting Started in Microsoft PowerPoint
• What Can You Do with PowerPoint?
• Creating a Presentation
• Creating and Editing Slides
• Changing the Layout of a Slide
• Changing the Design Template
• Outlining Your Presentation
• Rearranging Your Slides
• Creating Notes Pages
• Previewing Your Slides Show
• Inserting Object in Your Presentation
• Drawing object in PowerPoint
• Animating an Object
• Finalizing the Presentation
• Setting up the Slides Show
• Giving the Presentation

Microsoft Excel 2010

• Introduction To Microsoft Excel
• Spreadsheets, Worksheets and Workbooks
• Parts of the Excel Screen
• Working with Worksheets
• Creating a Spreadsheets
• Editing and Formatting a Workbook
• Viewing the Worksheet
• Working with Ranges
• Editing data in Worksheets
• Using Styles
• Restructuring the Worksheet
• Sorting Data
• Adding Comments
• Adding Headers and Footers
• Printing from Excel
• Chart Terms and Basics
• Choosing the Right Type of Chart
• Creating a Chart
• Modifying a Chart
• What Are Formulas and Functions
• The parts of a Formula
• Creating a Formula
• Working with Functions
• Copying and Moving Formulas
• Recalculating Formulas
• Viewing Formulas in the Workbook

Microsoft Access 2010

• Introduction To Microsoft Access
• Getting started in Microsoft Access
• Components of a Database
• Navigating in Access
• Entering Data in a Database
• Exporting Information form a Database
• Saving Information in a Database
• Closing a Database and Exiting Access
• Building a Database using the Access Wizards
• Building a Database on your Own
• Working with Tables
• Working with Forms
• Creating Form with the Form Wizard
• Modifying a Form
• Working with Queries
• Creating a Query
• Modifying a Query
• Working with the Reports
• Creating a Report with Report Wizard
• Creating a Report with Auto-Report

Academic Qualification

Primary education & above

Proficiency Level

English at Primary level & above

Course Outcomes

Certificate