TRAINING

DSCN0154
TRAINING REGISTRATION FORM

COURSE OBJECTIVES:

The program is organized to help Nigerian Graduates to bridge the gap between the University classroom and your place of work. It is organized for Fresh Graduates and Corps Members and early Professionals within 4 years of their graduation in the field of Accounting and other Business related Courses like Banking, Finance, Business Admin. etc This training will give you the practical experience you need to work as an Accountant and other Roles in any Organization. At the end of the training, participants will be able to scale through the hassles of passing interviews and get their dream jobs seamlessly. Besides they will be able to perform Accountant’s roles and other responsibilities with ease.

It is a Full-Time Program and it runs from Monday to Friday

COURSE FEE: N100,000

COURSE OUTLINE

A. PRACTICAL ACCOUNTING PRINCIPLES AND PROCEDURES TRAININGS

This course will teach you about the principle and procedures in Accounting and the practical application of the following Books and ledgers in the corporate world Participants will be given physical copies during practical sessions

TOPICS:

  1. Cash Book
  2. Double Column Cash Book and Ledgers
  3. Three Column Cash Book
  4. Petty Cash Book
  5. Purchase Day Book
  6. Sales Day Book
  7. Bank Reconciliation Statement
  8. Bank Account Ledger Preparation
  9. Monthly Expense Account
  10. Staff Payroll
  11. Individual Staff Salary Breakdown for Tax Purposes
  12. Cash Flow Projections
  13. Trial Balance
  14. Income Statement
  15. Financial Statemen

B. APPLICATION OF EXCEL IN PRACTICAL ACCOUNTING TRAINING

 This course will prepare you on Intermediate Excel which is a prerequisite you needed to enroll for Data Analytic class. Besides this, you will be exposed to application of Excel in Accounting and Business Management. How to use Excel to create different types of Ledger, Postings, Reports, Business Analysis and different Models.

 TOPICS:

  1. Formulas
  2. Formatting of Cells (Inserting Rows and Columns)
  3. Autofill
  4. Borders (Table Formatting)
  5. Linking Excel Sheet
  6. Cell Protection
  7. Removing of Duplicate Data
  8. Conditional Formatting
  9. Splitting and Hiding of Cell
  10. Inserting of Graph, Bar Chart, Pie Chart, Scatter Diagram and Table
  11. Find & Select
  12. Filter & Sorting
  13. Recurring of Dates
  14. Currency Symbol
  15. Numbers, Percentage and Fractions
  16. Date and Time Formatting
  17. Text Wrap & Merge
  18. Labelling of Charts
  19. View (Page Break)
  20. Cell and Sheet protection
  21. Loan Repayment Plan

C. ACCOUNTING SOFTWARE  –  SAGE50

This course will teach you to how use Sage 50 to manage your organization. You will be taught how to create Companies, Chats of Account, Ledgers, Posting and Report Generation.

TOPICS:

  1. Chart of Accounts
  2. Setting up of Companies
  3. Customers Management
  4. Inventory Management
  5. Suppliers Management
  6. Sales Management
  7. Purchase Management
  8. Cash Management
  9. Write Off Customer Debt
  10. Bank/Cheque Management
  11. Reconciliation
  12. Dishonoured cheque
  13. Cost Management
  14.  Liabilities Management
  15. Assets Management
  16. Depreciation
  17. Taxation
  18. Value Added Tax (VAT)
  19. Withholding Tax (WHT)
  20. Company Income Tax (CIT)
  21. Education Tax (EDT)
  22. Prepayment
  23. Payroll Management
  24. Capital/Equity
  25. Report Generation

 PASAC 103: CONSULTANCY/MENTORSHIP/ APPRENTICESHIP (FULL-TIME-12 MONTHS)

COURSE OBJECTIVES

This program is organized to raise qualified and experienced personnel to fill the existing gap in the Accounting Software Industry. The industry is saddled with quack and fake IT personnel who are causing more havoc than good in Nigeria. At the end of the training, Participants will be able to start their Accounting Software Consulting Firm. In addition, Participants will be able sell, train, setup, implement and support Sage 50 and QuickBooks. You will also know how to install Sage 50 and QuickBooks in a network environment, System Requirements and Networking of Sage 50 and QuickBooks. Besides, Setup Accounting Systems for different types of Organizations and Companies.  It runs from Monday to Friday.

COURSE FEE: N250,000

 A. SAGE 50 AND QUICKBOOKS – DESKTOP

B. CLOUD ACCOUNTING – SAGE 50 AND QUICKBOOK

 

