Master Gulf accounting: learn online and secure a stable career.

Accordion Content

Microsoft Office 365

 Text Basics

• Typing the text, Alignment of text
• Editing Text: Cut, Copy, Paste, Select All, Clear
• Find & Replace

Text Formatting and saving file

• New, Open, Close, Save, Save As
• Formatting Text: Font Size, Font Style
• Font Color, Use the Bold, Italic, and Underlined
• Change the Text Case
• Line spacing, Paragraph spacing
• Shading text and paragraph
• Working with Tabs and Indents

Working with Objects

• Shapes, Clipart and Picture, Word Art, Smart Art
• Columns and Orderings – To Add Columns to a Document
• Change the Order of Objects
• Page Number, Date & Time
• Inserting Text boxes
• Inserting Word art
• Inserting symbols
• Inserting Chart

Header & Footers 

• Inserting custom Header and Footer
• Inserting objects in the header and footer
• Add a section break to a document

Working with bullets and numbered lists

• Multilevel numbering and Bulleting
• Creating List
• Customizing List style
• Page bordering
• Page background

Tables

• Working with Tables, Table Formatting
• Table Styles
• Alignment option

Styles and Content 

• Using Build- in Styles, Modifying Styles
• Creating Styles, Creating a list style
• Table of contents and references
• Adding internal references
• Adding a Footnote
• Adding Endnote 

Merging Documents 

• Typing new address list
• Importing address list from Excel file
• Write and insert the field
• Merging with outlook contact
• Preview Result
• Merging to envelopes
• Merging to label
• Setting rules for merges
• Finish & Merge options

Sharing and Maintaining Document

• Changing Word Options
• Changing the Proofing Tools
• Managing Templates
• Restricting Document Access
• Using Protected View
• Working with Templates
• Managing Templates
• Understanding building blocks 

Proofing the document 

• Check Spelling as You Type.
• Mark Grammar Errors as You Type
• Setting AutoCorrect Options

Printing 

• Page Setup, Setting margins
• Print Preview, Print 

MS EXCEL

Introduction to Excel

• Introduction to Excel interface
• Understanding rows and columns, Naming Cells
• Working with excel workbook and sheets

 Formatting Excel workbook:

• New, Open, Close, Save, Save As
• Formatting Text: Font Size, Font Style
• Font Color, Use the Bold, Italic, and Underlined
• Wrap text, Merge and Centre
• Currency, Accounting and other formats
• Modifying Columns, Rows & Cells

Perform Calculations with Functions 

• Creating Simple Formulas
• Setting up your formula
• Date and Time Functions, Financial Functions
• Logical Functions, Lookup and Reference
• Functions Mathematical Functions
• Statistical Functions, Text Functions

Sort and Filter Data with Excel

• Sort and filter data
• Using a number filter, Text filter
• Custom filtering
• Removing filters from columns’ conditional formatting

Create Effective Charts to Present Data Visually

• Inserting Column, Pie chart etc.
• Create an effective chart with Chart Tool
• Design, Format, and Layout options
• Adding chart title
• Changing layouts
• Chart styles
• Editing chart data range
• Editing data series
• Changing chart

Analyze Data Using PivotTables and Pivot Charts

• Understand PivotTables, Create a PivotTable
• Framework Using the PivotTable and PivotChart
• Create Pivot Chart from the pivot Table.
• Inserting slicer
• Creating Calculated fields

Protecting and sharing the workbook

• Protecting a workbook with a password
• Allow users to edit ranges
• Track changes
• Working with Comments
• Insert Excel Objects and Charts in Word Documents and PowerPoint Presentation.

Use Macros to Automate Tasks

• Creating and Recording Macros
• Assigning Macros to the worksheets
• Saving Macro enabled workbook

Proofing and Printing

• Page setup, setting print area, Print titles
• Inserting custom Header and Footer
• Inserting objects in the header and footer
• Page Setup, setting margins, Print Preview, Print
• Enable background error checking
• Setting AutoCorrect Options

MS POWERPOINT

Setting Up PowerPoint Environment:

• New, Open, Close, Save, Save As
• Typing the text, Alignment of text
• Formatting Text: Font Size, Font Style
• Font Color, Use the Bold, Italic, and Underlined
• Cut, Copy, Paste, and Select All, Clear text
• Find & Replace
• Working with Tabs and Indents

Creating slides and applying themes

• Inserting new slide
• Changing the layout of slides
• Duplicating slides
• Copying and pasting slide
• Applying themes to the slide layout
• Changing theme color
• Slide background
• Formatting slide background
• Using slide views

Working with bullets and numbering

• Multilevel numbering and Bulleting
• Creating List
• Page bordering
• Page background
• Aligning text
• Text directions
• Columns option

Working with Objects

