ACCOUNTING MENTORSHIP/SKILLS ACQUISITION CENTER
TRAINING REGISTRATION FORM
PASAC 101: MENTORSHIP/JOB PLACEMENT TRAINING (FULL-TIME-3 MONTHS
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 Old Accountants and Professionals who needs a Refresher Practical Course because they have left Practice for 6 years. It is also organized for Fresh Graduates 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.
JOB PLACEMENT:
Before a mentee can benefit from this program, he/she must have completed the signed program duration and paid all fees. At the completion of the program all Mentees will write Assessment tests and those who passed will be recommended for employment. Any participants who passed through PRESTHER ROYAL CONCEPT with all seriousness will get a job within record time of completion of the program. PRESTHER ROYAL CONCEPT:
- Will guide you and teach you on how to write a professional and a convincing CV
- Will help you get job vacancies every week,
- Will introduce you to valuable connections and networks within Accounting Profession.
- Will help you to setup your jobs profiles in over 10 job websites in Nigeria,
- Will Introduce you to job verting Websites and Companies,
- Will recommend you to employers of labour in Nigeria.
COURSE FEE: N250,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:
- Cash Book
- Double Column Cash Book and Ledgers
- Three Column Cash Book
- Petty Cash Book
- Purchase Day Book
- Sales Day Book
- Bank Reconciliation Statement
- Bank Account Ledger Preparation
- Monthly Expense Account
- Staff Payroll
- Individual Staff Salary Breakdown for Tax Purposes
- Cash Flow Projections
- Trial Balance
- Income Statement
- Financial Statement
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:
- Formulas
- Formatting of Cells (Inserting Rows and Columns)
- Autofill
- Borders (Table Formatting)
- Linking Excel Sheet
- Cell Protection
- Removing of Duplicate Data
- Conditional Formatting
- Splitting and Hiding of Cell
- Inserting of Graph, Bar Chart, Pie Chart, Scatter Diagram and Table
- Find & Select
- Filter & Sorting
- Recurring of Dates
- Currency Symbol
- Numbers, Percentage and Fractions
- Date and Time Formatting
- Text Wrap & Merge
- Labelling of Charts
- View (Page Break)
- Cell and Sheet protection
- 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:
- Chart of Accounts
- Setting up of Companies
- Customers Management
- Inventory Management
- Suppliers Management
- Sales Management
- Purchase Management
- Cash Management
- Write Off Customer Debt
- Bank/Cheque Management
- Reconciliation
- Dishonoured cheque
- Cost Management
- Liabilities Management
- Assets Management
- Depreciation
- Taxation
- Value Added Tax (VAT)
- Withholding Tax (WHT)
- Company Income Tax (CIT)
- Education Tax (EDT)
- Prepayment
- Payroll Management
- Capital/Equity
- Report Generation
CLICK ON WHATSAPP BELOW TO REGISTER
Whatsapp
CLICK TO PREVIEW TRAINING VIDEOS
Telegram
SHARE
Facebook
Linkedin
Instagram
Twitter
PASAC 102: MENTORSHIP/JOB PLACEMENT 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.
JOB PLACEMENT:
Before a mentee can benefit from this program, he/she must have completed the signed program duration and paid all fees. At the completion of the program all Mentees will write Assessment tests and those who passed will be recommended for employment. Any participants who passed through PRESTHER ROYAL CONCEPT with all seriousness will get a job within record time of completion of the program. PRESTHER ROYAL CONCEPT:
- Will guide you and teach you on how to write a professional and a convincing CV
- Will help you get job vacancies every week,
- Will introduce you to valuable connections and networks within Accounting Profession.
- Will help you to setup your jobs profiles in over 10 job websites in Nigeria,
- Will Introduce you to job verting Websites and Companies,
- Will recommend you to employers of labour in Nigeria.
COURSE FEE: N300,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:
- Cash Book
- Double Column Cash Book and Ledgers
- Three Column Cash Book
- Petty Cash Book
- Purchase Day Book
- Sales Day Book
- Incomplete Account
- Bank Reconciliation Statement
- Bank Account Ledger Preparation
- Monthly Expense Account
- Staff Payroll
- Personal Income Tax
- Individual Staff Salary Breakdown for Tax Purposes
- Element of a good Payroll system
- Sections of a good Payroll system
- What is PAYE
- What is withholding Tax
- What’s Joint Tax Board
- Value Added Tax (VAT)
- Cash Flow Projections
- Cash and Stock Auditing
- Internal Controls
- Cash and Bank Analysis
- Branches of Accounting
- Loan Repayment Plan
- Cash Flow Projections
- Trial Balance
- Income Statement
- Statement of Financial Position
- 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:
- Formulas
- Formatting of Cells (Inserting Rows and Columns)
- Autofill
- Borders (Table Formatting)
- Linking Excel Sheet
- Cell Protection
- Population Statistics
- Removing of Duplicate Data
- Conditional Formatting
- Splitting and Hiding of Cell
- Inserting of Graph, Bar Chart, Pie Chart, Scatter Diagram and Table
- Find & Select
- Filter & Sorting
- Recurring of Dates
- Currency Symbol
- Numbers, Percentage and Fractions
- Date and Time Formatting
- Text Wrap & Merge
- Labelling of Charts
- View (Page Break)
- Cell and Sheet protection
- Total and Sub-total
- Designing of Invoice & Receipt
- Loan Repayment Plan
- Application of Excel to Prepare Books of Accounts:
- 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:
- Chart of Accounts
- Setting up of Companies
- Customers Management
- Inventory Management
- Suppliers Management
- Sales Management
- Purchase Management
- Cash Management
- Write Off Customer Debt
- Bank/Cheque Management
- Reconciliation
- Dishonoured cheque
- Costs Management
- Liabilities Management
- Assets Management
- Depreciation
- Taxation
- Value Added Tax (VAT)
- Withholding Tax (WHT)
- Company Income Tax (CIT)
- Education Tax (EDT)
- Prepayment
- Payroll Management
- Capital/Equity
- 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
CLICK ON WHATSAPP BELOW TO REGISTER
Whatsapp
CLICK TO PREVIEW TRAINING VIDEOS
Telegram
SHARE
Facebook
Linkedin
Instagram
Twitter
COURSE FEE: N250,000
COURSE OUTLINE
A. PRACTICAL ACCOUNTING PRINCIPLES AND PROCEDURES TRAININGS
PASAC 103: CONSULTANCY/MENTORSHIP/ APPRENTICESHIP (FULL-TIME-12 MONTHS)
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 Old Accountants and Professionals who needs a Refresher Practical Course because they have left Practice for 6 years. It is also organized for Fresh Graduates 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: N350,000
A. SAGE 50 AND QUICKBOOKS – DESKTOP
B. CLOUD ACCOUNTING – SAGE 50 AND QUICKBOOK
COURSE OUTLINE:
- Setting up of Companies
- Chart of Accounts
- Customers Management
- Inventory Management
- Suppliers Management
- Sales Management
- Purchase Management
- Cash Management
- Bank/Cheque Management
- Costs Management
- Liabilities Management
- Assets Management
- Taxation
- Value Added Tax (VAT)
- Withholding Tax (WHT)
- Company Income Tax (CIT)
- Education Tax (EDT)
- Payroll Management
- Capital/Equity
- istribution Company Implementation
- Purchase Management
- Sales Management
- Manufacturing Accounting
- Manufacturing Company Implementation
- Inventory Management
- Production Management
- Construction Accounting
- Contract Accounting
- Project Accounting
- Departmental Accounting
- NGO
- Implementation
- Sales of Accounting Software
- Training
- Networking
- Installation of Sage 50 and QuickBooks
- Proposals and Quotation
- Field Practical Experience
- Report Customization
- Report Generation
C. PRACTICAL ACCOUNTING PRINCIPLES AND PROCEDURES TRAINING
COURSE OUTLINE FOR CONSULTANCY
- Double Column Cash Book and Ledgers
- Three Column Cash Book
- Petty Cash Book
- Purchase Day Book
- Sales Day Book
- Bank Reconciliation Statement
- Bank Account Ledger Preparation
- Monthly Expense Account
- Incomplete Records
- Staff Payroll
- Individual Staff Salary Breakdown for Tax Purposes
- Cash Flow Projections
- Cash and Stock Auditing
- Internal Controls
- Trial Balance
- Income Statement
- Financial Statement
- Warehouse Accounting
- Cash and Bank Analysis
- Earned and Unearned Income
- Branches of Accounting
- Supply Chain Management
- Escrow Accounting
- Financial Inclusion
- Year/Month End Closing Entries
- Branch Accounting
- Pre and Post incorporation Expenses
- Financial Reporting
- Interpretation of Financial Statement
- Manual VS Computerized Accounting
D. APPLICATION OF EXCEL IN PRACTICAL ACCOUNTING TRAINING
COURSE OUTLINE:
- Formulas
- Formatting of Cells (Inserting Rows and Columns)
- Autofill
- Borders (Table Formatting)
- Linking Excel Sheet
- Cell Protection
- Removing of Duplicate Data
- Conditional Formatting
- Splitting and Hiding of Cell
- Inserting of Graph, Bar Chart, Pie Chart, Scatter Diagram and Table
- Find & Select
- Filter & Sorting
- Recurring of Dates
- Currency Symbol
- Numbers, Percentage and Fractions
- Date and Time Formatting
- Text Wrap & Merge
- Labelling of Charts
- Pivot Table
- View (Page Break)
- Cell and Sheet protection
- Total and Sub-total
- Designing of Source Documents
- Designing of Stock Taking Sheet
- Loan Repayment Plan
- Application of Excel to Prepare Books of Accounts
- Auxiliary Books of Accounts
CLICK ON WHATSAPP BELOW TO REGISTER
Whatsapp
CLICK TO PREVIEW TRAINING VIDEOS
Telegram
SHARE
Facebook
Linkedin
Instagram
Twitter