Thursday, December 14, 2017

IFRS Training in Saudi Arabia, Jeddah, Riyadh, Dammam, Khobar

IFRS Training in Saudi Arabia, Jeddah, Riyadh, Dammam, Khobar

International Financial Reporting Standards
2 Days Training - MasterClass

KEY BENEFITS & TAKEAWAYS

A Detailed refresher on key accounting standards (IFRS Training in Saudi Arabia)

  • Need of IFRS Training in Saudi Arabia
  • Updates on the recent changes in accounting standards
  • Understanding of practical accounting issues
  • Knowledge of difference GAAP vs. IFRS
  • How IFRS Training in Saudi Arabia help streamline processes
  • Know how IFRS Training in Saudi Arabia to format crystal Financial Reporting 
  • Case study discussions on the implementation & applications of reporting concepts


WORKSHOP OVERVIEW | IFRS Training in Saudi Arabia
International Financial Reporting Standards are Standards and Interpretations issued by International Accounting Standards Board (IASB). They comprise of International Financial Reporting Standards (IFRS), International Accounting Standards (IAS), International Financial Reporting Interpretations Committee (IFRIC) Interpretations; and Standing Interpretations Committee (SIC) Interpretations. IFRSs have evolved over the last few years to cater the ever changing complex businesses requirements.

As of now, 41 IAS and 13 IFRS have been issued. Out of the 41 IAS, several of them have been suspended with the passage of time.

Financial accounting and reporting is an integral part of businesses and high quality financial accounting and reporting requires high level of understanding of financial accounting and reporting principles.

This program is designed to cover several basic and complex International accounting standards and international financial reporting standards and hence the program has been split into two days.

The entire program is suited for participants who want to either build their knowledge of IFRS or want to refresh their knowledge about them. There have been several changes in these international accounting standards which will be covered in detail during the session.

The IFRS Training in Saudi Arabia is also effective for people working in multinational companies who, along with local reporting, do reporting under US GAAP, for their parent companies abroad as difference between IFRS and US GAAP will also be covered.

COURSE OUTLINE

Introduction | IFRS Training in Saudi Arabia
  • The conceptual framework for financial reporting
  • IFRS 1: First Time Adoption of IFRS
  • Objective and scope
  • Exemptions and exceptions
  • Presentation and disclosure


Financial Statement Presentation | IFRS Training in Saudi Arabia
  • IAS 1, 7, 34; IFRS 5
  • Components of financial statements
  • Classification issues for statement of financial position
  • Non-current assets held for sale and discontinued operations
  • Presentation in profit or loss and comprehensive income
  • Statement of changes in equity
  • Statements of cash flow


Measuring Financial Performance
  • IAS 8, 24, 33; IFRS 2, IFRS 13
  • Accounting policies, accounting estimates and errors
  • Earnings per share
  • Related party transactions


Tangible Assets
  • IAS 2, 16, 23, 36, 40
  • Inventory measurements
  • Accounting for property, plant and equipment including revaluations
  • Depreciation
  • Borrowing costs
  • Investment properties


Intangible Assets
  • (IAS 38)
  • Recognition criteria
  • Measurement issues
  • Internally developed intangible assets
  • Research and development costs
  • Intangible assets acquired in a business combination
  • Amortization versus impairment


Cash flow statement
  • Identify Cash and Cash Equivalents
  • Classifying Cash Flows as operating, investing and financing
  • Presentation Issues


Liabilities, Provisions and Contingencies
  • IAS 10, 12, 20, 37
  • Recognition criteria for provisions and contingencies
  • Constructive and legal obligations
  • Discounting deferred payments
  • Onerous contracts
  • Events after the reporting period
  • Deferred tax provisions and assets
  • Government grants and assistance


Revenue Recognition
  • IAS 11, 18 (Including Exposure Draft), IFRS 15
  • Recognition issues and the concept of substance over form
  • Measurement of revenue
  • Construction contracts


Leases | IFRS Training in Saudi Arabia
  • IAS 17 (Including Exposure Draft), IFRS 16
  • Lease classification
  • Leases for property
  • Non-property leases


