Course Objectives

This course is for participants who have no prior knowledge in Excel.

Course Outline

Exploring Excel

Using Basic Workbook Skills

Working with Ranges

Working with Columns and Rows

Formatting Numbers

Formatting Text

Formatting Cells

Creating Simple Formulas

Copying and Moving Data

Printing

Working with the Office Assistant

Course Duration

10 Hours

Course Fees

$85.60

Course Objectives

This course is for participants who have some hands-on knowledge in Excel and would want to use it more effectively.

Course Outline

Using more advanced formulas

Working with Multiple Worksheets

Managing Worksheets

Using Paste Special

Using Large Worksheets

Using Other Functions

Creating Charts

Editing Charts

Modifying Charts

Drawing an Object

Using Additional Effects and Objects

Managing Data

Using Page Setup

Using Templates

Using HTML Files

Managing Files

Using Conditional and Custom Formats

Course Duration

10 Hours

Course Fees

$160.50

Course Objectives

In this course, participants will learn about the application of Powerpoint at the basic level.

Course Outline

Exploring PowerPoint

Using Basic Presentation Skills

Using the Outline Pane

Correcting Spelling and Text Errors

Enhancing Presentation Text

Formatting and Editing Text

Inserting Clipart

Using Graphic Images and Tables

Using Slide Sorter View

Using Slide Show View

Working with the Office Assistant

Course Duration

10 Hours

Course Fees

$85.60

Course Objectives

In this course, participants will learn about the application of Powerpoint at the intermediate level.

Course Outline

Editing Multiple Presentations

Working with Drawing Objects

Using the Slide Master

Customizing Presentations

Creating Organization Charts

Using Tables

Creating Basic Charts

Editing and Importing Charts

Creating Custom Charts

Adding Special Effects and Animations

Expanding a Slide Show

Setting Up the Slide Show

Exporting Outlines and Presentation Slides

Printing, Sending, and Publishing

Course Duration

10 Hours

Course Fees

$160.50

Course Objectives

This course is for participants who have no prior knowledge in Access.

Course Outline

Exploring Access Database

Working with Databases

Working With Tables

Field Data Types

Create A New Database

Creating Primary Key

Creating and Running Queries

Creating Relationship

Customising Forms

Forms

Generating Reports

Creating An AutoReport

Creating Mailing List

Course Duration

10 Hours

Course Fees

$85.60

Course Objectives

This course is for participants who have some knowledge in Access.

Course Outline

Working with Database

Working with Queries

Creating a Multiple Table Query

Creating a Calculated Field

Using Expressions

Using Criteria

Crosstab Queries, Delete Queries, Append Queries

Make Table Queries and Update Queries

Working with Forms

Creating a Form with AutoForm

Modifying a Form

Adding and Deleting Fields

Moving and Sizing Controls

Changing the Tab Order

Working with Control Properties

Control and Form Property Reference

Working with Multiple Controls

Adding, Cutting, Copying, and Pasting Controls

Creating a Subform

Modifying and Working with Subforms

Working with Reports

Creating a Report with AutoReport

Modifying a Report

Adding and Deleting Fields

Moving and Sizing Controls

Adding Page Numbers and Dates

Understanding Report Sections

Grouping and Sorting Records

Creating Calculated Controls

Formatting Forms and Reports

Formatting Fonts with the Formatting Toolbar

Changing Text Alignment

Using AutoFormat

Changing Colors

Applying Special Effects

Aligning Controls

Changing a Controls

Formatting Properties

Working with Other Programs

Importing Information

Exporting Information

Mail Merging Records to Microsoft Word

Course Duration

10 Hours

Course Fees

$160.50