Basics of Hardware and Software | MS-EXCEL- An introduction | Managing workbook and cell reference | Number and conditional formatting | Working with formulas | Logical Functions | Data validation and financial functions | Chart | Data Extraction | Pivot Table and Chart | MS- WORD 2016 | Working with MS WORD | POWER POINT-2016 | Working with POWER POINT | MS WORD | EXCEL | POWERPOINT Practice sessions.
Basics of Hardware and Software | MS-EXCEL- An introduction | Managing workbook and cell reference | Number and conditional formatting | Working with formulas | Logical Functions | Data validation and financial functions | Chart | Data Extraction | Pivot Table and Chart | MS- WORD 2016 | Working with MS WORD | POWER POINT-2016 | Working with POWER POINT | MS WORD | EXCEL | POWERPOINT Practice sessions.
Introduction | Accounting terms
Accounting | Event and transaction | Book keeping and accounting | Stakeholders in business | Important business terms
Capital and revenue transactions | Accounting principles
Capital and revenue expenditure | Capital and revenue receipt | Accounting concepts and conventions | Double entry system of book keeping
Account | Traditional and modern rules
Account | Classification of account | Debit and credit | Traditional and modern rules relating accounts
Journal
What is journal | Journal preparation
Ledger | Trail balance
What is ledger | Ledger posting | Ledger balancing
Cash book and its types
Types of cash book and discount
Bank reconciliation statement
Depreciation
Depreciation and its causes | Needs for charging depreciation | Factors considered for depreciation | Methods of depreciation.
Inventory valuation
FIFO | LIFO
Trail balance
Trail balance preparation
Trading and profit and loss account
Trading account and its preparation | Profit and loss account and its preparation
Yearend adjustment entries
Adjustments regarding final accounts
Balance sheet
Preparation of balance sheet | Problems of final accounts
Accounting Introduction | Terms | Expenditures | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Introduction to accounting | Basic accounting terms | Expenditures and Its Types | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Accounting Concepts | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Accounting concepts | Different Accounting Concepts | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Accounting Rules | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Types of Accounts | Traditional and Modern Rules of Accounting | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
JET | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Preparation of Journal | Journal Entry Test (JET) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Ledger & Cash Book | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Ledger | Ledger Posting and Balancing | Cash Book | Types of Cash Books | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Trail balance, Adjustments | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Trail Balance | Format and preparation of trail balance | Adjustments | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Final accounts | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Preparation of Final accounts | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Introduction to Tally Prime | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Installing Tally | Tally Introduction | Types of Licence in Tally Prime | Activation & Deactivation of Licence | Work in Education Mode | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Company Creation | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Company Creation | Alteration| Shut Company | Select Company | Delete Company | Company Features | Company Configuration | Ledger Creation | Alteration | Display | Delete(Single & Multiple) | Navigation(top,right) | Swich to | Go to | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Chart of Accounts | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Introduction to Chart of Accounts| Master Creation- Ledger | Group- Both Single and Multiple – Deletion | Alteration | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Inventory Master | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Creation- Alteration – Deletion Of -Inventory Group | Inventory Category | Unit | Stock Item | Location | Sub Group | Sub Category | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Practice | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Vouchers- Recording and Maintaining Accounting Transactions | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Voucher | Voucher Creation | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Bill Wise Allocation & Practice Question Including All Completed Portions | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Bill Wise Allocation of Sundry Debtors and Sundry Creditors | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Banking | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Banking – Cheque Printing| Deposit Slip Printing | Bank Payments | Payment Advise | BRS- Manual and Auto | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Reports Generation | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Generating reports in tally | MIS Reports Generation | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Data Security | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Data Security- Backup | Restore | Activation of Security Controll in Tally | Creation of Security Levels | Creation of Passwords for Company | Activation of Company Vault | Auto Login | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
LEVEL 1 EXAM
|
Introduction to UAE VAT | Understanding VAT | Supplies under UAE VAT | Place of Supply | Date of supply | Tax Payable | Registration | Maintenance of Account | Tax Return | Penalties | GCC VAT using Tally Prime
Introduction to Excel
Introduction | Editing sheet | Formatting | Project1
Worksheet view
Viewing worksheet | Filling series | Flash fill
Conditional formatting | Data validation
Conditional formatting- new rule | Data validation
Lookup and cell reference
VLOOKUP | HLOOKUP | Cell reference
Important functions in Excel
Remove duplicate values | Hyperlink | Important functions in excel
Logical functions | sum and count functions
Logical functions | sum | sumif | sumifs | count | countif | countifs
Working with formulas
Statistical functions and mathematical functions | Date related functions
Text functions
Text functions in excel | Match and index functions
Database functions and subtotal functions
Dsum | dcount | Subtotal functions
Classic pivot table and chart
Chart element | Pivot table and pivot chart
Data extraction
Filter and advanced filter
Graphics and insert object function
Custom view | Graphics | Insert object
Print area setup
Header and footer | Print area setup | Text to column function
Important tools in excel
Form data | Auditing tool | Web data
Goal seak | Solver | Scenario manager
Speak cell | Camera tool | Sparkline chart
People graph | Data forecast | Import text file
Mail merge | Consolidating data
Macro | Password protection
©2024 Skillspark. All rights reserved
| Website designed & Developed by Redwet Solutions