Business Combinations
  • IFRS 3
  • Purchase method
  • Identifying the acquirer
  • Allocating the cost to net assets
  • Recognition and measurement of goodwill
  • Transitional provisions


Consolidations IFRS 10
  • (IAS 27), IFRS 11 (IAS 31), IFRS 12, IAS 28 and IAS 21
  • Determination of control and consolidation of subsidiaries
  • Accounting for associates
  • Accounting for joint ventures
  • Functional currencies
  • Consolidating foreign subsidiaries
  • Foreign currency transactions


Financial Instruments (IFRS 9)
  • Understanding financial instruments
  • Recognitions
  • Classification
  • Treatment and disclosures


This training is available in Saudi Arabia, Jeddah, Riyadh, Dammam, Khobar, Africa, Afghanistan, GCC

Call: +971 55 8400399 | +92 321 8408828

Saturday, December 9, 2017

Fraud Risk Management Training in Nigeria, Lagos

Fraud Risk Management Training in Nigeria

Fraud Training in Nigeria, Lagos

Overview
Fighting Fraud is easier with our Fraud Risk Management Program as Fraud has become a serious concern for both commercial and non-profit organization across the whole world. According to a study by the Association of Certified Fraud Examiners and researchers at Concordia University, over 10 percent of all non-profit organizations / groups fail victim to occupational fraud.



Awareness about fraud and embedding anti-fraud procedures in the system of your organization can have significant impact on the sustainability of your organization in the long term.

This Fraud Risk Management workshop will help you to learn why people commit fraud, how to identify fraud risks, establish an anti-fraud culture and ensure fraud awareness in your organization.

This training course will explain how to build a robust fraud risk management program and how to integrate anti-fraud initiatives in to your fraud risk management program.

Target Audience
The workshop is very useful and beneficial for the following individuals:
  • Chief Executive Officers
  • Chief Information Officers
  • Chief Risk Officers
  • Risk Advisors
  • Risk Managers
  • Internal Auditors
  • Finance Managers
  • Chief Audit Executives
  • Chief Finance Officers
  • Finance Directors
  • Financial Risk Managers
  • Banking and Finance professionals and other professionals
Takeaways
  • Reviewing current trends and new techniques in combating fraud and financial crimes to anticipate future needs
  • Setting effective fraud detection and prevention procedures
  • Improving customer data protection through effective identity theft prevention
  • Eradicating common areas of potential internal frauds
  • Developing a robust fraud awareness program within the organization
  • Identifying and assessing organization’s vulnerability to fraud and financial crimes
  • Establishing a sustainable corporate environment conducive to combating fraud at all levels
  • Exploring the latest technological solutions in combating fraud and financial crimes
  • Discovering the necessary preventive measures taken to combat fraudsters and money launders
  • Utilizing this event to learn, network and benchmark with key players in the industry

Course Outline | Fraud Risk Management Program

 Fraud Risk Management Techniques

  • Statistical Overview of Fraud Problem
  • Explaining Fraud
  • Common Types of Fraud
  • Who Commits Fraud?
  • Reasons Why Auditors’ don’t detect fraud
  • The Fraud Triangle
  • The Fraud Diamond
  • The Red Flags of Fraud
  • Red Flags Case Studies
  • Case Studies relating to fraud triangle and fraud diamond
  • Theft of Intellectual Property
  • FRAUD RISK MANAGEMENT PROGRAM
    • Fraud Risk Program → Components
    • Fraud Risk Assessment → Components
    • Fraud Risk Assessment Framework
    • Conducting Fraud Risk Assessment (Risk assessment tools and matrix)
  • Case Studies → A Real Life Practical Perspective
  • Fraud Prevention Programs - Components
  • Fraud Prevention Check List – A Practical Perspective
  • Fraud Prevention Score Card

