Certificate in Ms Office Package - Complete

Course details

e the width and structure of newspaper columns
Apply borders and shading to paragraphs
Copy formats using the Format Pointer
Use the Office Assistant to find hel
Microsoft EXCEL

The Basics

Examine the look and features of Excel
Enter and change constant values
Save and retrieve Excel Files
Enter both simple formulas and formulas with functions by typing and pointing
Using AutoSum and AutoCalculate
Study concepts including the mathematical order of operations and absolute and relative cell references
Use the toolbar and menu commands to change selection with number formats, cell alignments, font, cell borders and patterns
Use the SpellCheck and AutoCorrect features
Change worksheet appearance by inserting, deleting and changing the size of columns/rows
Preview and print entire or partial worksheets with new margins, header and footer, gridlines and column heading
Intermediate

Create Formula using various function
Creating and printing Graph
Protect files, worksheets and cells
Link worksheet data
Use Dote and Time functions and Numeric functions In a Worksheet
Microsoft POWERPOINT

The Basics

Start the PowerPoint program, identify on-screen features, and navigate presentation
Create and Edit bullet slides
Use PowerPoint's drawing tools
Working with Clipart
Printing
Intermediate

Creating Organization Chart
Creating of Graph
Working with outline view
Working with Note Pages View
Setting up slide show
Animation effects in slide show
Advance Printing
MS Access (Introduction to Table, Forms & Reports)

Database concept
MS Access Table concept
Table fields and various data type
Creating Ms Access Table using design view
Edit table structure and records
Simple search in table
Design and modify simple forms and reports
Calculate within database reports
Print reports
Internet

Dialling Up for Internet Connection
Internet Browsers and URLs
Finding things on the Web
Introduction to Email
The Parts of an Email
Understanding Email Address
Setting up an Email Account
Working with Email

Method of Delivery

Lecture / Computer Lab

Award Criteria

Students, who satisfy the minimum attendance requirements (75%) will be issued with the 'Certificate of Attendance' by BMC.

Grading System

No assessment

Assessment Information

No assessment

Appeal Process

Not applicable

Expected date of release of Assessment result

Not applicable