COURSE OUTLINE

  1. Setting up of Companies
  2. Chart of Accounts
  3. Customers Management
  4. Inventory Management
  5. Suppliers Management
  6. Sales Management
  7. Purchase Management
  8. Cash Management
  9. Bank/Cheque Management
  10. Costs Management
  11. Liabilities Management
  12. Assets Management
  13. Taxation
  14. Value Added Tax (VAT)
  15. Withholding Tax (WHT)
  16. Company Income Tax (CIT)
  17. Education Tax (EDT)
  18. Payroll Management
  19. Capital/Equity
  20. Distribution Company Implementation
  21. Purchase Management
  22. Sales Management
  23. Manufacturing Accounting
  24. Manufacturing Company Implementation
  25. Inventory Management
  26. Production Management
  27. Construction Accounting
  28. Contract Accounting
  29. Project Accounting
  30. Departmental Accounting
  31. NGO
  32. Implementation
  33. Sales of Accounting Software
  34. Training
  35. Networking
  36. Installation of Sage 50 and QuickBooks
  37. Proposals and Quotation
  38. Field Practical Experience
  39. Report Customization
  40. Report Generation

C.  PRACTICAL ACCOUNTING PRINCIPLES AND PROCEDURES TRAINING

COURSE OUTLINE FOR CONSULTANCY

  1. Double Column Cash Book and Ledgers
  2. Three Column Cash Book
  3. Petty Cash Book
  4. Purchase Day Book
  5. Sales Day Book
  6. Bank Reconciliation Statement
  7. Bank Account Ledger Preparation
  8. Monthly Expense Account
  9. Incomplete Records
  10. Staff Payroll
  11. Individual Staff Salary Breakdown for Tax Purposes
  12. Cash Flow Projections
  13. Cash and Stock Auditing
  14. Internal Controls
  15. Trial Balance
  16. Income Statement
  17. Financial Statement
  18. Warehouse Accounting
  19. Cash and Bank Analysis
  20. Earned and Unearned Income
  21. Branches of Accounting
  22. Supply Chain Management
  23. Escrow Accounting
  24. Financial Inclusion
  25.  Year/Month End Closing Entries
  26. Branch Accounting
  27. Pre and Post incorporation Expenses
  28. Financial Reporting
  29. Interpretation of Financial Statement
  30. Manual VS Computerized Accounting

D. APPLICATION OF EXCEL IN PRACTICAL ACCOUNTING TRAINING

COURSE OUTLINE

  1. Formulas
  2. Formatting of Cells (Inserting Rows and Columns)
  3. Autofill
  4. Borders (Table Formatting)
  5. Linking Excel Sheet
  6. Cell Protection
  7. Removing of Duplicate Data
  8. Conditional Formatting
  9. Splitting and Hiding of Cell
  10. Inserting of Graph, Bar Chart, Pie Chart, Scatter Diagram and Table
  11. Find & Select
  12. Filter & Sorting
  13. Recurring of Dates
  14. Currency Symbol
  15. Numbers, Percentage and Fractions
  16. Date and Time Formatting
  17. Text Wrap & Merge
  18. Labelling of Charts
  19. Pivot Table
  20. View (Page Break)
  21. Cell and Sheet protection
  22. Total and Sub-total
  23. Designing of Source Documents
  24. Designing of Stock Taking Sheet
  25. Loan Repayment Plan
  26. Application of Excel to Prepare Books of Accounts:
  27. Auxiliary Books of Accounts