Corruption and Fraud

  • Corruption and Bribery Schemes
  • Case Study / Examples of Corruption and Bribery Schemes
  • Building a fraud scheme (thinking like a thief)
  • Fraud Prevention Policy
  • Ethics Programs in Organization
  • Fraud Detection Program → Components
  • Fraud Detection Score Card
  • Handling of Known Fraud Incidents
  • Addressing the Identified Risk
  • Fraud Investigation Program → Components
  • Planning and conducting Fraud Examination
    • Why conduct a fraud examination?
    • What fraud examinations entails?
    • Fraud examination and forensic accounting
    • Fraud examination methodology
    • Develop a fraud response plan
    • Initial response to suspicion or allegations of fraud
    • Planning and conducting formal investigation
    • Structure the investigation to preserve confidentiality

Reporting and Analyzing

  • Interview Theory and Application
  • Characteristics of Successful interview
  • Characteristics of an Effective interviewer
  • Legal Considerations when conducting an interview
  • Elements of conversation
  • The Cognitive interview technique
  • Interview Mechanics
  • Questions Typology
  • Introductory Questions
  • Methodology
  • Interviewing Suspects and Signed Statements
  • Analyzing Documents
  • Obtaining documentary evidence
  • Examining fraudulent documents
  • Handling documents as physical evidence
  • Sources of Expert document examinations
  • Sources of Information
  • Data Analysis and Reporting Tools
  • Digital Forensics
  • Tracing Illicit Transactions
  • Report Writing
  • The importance of writing effective reports
  • Preparation
  • Characteristics of a good report
  • Common reporting mistakes
  • Organization of information
  • Analyzing the reader
  • Outlining
  • Grammatical considerations
  • Report Structure
  • Reporting Documents
  • Visual Aids

This course can be scheduled at your convenience, to request this course please click here.


This course is available for delivery in Nigeria, Africa, Asia, UAE, Kingdom of Saudi Arabia, Bahrain, Qatar, Oman, Kuwait, GCC.

To know more whatsapp +971 55 8400399, email: info@thebscon.com

Friday, December 8, 2017

Excel Dashboard Training in Saudi Arabia, Riyadh, Jeddah, Dammam, Khobar

Excel Dashboard Training in Saudi Arabia, Riyadh, Jeddah, Dammam, Khobar

Build Dashboards in Excel That Persuade, Inform and Engage
Wow your boss and take your career to the next level.

Course Overview | Dashboard Training with MS Excel
A good visualization can communicatethe nature and potential impact of information and ideas more powerfully than any other form of communication. This visual language is used everywhere in the world, from live sports to the news to fitness apps. Even if you think you can’t speak this language, you hear it and understand it every day.

Building good dashboards in excel is quickly becoming a need-to-have skill for managers. If you're not doing it, other managers are, and they're getting noticed for it and getting credit for contributing to the company's success. So, it’s time to learn to speak it, too.

Microsoft Excel Training in Saudi Arabia is an excellent choice for creating and distributing dashboards due to its ease of use and universal availability. It is a tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.

In this comprehensive Excel Dashboard Course you will learn the techniques you can apply in Excel to make killer dashboards that will set your skill level apart from the crowd and enable you to report, communicate, analyze, check and plan quantitative information.

We will teach you how to create amazing interactive Excel dashboards, that update with the click of the Refresh button, or with a simple copy and paste of your new data into your spreadsheet.

Target Audience
·          Anyone who is interested in making effective business Communication through Data using excel.
·          Manager working in any stream who requires to present / Project / Analyse the data
·          Employee whose work is to create reports and present it in Effective Format
·          Corporate Executives
·          Business Analysts
·          Any advance or intermediate Excel user who wants to learn more skills in Excel

Course Benefits
This hands-on training on dashboard reporting in excel will provide you with an extremely advanced toolkit worth of knowledge that will take the design of your reports to the next level. You will be able to present valued information in a more accurate and concise way, which can be updated and interpreted easily to make good decisions.

You will be able to display key trends, comparisons and data graphically and interactively, so that you can see what you need immediately.

This course will help you turn plain and uninspiring information into smart, effective visualizations that powerfully convey ideas.

