All courses

~ Series of System Improvement Workshops & Training ~

Muhamad Al Gamal, SE. Ak, MA, CA.

Potential participants may discuss all about my training by email to:

muhamad_algamal@yahoo.com

 

Training framework

 ceas framework

Accounting System

  • Optimizing Microsoft Excel for Budgeting & Cash Management
  • Optimizing Microsoft Excel for Accounting
  • Optimizing Microsoft Excel for Auditing
  • Optimizing Microsoft Excel for Taxation

Data Mining & Analysis

  • Electronic Audit with Microsoft Excel and Activedata
  • Electronic Audit with Audit Command Language/ACL
  • Interactive Dashboard with Microsoft Excel, Power Pivot and VBA
  • Interactive Dashboard with Microsoft SQL Server Reporting Service/SSRS
  • Business Intelligence Solution with Microsoft SQL Server

Business Monitoring System

  • Designing & Formulating Key Performance Metrics Based on Enterprise Information System
  • Building Business Monitoring Dashboard with Excel

Standard Operating Procedure

  • Increasing Efficiency Through Business Processes Improvement
  • Standard Operating Procedure/SOP for Finance & Accounting
  • Standard Operating Procedure/SOP for Taxation

“Optimizing Microsoft Excel for
Budgeting & Cash Management”

We understand that most of business people so familiar with Microsoft Excel. But, we believe that so many hidden functions in Excel you do not utilize yet. In this workshop, we focus on optimizing your Excel capability to handle the specific tasks in budgeting & cash management.

 Courses Structure

  • Design of financial management system
  • Excel functions for finance jobs
  • Applying Excel on the Activity Based Budgeting
    • Budget baseline
    • Operational budget
    • Cash budget
  • Applying Excel on the cash management
    • Cash in management
    • Cash out management

Who should attend

Relevant persons to budgeting and finance jobs

 

“Optimizing Microsoft Excel for Accounting”

We understand that most of business people so familiar with Microsoft Excel. But, we believe that, so many hidden functions in Excel you do not utilize yet. In this workshop, we focus on optimizing your Excel capability to handle the specific tasks in financial and management accounting.

 Courses Structure

  • Design of financial & management accounting system
  • Excel functions for accounting jobs
  • Applying Excel on the financial accounting
    • Chart of accounts and opening balance
    • Manual and auto journal
    • General and subsidiary ledger
    • Financial reporting
  • Applying Excel on the management accounting
    • Activity Based Costing
    • Cost Volume Profit Analysis

Who should attend

Relevant persons to accounting & finance jobs

 

“Optimizing Microsoft Excel for Audit”

We understand that most of business people so familiar with Microsoft Excel. But, we believe that, so many hidden functions in Excel you do not utilize yet. In this workshop, we focus on optimizing your Excel capability to handle the specific tasks in internal and external audit.

 Courses Structure

  • Design of audit system
  • Excel functions for audit jobs
  • Applying Excel on the performance audit
    • Performance metrics
    • Data collection
    • Information analysis
    • Presentation of findings
  • Applying Excel on the financial audit
    • Data collection
    • Analytical review
    • Test of control
    • Substantive test
    • Information analysis
    • Presentation of findings

Who should attend

Relevant persons to audit jobs

 

“Optimizing Microsoft Excel for Taxation”

We understand that most of business people so familiar with Microsoft Excel. But, we believe that so many hidden functions in Excel you do not utilize yet. In this workshop, we focus on optimizing your Excel capability to handle the specific tasks in taxation.

 Courses Structure

  • Design of taxation system
  • Excel functions for taxation jobs
  • Applying Excel on the tax planning
    • Corporate tax planning
  • Applying Excel on the tax calculation and tax filing
    • Withholding tax
    • Corporate income tax
    • Value added tax
    • Tax reconciliation

Who should attend

Relevant persons to accounting and taxation jobs

 

“Electronic Audit with Microsoft Excel & Activedata”

We understand that most of business people so familiar with Microsoft Excel. But, we believe that, so many hidden functions in Excel you do not utilize yet. In this workshop, we focus on optimizing your Excel plus Activedata to handle the specific audit tasks in the small medium size of data.

 Courses Structure

  • Risk, internal control & audit in the information system/technology environment
  • Electronic audit system
  • Database management system/DBMS
  • Computer assisted audit
    • Audit plan
    • Field work
    • Data & information analysis
    • Presentation of findings
  • Applying Excel & Activedata on the financial audit
    • Audit on the accounting cycle
    • Audit on the revenue cycle
    • Audit on the account payable cycle

Who should attend

Relevant persons to audit jobs

 

“Electronic Audit with Audit Command Language/ACL”

We understand that most of auditor, either internal and external, still doing audit manually, even in the IS/T environment. Even though, using an electronic audit tool will make your audit job more efficient and effective. In this workshop, we focus on optimizing ACL to handle the specific audit tasks in the big size of data.

 Courses Structure

  • Risk, internal control & audit in the information system/technology environment
  • Electronic audit system
  • Database management system/DBMS
  • Computer assisted audit
    • Audit plan
    • Field work
    • Data & information analysis
    • Presentation of findings
  • Applying Audit Command Language on the financial audit
    • Audit on the accounting cycle
    • Audit on the revenue cycle
    • Audit on the account payable cycle

Who should attend

Relevant persons to audit jobs

 

“Interactive Dashboard with Microsoft Excel, Power Pivot & VBA”

