Courses Computer

Computer Courses

Enhanced MS Access covering: Standard practice and New feature

 

Objectives

This course is for participants who have no or little hands-on knowledge in Microsoft Access and would want to use it more effectively.

 

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
New features of Access 2013

MICROSOFT EXCEL BASIC

Objectives

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

Course Outline

Standard Course Practice:

Conditional and Custom Formats Module
Templates Module
Working with Databases Module & Advanced Filters Module
Reviewing Charting Features Module
Creating/Revising PivotTables Module
Using Auditing Tools & Range Names Module
Using Exporting & Importing Data Module
 
New In-depth Practice:

Using Advanced Functions Module
Using Scenarios Module
Using Worksheet Protection Module
Tracking & Merging Workbooks Module
Understanding & Creating PivotTable
Creating Calculated fields
Inserting slicer

MICROSOFT EXCEL (BASIC )

Objectives

Exploring Excel 

 

Learn the 3 features in Microsoft Excel

-     Microsoft Office Button

-     Quick Access Toolbar

-     Ribbon

1 hours

Using Basic Workbook

Skills

-     Learning how to create a new workbook

-     Saving a workbook

-     Knowing where to open an existing workbook

2 hours

Working with Ranges

 The different ways to enter data in Excel

1 hour

Working with Columns and Rows

 Learn how to hide as well as to insert or delete Cells, Columns and Rows.

2 hour

Formatting Numbers

-     Participants will learn the various ways in customising Fonts and Numbers in a cell as well as even customising the cells itself.

-     Learn the different ways in aligning contents and merging cells

-     Learn the different features such as adding pictures and charts in Excel.

 

3 hours

Formatting Text

Formatting Cells

Creating Simple

Formulas

-     Participants will learn how to calculate with functions

-     The different formulas use in

Excel

-     Learn to execute a basic descending or ascending sorting

2 hours

Copying and Moving

Data

 Learn how to copy and move data from columns and rows

 

1 hour

Creating & formatting chart

 Learn how to plot chart and how to format chart

2 hours

Printing

 Learn the various options available in printing the excel worksheet.

1 hour

Working with the

Office Assistant 

 

1 hour

MICROSOFT EXCEL ( INTERMEDIATE )

 

Objectives

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

 

Course Outline

1. Using more advanced worksheet functions ( 3 hrs )

  • Participants will be able to understand and use conditional formulae
  • Learn how to set up LOOKUP tables and use LOOKUP functions
  • Learn how to use GOAL SEEK
  • Learn how to use the SOLVER

2. Working with View, Scenarios, Goal Seeker & Solver ( 3 hrs )

  • Participants will be able to create views, use Goal seek and Solver, learn to switch between views, able to create and switch between scenarios.

3. Using Excel to manage lists ( 3 hrs )

  • Learn to set up an Excel list and sort the list
  • Able to create list subtotals
  • Learn how to add, edit and delete list items using the data form
  • Learn to use Autofilter and Advance filtering tools
  • Able to analyse list data and PivotTables

4. Participants are able to create embedded charts and separate page charts ( 2 hrs )

  • Able to add and remove chart data and add trend lines to charts

5. Learn how to use standard Excel templates and create custom templates ( 3 hrs )

  • Learn to insert objects onto spreadsheets
  • Able to format drawing objects
  • Able to create themes and cell styles

6. Learn how to apply the Excel tools ( 2 hrs )

  • Able to use tools to check calculations
  • Able to share the workbook with others as well using proofing tools to check and correct the document.

MICROSOFT WORD BASIC

Objectives

This course is for participants who have no or little hands-on knowledge in Microsoft Word and would want to use it more effectively.

Course Outline

Typing and Editing of text
Editing Text: Cut, Copy, Paste, Select All, Clear, Find & Replace
Exploring Word
Basic typing in Microsoft Word
Using basic document skills
Using basic text editing
Using Character and Paragraph Formatting
Indenting Paragraphs
Inserting Dates, Data and Symbols 
Introducing Tab Settings
Using Find and Replace
Managing Files
Using online Help
Using Forms

New In-depth Practice:

Merging Mailing Labels and Directories
Creating Newsletter and Column Work
Using Section Breaks
Creating a Table of Contents
Tracking Revisions
Working with Tabs and Indents
Shading Text and Paragraphs

Course Outline

Typing and Editing of text
Editing Text: Cut, Copy, Paste, Select All, Clear, Find & Replace
Exploring Word
Basic typing in Microsoft Word
Using basic document skills
Using basic text editing
Using Character and Paragraph Formatting
Indenting Paragraphs
Inserting Dates, Data and Symbols 
Introducing Tab Settings
Using Find and Replace
Managing Files
Using online Help
Using Forms

New In-depth Practice:

Merging Mailing Labels and Directories
Creating Newsletter and Column Work
Using Section Breaks
Creating a Table of Contents
Tracking Revisions
Working with Tabs and Indents
Shading Text and Paragraphs