By applying the rules, we will share with you, you will have the skills to be able to create reports that save loads of time (allowing you to go home early J) and you’ll quickly become known as Excel Data Visualization Stars with reports that are:

·         Quick and easy to update.
·         Fully interactive so the reader can change the view themselves.
·         Easy to read and interpret
·         Professional presentation

Participants should possess moderate level of Excel knowledge to get more out from this course.

Microsoft Excel – Executive Dashboards Training

EXCEL DASHBOARD DESIGN STRATEGIES FOR CREATING ADVANCED SUMMARY AND LOOKUP TABLES:
·          Layout And Organize The Raw Data That Your Excel Dashboards Will Use
·          Aggregation Functions:  Summarize Your Excel Dashboard Data Using SUMIF, SUMIFS, COUNTIF, COUNTIFS, SUM, MAX, MIN, AVERAGE, RANK, SMALL, LARGE...
·          Lookup Your Excel Dashboard Data Using VLOOKUP, MATCH, INDEX, LOOKUP...
·          Search For And Return Entire Data Columns Or Rows For Your Excel Dashboard Using INDIRECT, INDEX, MATCH And String Concatenation
·          Deal With Dates And Time In Your Excel Dashboard Using The TEXT, YEAR, DAY, MONTH, NETWORKDAYS.INTL, NOW, TODAY, TIME, TIMEVALUE, DATEVALUE, DAYS And SECONDS Functions
·          Process Your Worksheet Text In Your Excel Dashboard Using The LEFT, RIGHT, MID, SUBSTITUTE, REPLACE, SEARCH, LEN, TRIM, CLEAN And TEXT Functions
·          Use Advanced String Concatenation To Help Build Your Excel Dashboard Formulas And Displays

EXCEL DASHBOARD DESIGN KEY WORKSHEET LOGIC FUNCTIONS AND OPERATORS
·          Build Logic Decisions Using The Relational Operators: <, >, <=, >=, < >, =
·          Build Logic Decisions Using The IF, AND, OR, IFERROR Logical Functions, Using Choose Functions
·          Use The IS Functions To Detect Cell Inputs And Formula Problems
·          Use Logic In General, Figure Out The Strategies, Build Multiple Decisions, Figure Out Logical Triggers And Use Them In Your Excel Dashboards

USING ADJUSTABLE NAMES AND EXCEL TABLES IN  EXCEL DASHBOARD DESIGN
·          Names That Automatically Adjust To Changing Data Size, The Key To Building Advanced Excel Dashboards
·          Use Excel Table Syntax And Names In Your Excel Dashboard Formulas
·          Build Adjustable Cell And Range Names From Formulas
·          Cell And Range Naming Rules That Aid In Tracking Your Changing Data
·          Design Table, Column And Row Names That Automatically Adjust To Changing Raw Data And Start/Stop Positions Using The INDIRECT,  OFFSET, COUNTA, COUNTIF And MATCH Functions

ADVANCED EXCEL CHARTS FOR DASHBOARD DESIGN
·          Creating A Chart
·          Switching The Row And Column Orientation
·          Changing The Chart Type
·          Adding And Deleting Chart Elements
·          Formatting Chart Elements
·          Understanding Chart Types
·          Creating Combination Charts
·          Creating And Using Chart Templates
·          Charting A Noncontiguous Range
·          Converting A Chart To A Picture
·          Linking Title Text To A Cell
·          Working With Chart Axes
·          Working With Gridlines
·          Working With Data Labels
·          Combining Different Chart Types In One Chart
·          Creating Custom Markers
·          Creating Miniature Charts Suitable For Dashboards
·          Using Sparklines
·          Target Vs Actual Charts
·          Waterfall Charts
·          Mix Drawing Shapes With Charts To Produce Advanced Excel Dashboards

EXCEL DASHBOARD DESIGN STRATEGIES FOR CREATING VARIOUS SPEEDOMETER STYLE GAUGES
·          Layout And Build The Formulas And Tables That Your Speedometer Style Charts Will Use
·          Create And Format The Pie Charts Turning Them Into Speedometer Style Gauges
·          Combine Pie Charts With Doughnut Charts and Drawing Shapes To Create  Speedometer Style Gauges