We understand that most of business people so familiar with Microsoft Excel. But, we believe that, so many hidden functions in Excel you do not utilize yet. In this workshop, we focus on optimizing your Excel capability to handle the specific tasks in data analytics & visualization.

 Courses Structure

  • Determining objective of analytics
  • Database management system/DBMS
  • Knowing your data
  • Design of dashboard system
  • Analytical & visual features in Microsoft Excel
  • Deploying dashboard system to users
    • Automating dashboard
    • Packaging dashboard
    • User management
  • Applying interactive dashboard on the set of data & information
    • Accounting dashboard
    • Sales & marketing dashboard
    • Executive dashboard

Who should attend

Relevant persons to data analytics and visualization

 

“Interactive Dashboard with SQL Server Reporting Service/SSRS”

  We understand that most of database users so familiar with Microsoft SQL Server. But, we believe that, so many hidden functions in SQL Server you do not utilize yet. In this workshop, we focus on optimizing your SQL Server capability to handle the specific tasks in data analytics & visualization.

Courses Structure

  • Determining objective of analytics
  • SQL Server Database management system/DBMS
  • Knowing your data
  • Design of dashboard system
  • Analytical & visual features in SQL Server Reporting Service
  • Deploying dashboard system to users
    • Packaging dashboard
    • User management
  • Applying interactive dashboard on the set of data & information
    • Accounting dashboard
    • Sales & marketing dashboard
    • Executive dashboard

Who should attend

Relevant persons to data analytics and visualization

 

“Business Intelligence/BI Solution with Microsoft SQL Server”

We understand that most of database users so familiar with Microsoft SQL Server. But, we believe that, so many hidden functions in SQL Server you do not utilize yet. In this workshop, we focus on optimizing your SQL Server capability to build a business intelligence solution.

 Courses Structure

  • Determining objective of business intelligence solution
  • SQL Server Database management system/DBMS
  • Knowing your data
  • Design of BI system
  • Microsoft BI framework
    • Extract, transform & load/ETL process
    • Online analytical processing/OLAP
    • Reporting services
  • BI Features in Microsoft SQL Server
    • Data sources
    • Data sources view
    • Dimension
    • Cubes
  • Applying SQL Server BI Features on the set of data

Who should attend

Relevant persons to data analytics and visualization

 

“Designing Key Performance Metrics
Based on
Enterprise Information System”

Many business people use enterprise information system in doing management tasks. But, we believe that, it’s very few of them utilize the data in the system for the shake of performance management. In this workshop, we focus on enhancing your capability to build key performance metrics based on enterprise information system.

 Courses Structure

  • Determining framework of metrics
  • Enterprise information system/EIS
  • Database management system/DBMS
  • Data mining and analysis
  • Knowing your data
  • Key performance indicators/KPI
    • Financial metrics
    • Non financial metrics
  • Determining metric dimension
  • Designing and formulating key performance metrics based on the set of data & information system
    • Financial metrics
    • Non financial metrics

Who should attend

Relevant persons to performance management jobs

 

“Building
Business Monitoring Dashboard
with Excel”

We understand that most of business people so familiar with Microsoft Excel. But, we believe that, so many hidden functions in Excel you do not utilize yet. In this workshop, we focus on optimizing your Excel capability to handle the specific tasks in monitoring business performance.

 Courses Structure

  • Introduction to dashboard
  • Database management system/DBMS
  • Data mining and analysis
  • Knowing your data
  • Key performance indicators/KPI
    • Financial metrics
    • Non financial metrics
  • Dashboard design for monitoring performance
  • Analytical & visual features in Microsoft Excel
  • Applying interactive dashboard on the set of data & information
    • Financial data
    • Non financial data

Who should attend

Relevant persons to data analytics, visual information and performance management

 

“Increasing Efficiency Through
Business Process Improvement”

To be successful in business, problems are challenges to be overcome. System approach is proven reliable to solve the business problems. It is applied through business process improvement initiatives. In this workshop, we focus on enhancing your capability to improve key business process using conceptual and practical methods.

 Courses Structure

  • System and business process
  • Business process modeling
  • Road map of business process improvement
  • Step 1 – Preparation
  • Step 2 – Process Mapping
  • Step 3 – Process Analysis
  • Step 4 – Designing Improvement
  • Step 5 – Implementation
  • Step 6 – Change Management
  • Step 7 – Continues Improvement
  • Step 8 – Business Process Automation
  • Step 9 – Business Process Navigation

Who should attend

Relevant persons to business process management

 

“Building
Standard Operating Procedure/SOP
for Finance & Accounting”

One of initiatives in business process improvement is building & implementing standard operating procedure/SOP. In this workshop, we focus on enhancing your capability to build and implement SOP in the finance and accounting function.

 Courses Structure

  • Integrated system and business process
  • Business process modeling
  • Policies & procedures
  • Designing control system in finance & accounting process
  • Designing forms and reports
  • Step by step building SOP in the finance & accounting process
    • Budgeting process
    • Acquisition and payment process
    • Sales & collection process
    • Cash management process
    • General accounting process
    • Financial reporting process
  • Change management

 

Who should attend

Relevant persons to finance, accounting & business process management

 

“Building
Standard Operating Procedure/SOP
for Taxation”

One of initiatives in business process improvement is building & implementing standard operating procedure/SOP. In this workshop, we focus on enhancing your capability to build and implement SOP in the taxation function. Taxation SOP is very important not only because of increasing efficiency, but also it must comply with government regulation.

 Courses Structure

  • Integrated system and business process
  • Business process modeling
  • Policies & procedures
  • Designing control system in taxation process.
  • Designing forms and reports
  • Step by step building SOP in the taxation process
    • Value added tax
    • Withholding tax
    • Corporate income tax
    • Tax reconciliation
    • Aligning taxation process to other business process
  • Change management

Who should attend

Relevant persons to taxation, accounting & business process management

 

Leave a Reply

Your email address will not be published. Required fields are marked *