MQA Approved Training Programmes

Level 1 (Beginner) Learning Objectives:

Build a strong foundation in spreadsheet software with this Excel beginner’s course. Learn the basic concepts of spreadsheet design, formulas and functions that will enable you to build fully working models using the world’s most popular spreadsheet software.

Course details: 

1. Workbooks and Worksheets
2. Formulas: Calculation, Order of Operations, Absolute and Relative References
3. Functions: sum, max, min, average, count, countblank, counta, function library, insert function
4. Sorting, Filtering and Tables
5. Charts and Graphs
6. Page Layout, Formatting and Printing

Duration: 6 hours/ 1 day

Course Fee: –

Level 2 (Advance) Learning Objectives:

Learn essential functions as well as how to manage list data, cover formulas and function techniques, PivotTables, intricate formatting, setting complex printing options and using intricate charting features.

Course details: 

1. Order of operations: Working with formulas in Excel
2. Absolute and Relative References: Getting familiar with Absolute and relative references Tips & tricks
3. Calculating Value Totals: SUM, MAX, MIN, AVERAGE, COUNT, COUNTBLANK, COUNTA
4. Creating advanced Formula: SUBTOTAL, COUNTIF, SUMIF, VLOOKUP, IF (AND/OR), Nested Functions
5. Tailored Pivots: Pivot Tables, Pivot Charts

Duration: 6 hours/ 1 day

Course Fee: –

Level 3 (Expert) Learning Objectives:

Advanced analysis tools including data linking, data consolidation and outlining and summarising are covered, as are PivotTables, Lookup Functions and some key automation features such as macros. Learn how to import data, create Data Tables and Scenarios for What If analysis, techniques to validate data, and create form controls such as List and Combo Boxes to make data entry easier.

Course details: 

1. Record an Excel macro: Macro Security, Developer Tab
2. Macro execution options: Macro Recorder, Personal Macro Workbook, Executing VBA code by using a button
3. To get familiarised with VBE: Step by step macro execution, VBE window, Properties
4. Programming basics: Reading the programming code, Debugging, name ranges in VBA
5. Create Excel macros via VBA: Create a sub procedure, Input Box, Message Box

Duration: 6 hours/ 1 day

Course Fee: –

 Learning Objectives:

Hand through the process of creating an outstanding presentation. We will design using PowerPoint and make infographics, world maps, graphs, charts, features, processes, introductions about our slides, and many things that are important to a well-prepared presentation.

Course details: 

1. ESSENTIAL KNOWLEDGE – Best presentation practices and useful PowerPoint tricks, including presentation tips that you might not be aware of.

2. SLIDE DESIGN – Learn the slide-by-slide process of how to design your own presentation. Each lesson is devoted to tackling one slide at a time. Follow along and create your own masterpiece just like the one in the preview. PowerPoint 2010 and PowerPoint 2011 MAC tricks also apply.

3. MASTER SLIDES – Learn how to set up, prepare, and create templates in the PowerPoint Slide Master window to create high-quality presentations for companies, clients, and online sales!

4. ADVANCED TRICKS – Learn from dozens of high-quality lessons that teach you important PowerPoint tricks such as setting up the music, video backgrounds, global changes, and more.

Modules:

1. Introduction: Presentation of PowerPoint Interface, Create and save PowerPoint Presentation
2. Insert graphics: Text, shapes, images, SmartArt, tables, graphs, videos
3. Formatting options: Apply background formatting, insert a logo, save a template
4. Print options: Header & footer, printing options
5. Viewing options: Normal, outline, slide sorter, presentations views
6. Transitions: Categories of transitions, durations, sounds
7. Animations: Animation Types, Animation Start Options, animation pane.

Duration: 6 hours/ 1 day

Course Fee: –

 Learning Objectives:

This course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents.

Course details: 

Lesson 1: Organizing Content Using Tables and Charts

Topic A: Sort Table Data

Topic B: Control Cell Layout

Topic C: Perform Calculations in a Table