• Shapes, Clipart and Picture, Word Art, Smart Art
• Change the Order of Objects
• Inserting slide header and footer
• Inserting Text boxes
• Inserting shapes, using quick styles
• Inserting Word art
• Inserting symbols
• Inserting Chart

Hyperlinks and Action Buttons

• Inserting Hyperlinks and Action Buttons
• Edit Hyperlinks and Action Button
• Word Art and Shapes

Working With Movies and Sounds

• Inserting Movie from a Computer File
• Inserting Audio file
• Audio Video playback and format options
• Video options, Adjust options
• Reshaping and bordering Video

Using SmartArt and Tables

• Working with Tables, Table Formatting
• Table Styles
• Alignment option
• Merge and split option
• Converting text to smart art

Animation and Slide Transition

• Default Animation, Custom Animation
• Modify a Default or Custom Animation
• Reorder Animation Using Transitions
• Apply a Slide Transition, Modifying a
• Transition, Advancing to the Next Slide

Using slide master

• Using slide master
• Inserting layout option
• Creating custom layout
• Inserting place holders
• Formatting place holders

Slide show option

• Start slide show
• Start show from the current slide
• Rehearse timing
• Creating a custom slide show

 Proofing and Printing

• Check Spelling as You Type
• Setting AutoCorrect Options
• Save as Video
• Save as JPEG files
• Save as PowerPoint Show file
• Print Preview, Print

Introduction to Accounting

Key Accounting Terminologies | Understanding Accounting: Event and Transaction | Bookkeeping vs. Accounting | Role of Stakeholders in Business | Important Business Terminologies

Types of Business Entities

Sole Proprietorship | Partnership | Company | Formalities and Procedures for Establishing Each Entity

Accounting Principles and Concepts

Capital and Revenue Transactions | Generally Accepted Accounting Principles (GAAP) | Capital and Revenue Expenditure | Deferred Revenue Expenditure | Capital and Revenue Receipt | Accounting Concepts and Conventions | Double Entry System of Bookkeeping

Classification and Rules of Accounts

Account Definition | Classification of Accounts: Assets, Liabilities, Equity, Revenue, and Expenses | Debit and Credit: Traditional and Modern Rules

Journal and Ledger

Understanding the Journal: Purpose and Preparation | Ledger: Posting and Balancing | Trial Balance: Purpose and Preparation

Cash Book and its Types

Types of Cash Books: Simple, Two-column, Three-column | Understanding Discounts in Cash Book | Day Book Preparation Using Google Sheets

Depreciation and Its Impact

Definition of Depreciation and Its Causes | The Necessity of Charging Depreciation | Factors Considered for Depreciation Calculation | Methods of Depreciation (Straight-line, Diminishing Balance, etc.) | Provisions and Reserves

Trial Balance Preparation

Importance of Trial Balance | Steps for Preparing a Trial Balance

Trading and Profit & Loss Account

Trading Account: Definition and Preparation | Profit and Loss Account: Definition and Preparation

Year-End Adjustments

Adjustments in Final Accounts | Handling Prepaid and Outstanding Expenses | Treatment of Depreciation, Provisions, and Reserves

Balance Sheet Preparation

Structure and Format of a Balance Sheet | Preparation of Financial Statements Using Excel

Accounting Documents

Key Accounting Documents and Vouchers | Purpose of Accounting Documents | Filing and Storing Documents: Best Practices

Industrial-Oriented Journal Entry Practice

Practical Journal Entry Practice Using JET Simulation

Introduction to GCC VAT

Overview of VAT | Concept and Importance of VAT | Objectives of VAT |GCC Countries | Member States and VAT Authorities | Implementation Overview | Structure of GCC VAT | Tax Rates | Applicability.

Types of Transactions in GCC VAT

Taxable Transactions | Definition | Scope | Standard Rated Supplies | Application Examples | Key Details |Zero Rated Supplies | Categories | Compliance Requirements.
Exempt Supplies | Non-Taxable Transactions | Key Scenarios | Out-of-Scope Transactions | Non-GCC VAT Transactions | Classification.

Introduction to UAE VAT

UAE VAT System | Framework and Structure | Governing Authority | VAT Basics | Taxable Persons | Key Definitions | Supplies under UAE VAT | Goods and Services | Applicability.

Bookkeeping and VAT Documentation

Bookkeeping for VAT | Importance | Key Practices | Tax Invoices | Contents | Examples.
Credit Notes and Debit Notes | Purpose | Compliance Guidelines | Audit Trail Maintenance | Role in VAT Compliance.

VAT Registration

Types of VAT Registration | Mandatory | Voluntary | VAT Registration Process | Steps | Documentation Required | Registration Thresholds | Criteria | GCC Country-Specific Thresholds.

Input VAT and Output VAT