USING PIVOT TABLES EFFECTIVELY FOR DASHBOARD DESIGN
·          Creating A Basic Pivot Table
·          Customizing Your Pivot Table
·          Formatting Numbers
·          Changing Summary Calculations
·          Suppressing Subtotals
·          Hiding And Showing Data Items
·          Sorting Your Pivot Table
·          Producing Pivot Table Views
·          External Data Sources

ENHANCING PIVOT TABLES
·          Grouping Data
·          Working With Field Settings
·          Creating Calculated Field
·          Creating A Calculated Item
·          Using Slicer Tool Effectively For Creating Dashboards
·          Using Powerpivot Feature To Create Report From Multiple Tables

USING PIVOT CHART DISPLAYS IN EXCEL DASHBOARD DESIGN
·          Layout And Organize The Raw Data That Your Pivot Table And Pivot Chart Will Use
·          Construct A Pivot Table For Your Pivot Chart Taking Advantage Of Dynamic Names And Excel Tables
·          Build A Pivot Chart For Your Pivot Table
·          Create Slicers And Timelines That Will Filter Your Pivot Tables And Charts
·          Format Your Pivot Charts, Slicers And Timelines For That Microsoft Excel Dashboard Look
·          Use Conditional Formatting In Your Excel Dashboard Pivot Table
·          Create Running Totals, Ranks... In Your Excel Dashboard Pivot Table

USING CONDITIONAL FORMATTING IN EXCEL DASHBOARD DESIGN
·          Change The Look Of Worksheet Cells Using Conditional Formatting
·          What Is A Conditional Formatting Rule And  Set Them Up
·          Manage Your Conditional Formatting Rules
·          Setup The Logic That Applies Multiple Conditional Formatting Rules To One Cell
·          Use Advanced Logic In Your Conditional Formatting, The Key To Building Advanced Excel Dashboard Displays
·          The Key Conditional Formatting Rules That Will Help You Make Your Excel Dashboards 

EXCEL DASHBOARD DESIGN STRATEGIES FOR BUILDING  STATUS DISPLAYS
·          Use Conditional Formatting To Create Tables That Color Complete Areas Based Upon Logic
·          Use Conditional Formatting To Create Name Lists, Product Lists... That Change Color When Their Logical Criterion Have Been Met In Other Tables
·          Use Conditional Formatting To Create Icon Sets And Data Bars For Dashboard Tables
·          Applying Conditional Formatting In Pivot Table

CHARTLESS VISUALIZATION TECHNIQUES
·          Dynamic Labels
·          Linking Formulas To Text Boxes
·          In-Cell Charting
·          Using Symbols

CREATING INTERACTIVE DASHBOARD COMPONENTS
·          Adding A Scroll Bar To A Data Window
·          Adding Option Buttons To A Chart
·          Using A Spin Button
·          Using A Combo Box Drop-Down Menu
·          Using A List Box Control
·          Using The Check Box Control

SCENARIOS
·          Creating Scenarios
·          Options For Choosing Different Scenarios

DATA VALIDATION
·          Creating Data Validation
·          Working With  List & Dependent List
·          Creating List With Dynamic Ranges
·          Create Formulas In Your Data Validation That Allow It To Adjust To Changing Excel Dashboard Conditions
·          Create Cells That Only Allow Certain Date Ranges To Be Entered
·          Handling Input And Error Alerts

SECURING AND DISTRIBUTING YOUR DASHBOARDS AND REPORTS
·          Securing Access To The Entire Workbook
·          Limiting Access To Specific Ranges
·          Protecting The Workbook Structure
·          Linking Excel Dashboards To Powerpoint
·          Building Navigation Buttons

·          Distributing Your Dashboards Via PDF


This course can be scheduled at your convenience, to request this course please click here.

This course is available for delivery in UAE, Kingdom of Saudi Arabia, Bahrain, Qatar, Oman, Kuwait, GCC.

To know more whatsapp +971 55 8400399, email: info@thebscon.com