Topic D: Create a Chart

Topic E: Add an Excel Table to a Word Document (Optional)

Lesson 2: Customizing Formats Using Styles and Themes

Topic A: Create and Modify Text Styles

Topic B: Create Custom List or Table Styles

Topic C: Apply Document Themes

Lesson 3: Inserting Content Using Quick Parts

Topic A: Insert Building Blocks

Topic B: Create and Modify Building Blocks

Topic C: Insert Fields Using Quick Parts

Lesson 4: Using Templates to Automate Document Formatting

Topic A: Create a Document Using a Template

Topic B: Create a Template

Lesson 5: Controlling the Flow of a Document

Topic A: Control Paragraph Flow

Topic B: Insert Section Breaks

Topic C: Insert Columns

Topic D: Link Text Boxes to Control Text Flow

Lesson 6: Simplifying and Managing Long Documents

Topic A: Insert Blank and Cover Pages

Topic B: Insert an Index

Topic C: Insert a Table of Contents

Topic D: Insert an Ancillary Table

Topic E: Manage Outlines

Topic F: Create a Master Document

Lesson 7: Using Mail Merge to Create Letters, Envelopes, and Labels

Topic A: The Mail Merge Features

Topic B: Merge Envelopes and Labels

Topic C: Create a Data Source Using Word

Duration: 6 hours/ 1 day

Course Fee: –

The Accounting for Accounts Clerk is a course where you will learn how Accounting and Administrative work are performed within a company. You will learn the skills and knowledge which employers’ seeks before recruiting or promoting a candidates.

Learning Objectives:

1. Cash Book
2. Bank Reconciliation
3. TDS Return (Calculation & Submission at MRA)
4. Analysis of Cash Book (Income & Expenditure)
5. Vat Return (Exempt, Zero Rated & Taxable Supply)
6. Payroll Calculation (CSG/NSF/LEVY/PRGF/PAYE/OVERTIME)
7. Accounts Payables
8. Accounts Receivables
9. Financial Statement
10. Depreciation
11. Directors’ Account

Duration: 5 Weeks

Course Fee: Rs 8,000

Learning Objectives:

1. Depreciation and Amortisation
2. Accrual Accounting
3. Accounting Cycle
4. Inventory Accounting
5. Deferred Revenune
6. Prepaid Accounting
7. Financial Report
8. Effective Closing of Accounting Period
9. Income Tax Accounting

Requirements:

Duration: 5 Weeks

Course Fee: Rs 10,000

This course has been designed for people who wants to work in the Human Resource and Administrative Department.

Learning Objectives:

Recruitment:

1. Getting my CV ready
2. Preparing myself for an interview
3. Questions to expect/Questions to ask
4. Defining the good profile/Drafting a job description
5. Medium to recruit/Job posting
6. Interview tests/time frame/assessment
7. Interviewing skills- questions not to miss out
8. Offer of employment (tangibles/non tangibles)

Introduction to Workers Rights Act

1. Intro to Workers Rights Act (type of contract, overtime, EOYB, notice period, disciplinary,
   termination, benefits, PRGF, etc.)
2. Basic clauses of contract of employment [working hours, reporting relationship,
   confidentiality, social charges)

Payroll basics

1. General payroll content
2. Overview of social charges in MRU (CSG, NSF, PRGF)
3. Overview of tax: PAYE, LEVY, EDF
4. Monthly and annual return (social charges & tax)
5. Overtime calculation (Workers’ Rights Act)
6. End of year Bonus
7. Bus fare refund/Work from home allowance/Meal allowance/Maternity benefit
8. HRDC procedures

Performance evaluation: Being evaluated and evaluating someone!

1. Preparing to be evaluated/Do your self-evaluation
2. Know your performance management system
3. Know your KPIs (SMART)
4. Getting prepared to evaluate your subordinate
5. Dos and Don’ts as a TL/Manager
6. Set the objectives 

Duration: 5 sessions x 2 hours

Course Fee: Rs 8,000