Input VAT System | Recoverability | Conditions for Claim | Output VAT System | Calculation | Reporting | Calculating VAT Payable | Input-Output Offset | Refund Procedures

Corporate Tax in GCC

Overview of Corporate Tax | Definition | Importance | Corporate Tax Rates | GCC Country Comparisons | Industry-Specific Applications | Economic Impact of CT | Implications on Businesses | Compliance.

 Economic Substance Regulations (ESR)

ESR Overview | Definition | Importance in GCC | ESR in UAE | Notification Process | Filing and Reporting.

Financial Accounting Framework (FAF)

FAF Overview | Definition | Role in UAE VAT | Tax Compliance Using FAF | Reporting | Record Maintenance.

Excise Tax in GCC

Overview of Excise Tax | Definition | Importance | Excise Tax Rates | Products Covered | Compliance Requirements | Filing and Compliance for Excise Tax | Documentation | Payment Procedures.

Reverse Charge Mechanism (RCM)

Definition and Purpose of RCM | Adjustments in RCM | Applications in GCC.

Profit Margin Scheme (PMS)

Overview of PMS | Purpose | Applicability in GCC | Adjustments in PMS | Compliance Requirements | Record-Keeping Standards.

Advance Receipts and Adjustments

Systems for Managing Advance Receipts | Importance | GCC VAT Implications | Adjustments and Compliance in Advance Receipt Systems | Filing Process | Documentation Standards

VAT 201 Filing

VAT 201 Filing Practical Assignment

Penalties Under UAE VAT

Penalties Under UAE VAT

Corporate Income tax

VAT 201 Filing

Level 1:

Introduction to Tally Prime
Overview of Tally Prime I Installing Tally I Working in Education Mode

Company Creation and Configuration
Creating, Altering, and Deleting a Company I Company Features and Configuration I Practice Question

Accounting Masters – Tally SET 1
Ledger Creation, Alteration, Display, Deletion I Navigation in Tally (Top, Right), Switch To, Go To I Introduction to Chart of Accounts I Master Creation: Ledger, Group (Single and Multiple) I Group Creation, Alteration, Deletion

Inventory Masters
Inventory Master Creation I Alteration and Deletion of Inventory Group, Inventory Category I Unit of Measure, Stock Item, Location I Sub Group, Sub Category in Inventory

Accounting Vouchers

Overview of Accounting Vouchers I Contra, Receipt, Payment, Journal Vouchers I Sales, Purchase, Debit Note, Credit Note I Creation, Alteration, and Deletion of Accounting Vouchers

Practice
Assignments for Ledger, Group, and Voucher Creation

Level 2:

Bill-wise Allocation
Understanding Bill-wise Allocation I Bill-wise Allocation of Sundry Debtors and Sundry Creditors

Banking
Bank Reconciliation I Deposit Slip Printing I Bank Payments, Payment Advice I Cheque Numbering in Tally

MIS & Reports
Introduction to Management Information System (MIS) I Dashboard in Tally 4.0 I Adding, Altering, and Deleting Dashboard Tiles I Generating MIS Reports

Data Security
Activation of Security Control in Tally I Creation of Security Levels and Passwords I Tally Vault, Creation of Users I Backup and Restore

Inventory Management
Stock Summary, Godown Transfer I Stock Allocation, Ageing Report

Additional Features in Tally
Credit Limit, Zero Value Voucher I Actual and Billed Quantity Column I Separate Discount Column, Additional Cost of Purchase I Sales Invoice Logo, Banking Details in Invoice I Voucher Class Settings

Batch-wise Details Management
Batch-wise Details in Inventory I Expiry Date Reports I Batch Creation of Stock, Setting Manufacturing & Expiry Dates

Price List

Creating Price Lists in Tally I Setting Prices for Different Stock Items

Purchase and Sales Order Processing
Quotation, Purchase Order, Receipt Note I Rejection Out, Debit Note, Reorder Level I Sales Order, Delivery Note I Rejection In, Credit Note I Outstanding and Pending Reports I

Practice
• Assignments for Practice on  Level 2

Level 3:

Cost Centre and Budget Creation
Creation of Cost Centre and Cost Category I Predefined Cost Centre I Budget Creation and Variance Analysis

Interest Calculation
Debtors and Creditors Interest Calculation I Bank Loan Interest Calculation

Manufacturing in Tally
BOM (Bill of Materials), Standard Price Setting I  Manufacturing Voucher Creation I Additional Cost Management

Multi-currency
Non-accounting Vouchers I Forex Conversion I Generating and Printing Reports

Introduction to UAE VAT
VAT in Tally Prime
Company Creation and VAT Activation I VAT Master Creation I Inward and Outward Supply of Goods/Services I Domestic, Intra, and Outside GCC Reports

