Staff Training and Workshops:

a. Word Formatting Training Course using Microsoft Word.

b. Manipulating, Analyzing & Reporting data using Microsoft Excel.

c. Database Management System using Microsoft Access.

d. Advance Level Workshop (Advanced Excel – Advanced Access)

a. Word Formatting Training Course using Microsoft Word.

  • Course Duration: 3 days
  • Course Contents:
    • Microsoft Word Interface
    • Font Group – Paragraph Group – Editing Group
    • Working with Tabs
    • Insert Objects in your Page (Shapes-Textbox-Picture-Table-Symbols-Hyperlink)
    • Mail Merge (Envelope – Formal Letter)
    • Header and footer – Page Number
    • Page border – Watermark
    • Insert Cover Page – Blank Page – Page Break
    • Create a Table of Contents
    • Footnotes and Endnotes
    • Set Password to protect your document

b. Manipulating, Analyzing & Reporting data using Microsoft Excel.

  • Course Duration: 4 days
  • Course Contents:
    • Import data
    • Formatting Cells
    • Conditional Format
    • Data Filtration
    • Sort & Custom Sort
    • Design Report
    • Using Common Functions.
    • Using Subtotal Function
    • Advanced Functions
    • Lookup & Reference
    • Chart
    • Protection

c. Database Management System using Microsoft Access.

  • Course Duration: 4 days
  • Course Contents:
    • Organizing data in database
      • Create New Blank Database.
      • The Interface
      • Database Objects (Tables-Queries-Forms-Reports)
      • Create Database by using Sample Template
      • Creating a table using the design view
      • Entering & modifying data in a table
      • Navigating through records within a table
      • Field Properties
    • Manipulating Data
      • Filtering
      • Sorting
      • Searching
    • Data integrity Constraints
      • Validation rules & Text
      • Relationships
    • Data Retrieval