PASAC 102: MENTORSHIP/ INTERNSHIP/JOB EXPERIENCE TRAINING (FULL-TIME-6 MONTHS

COURSE OBJECTIVES

This program is organized to help Nigerian Graduate to bridge the gap between the University classroom and the place of work. It is organized for Fresh Graduates and Corps Members and early Professionals within 3 years of their graduation in the field of accounting and other business-related Courses like Banking, Finance, Business Admin. etc It also gives you the tools and broaden the knowledge of how to use Accounting Information Technology to manage organization’s Accounting Department. This training will give you the practical experience you needed to work as an Accountant in any Organization. You will be able to setup Manual and Computerized Accounting System. In addition, you will be able to produce different Management Reports, Interprets and advise Management on the best options to take.

At the end of the training participant will be able to get their dream jobs seamlessly and perform Accountants’ roles and other responsibilities with ease. It is a confidence building program.

It is a Full-Time Program and it runs from Monday to Friday.

COURSE FEE: N150,000

COURSE OUTLINE

A. PRACTICAL ACCOUNTING PRINCIPLES AND PROCEDURES TRAININGS

This course will teach you about the principle and procedures in accounting and the practical application of the following Books and ledgers in the corporate world. Participants will be shown physical copies and will be taken to client’s offices to know how it is done.

TOPICS:

  1. Cash Book
  2. Double Column Cash Book and Ledgers
  3. Three Column Cash Book
  4. Petty Cash Book
  5. Purchase Day Book
  6. Sales Day Book
  7. Incomplete Account
  8. Bank Reconciliation Statement
  9. Bank Account Ledger Preparation
  10. Monthly Expense Account
  11. Staff Payroll
  12. Personal Income Tax
  13. Individual Staff Salary Breakdown for Tax Purposes
  14. Element of a good Payroll system
  15. Sections of a good Payroll system
  16. What is PAYE
  17. What is withholding Tax
  18. What’s Joint Tax Board
  19. Value Added Tax (VAT)
  20. Cash Flow Projections
  21. Cash and Stock Auditing
  22. Internal Controls
  23. Cash and Bank Analysis
  24. Branches of Accounting
  25. Loan Repayment Plan
  26. Cash Flow Projections
  27. Trial Balance
  28. Income Statement
  29. Statement of Financial Position
  30. Cashflow Statement etc

B. APPLICATION OF EXCEL IN PRACTICAL ACCOUNTING TRAININGS  

 This course will prepare you on Intermediate Excel which is a prerequisite you needed to enroll for Data Analytic class. Besides this, you will be exposed to application of Excel in Accounting and Business Management. How to use Excel to create different types of Ledgers, Postings, Reports, Business Analysis and different Models.

TOPICS:

  1. Formulas
  2. Formatting of Cells (Inserting Rows and Columns)
  3. Autofill
  4. Borders (Table Formatting)
  5. Linking Excel Sheet
  6. Cell Protection
  7. Population Statistics
  8. Removing of Duplicate Data
  9. Conditional Formatting
  10. Splitting and Hiding of Cell
  11. Inserting of Graph, Bar Chart, Pie Chart, Scatter Diagram and Table
  12. Find & Select
  13. Filter & Sorting
  14. Recurring of Dates
  15. Currency Symbol
  16. Numbers, Percentage and Fractions
  17.  Date and Time Formatting
  18. Text Wrap & Merge
  19. Labelling of Charts
  20. View (Page Break)
  21.  Cell and Sheet protection
  22.  Total and Sub-total
  23.  Designing of Invoice & Receipt
  24. Loan Repayment Plan
  25. Application of Excel to Prepare Books of Accounts:
  26.  Auxiliary Books of Accounts

C. ACCOUNTING SOFTWARE TRAINING – SAGE 50 AND QUICKBOOKS.  

This course will teach you how to use Sage 50 and QuickBooks to manage your organization. You will be taught how to create Companies, Chats of Account, Ledgers, Posting of transactions and Generate Management Reports and interpretation of Reports.

TOPICS:

  1. Chart of Accounts
  2. Setting up of Companies
  3. Customers Management
  4. Inventory Management
  5. Suppliers Management
  6. Sales Management
  7. Purchase Management
  8. Cash Management
  9. Write Off Customer Debt
  10. Bank/Cheque Management
  11. Reconciliation
  12. Dishonoured cheque
  13. Costs Management
  14. Liabilities Management
  15. Assets Management
  16. Depreciation
  17. Taxation
  18. Value Added Tax (VAT)
  19. Withholding Tax (WHT)
  20. Company Income Tax (CIT)
  21. Education Tax (EDT)
  22. Prepayment
  23. Payroll Management
  24. Capital/Equity
  25. Report Generation

D. ADVANCED EXCEL –  DATA ANALYSTIC 

This program is organized to raise qualified Data Analyst with the ability to analyse Financial, Economic, Banking, Business and Accounting data for Management decisions taking. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

TOPICS:

Section 1 Advanced worksheet Functions

1.1 Introduction

1.2 Understanding excel interface;

1.3 Work with ribbons;

1.4 Most powerful excel dialogue boxes;

1.5 20 hottest excel shortcuts.

Section 2 Data Separation and Data Joining

2.1.      Flash Fill and Auto

2.2.      Delimiters

2.3.      Ampersand

2.4.      Concatenate

Section 3 Cell Reference

3.1.      Relative Cell Reference

3.2.      Absolute Cell Reference

3.3.      Mixed Cell Reference

Section 4 Conditional & Logical Functions

4.1.      Using logical functions

4.2.      Using If and Nested IF Function

Section 5 What-if Analysis 

5.1.      Scenario Manager

5.2.      Goal Seek

5.3.      Solver for Goal Seek

 

Section 6 Pivot Tables and Pivot Charts

6.1.      Using the PivotTable Wizard

6.2.      Using Pivotable and Subtotal

7.3.      Using Calculated Field

6.4.      Using Timeline for Filtering Report

6.5.      Creating Pivot Charts

6.6.      Using Slicers to manipulate PivotTables

Section 7 working with Large Data

7.1.      3D Formular (sum)

7.2.      Data Consolidation

 

Section 8 Lookups functions

8.1.      The VLOOKUP functions

8.2.      The HLOOKUP function

8.3.      INDEX and MATCH function

Section 9 Loan Repayment Schedule

9.1.      Calculating Monthly Payment with PMT function

9.2.      Calculating Payment on Principal with PPMT function

9.3.      Calculating payment on Loan Interest with IPMT function

Section 10 Sorting and Filtering

10.1     Using of advanced sorting and filtering

10.2.    Using Text and Number Filter

Section 11 Advanced list management

11.1.    Using data validation

11.2.    Setting criteria for entry of text, values and dates

11.3.    Creating a dropdown list

Section 12 Auditing Formula

12.1          Auditing Features