VAT Entries
Purchase and Sales of Goods/Services Entries with VAT I Fixed Asset Process and Additional Expense on Purchase VAT I Service Entry, RCM Transactions in VAT I Advance Receipt and PMS Transactions

Import Transactions
VAT Paid to Customs Report Transactions I Tax Payment Reconciliation I

Final Project
Implementing VAT in a Real-world Scenario I Full Project Implementation with VAT in Tally Prime

Introduction to QuickBooks
Types of QB, Login, Company Creation I Navigation, Toolbar Customization I Company and Tax Settings I

Chart of Accounts in QB
Chart of Accounts Overview I Trial Balance Report I Item Creation, Edit, Opening Balance Equity

Depreciation
 Fixed Asset Creation I Fixed Asset Depreciation I Accrued Depreciation

Customers in QB
Customer Management (Create, Edit, Import, Inactivate) I Recurring Templates, Statements

Suppliers in QB
Supplier Management (Create, Edit, Import, Inactivate) I Batch Actions

Bills and Invoice Creation in QB
Purchase Bills I Sales Invoices I VAT Treatments

Import and Export Process in QB
RCM Process I Import and Export Processes

Journal and Expense Transactions in QB
Journal and Expense Transactions

PO Process in QB
Detailed PO Process

Estimate Process in QB
Detailed Estimate Process

AR and AP in QB
AR Process I AP Processes

Transfer and Deposit Methods in QB
Bank Deposits I Fund Transfers

Credit Note Transactions in QB
Detailed Credit Note Transactions

Debit Note Transactions in QB
Detailed Debit Note Transactions

Credit Card Transactions in QB
CC Expenses I CC Journals I CC Bill Payments

Project Transactions in QB
Project Creation, Invoices, Reports I Project Transactions in Different Business Natures

Multi-Currency Transactions in QB
Multi-Currency Management I Multi-Currency Bills and Invoices

Adjusting Inventory in QB
Inventory Adjustments I Inventory Allocation

Payroll Transactions in QB
Payroll Setup Processing I Tax Reporting

Budgeting in QB
Budget Creation, Monitoring I  Budget Forecasting

Sales Receipt and Refund Receipt in QB
Sales Receipts I Refund Receipts

Delayed Credit and Delayed Charges in QB
Delayed Credit and Charges

BRS in QB
Bank Reconciliation

Paydown Credit Card Transactions
Paydown Credit Card Processes

VAT 201 in QB
VAT 201 Bills and Invoices I VAT 201 Details, Tax Setup

Invoice Settings in QB
Invoice Customization

Reports in QB
Financial Reports  I  Customization

Asset Schedule & Task Assignment
Asset Schedule  I Workflows

Security Setup in QB
User Management  I Security

Automatic Backup and Restore
Backup and Restore

Final Project Assignment

Payroll Management in Tally | Payroll Management in Zoho

Advanced Excel

introduction to Advanced Excel | Excel sheet Creation, edit, save, Folder Creation | Project 1 [Introduction to Excel

Conditional Formatting & Data Validation

Cell reference, Conditional formatting| Data validation| Important functions in Excel, Remove duplicate values, Hyperlink| Filter, Unique, Sort, SortBY, Sequence, Randarray Functions|

Logical & Statistical functions

Logical functions | Sum & Count if functions| Graphics, Print area setup , Camera tool project| Statistical functions, mathematical functions , Date related functions,  Financial Functions| Dsum, subtotal functions, Text functions, Insert object| Data extraction| Averageif& Averageifs.

Advanced Pivot Table

Classic pivot table and chart| Slicers, timelines and calculated fields| Building hierarchies in pivot tables| Advanced Pivot table data analysis

Advanced Formula for Data Analysis

Custom view, Header and footer, Text to column function| Goal seek, Solver, Scenario manager| Lookup| Project| Match and index function, Consolidating data

Advanced Formula for Data Analysis

Sparkline chart, People graph, Data forecast, Import text file| Mail merge, Consolidating data| Form data, Auditing tool, Web data, Speak cell | Macro, Password protection

Data Preparation and Cleaning

Importing data from various sources. | Handling missing values and duplicates. | Using Text-to-Columns and Flash Fill. | Data validation and error checking for quality assurance.|

Date and Time Analysis

Working with DATE, TIME, NETWORKDAYS, and EOMONTH. | Automating rolling date ranges for dynamic reports. | Calculating time differences in hours, minutes, and seconds. | Custom formatting for date and time (e.g., “MMM-YYYY”). | Dynamic date ranges and custom date logic with WEEKNUM, WORKDAY.INTL

Power Query (Get & Transform)

Importing and cleaning data from various sources| Merging and appending queries| Advanced filtering and transforming data

Introduction to Dashboard Design

Understanding the importance of dashboards | Planning a dashboard project| Data visualization best practices| Advanced Charts