ADFM

ADFM

        BASICS OF COMPUTER

Fundamental Knowledge of Computer
Operating System
Internet
Financial Literacy for Banking Applications

Introduction to Computer

• Definition, It's Structure and parts
• window and Operating system
• Desktop and It's Icons
• Software (MS Office): Latest Versions
• Info about Files and Folders
• Info about various Drives
• Basic Applications Uses

MS-Word

• Table Handling
• Resume Creation
• Advertisement Creation
• Vising Card & Labels Creation
• Using Watermark
• Page Cover & Page Border
• Printing of word document

MS - Excel

• Editing & Managing Workbooks
• Formulas
• Functions & Conditions
• Sheets & Reports Creation
• Pivot Tables & Charts
• Sorting Data
• Lookup (Vlookup/Hlookup)
• Whatif Analysis

MS-PowerPoint

• Creating Presentation
• Slide Show
• Taking Printouts of Presentation/Handouts

Internet

• Creating Email-id and It's various Uses
• How to access Email-Account and Its Details
• Uses of Internet in Various Concepts.

        ADVANCE EXCEL

Overview of the Basics of Excel

• Customizing common options in Excel
• Absolute and relative cells
• Protecting and un-protecting worksheets and cells

Working with Functions

• Writing conditional expressions (using IF & IFERROR)
• Using logical functions (AND, OR, NOT)
• Using lookup and reference functions
• (VLOOKUP, HLOOKUP, MATCH, INDEX)
• VlookUP with Exact Match, Approximate Match
• Nested VlookUP with Exact Match
• VlookUP with Tables, Dynamic Ranges
• Nested VlookUP with Exact Match
• Using VLookUP to consolidate Data from Multiple Sheets

Data Validations

• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on formula for a cell

Working with Templates

• Designing the structure of a template
• Using templates for standardization of worksheets

Advanced Sheets Creation

• Creating Adv. Salary Sheets
• Creating Adv. Marks Sheets (Fail, Compartment)
• Creating Automatic Attendance Sheets
• Linking Salary Sheet with Attendance Sheet
• TAX Calculation

Formatting

• Using auto formatting option for worksheets
• Using conditional formatting option for rows, columns and cells
• and Working With Data Bars, Colour Scales & Icon Sets
• Creating Custom Rules & Managing Rules

        MIS REPORTS

Sorting and Filtering Data

• Sorting tables
• Using multiple-level sorting
• Using custom sorting
• Filtering data for selected view (AutoFilter)
• Using advanced 
• Working with Reports
• Creating subtotals
• Working with Reports
• Multiple-level subtotals
• Creating Pivot tables
• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts
• Consolidating data from multiple sheets and files using Pivot tables
• Using external data sources
• Using data consolidation feature to consolidate data
• Show Value As (% of Row, % of Column, Running Total, Compare with Specific Field)
• Viewing Subtotal under Pivot
• Above) Creating Slicers (Version 2016 & Above)

More Functions

Date and time functions
Text functions
Database functions
Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Special Pasting

• Special Pasting
• Pasting Formulas, Values, as a Link & as a Picture
• Copying Comments, Validations, Column Widths & Formats With Paste Special

Macros

• Relative & Absolute Macros
• Editing Macro's

Whatlf Analysis

• Goal Seek
• Data Tables
• Scenario Manager

Charts

• Using Charts
• Formatting Charts
• Using 3D Graphs -
• Using Bar and Line Chart together Using Secondary Axis in Graphs
• Sharing Charts with PowerPoint / MS Word, Dynamically

  

 TALLY PRIME BASIC

Fundamentals of accounting

• Basic Accounting
• (Types of Accounting, Rules of Accounting, Assets, Liabilities,
• Capital, Payables, Receivables, Debtors, Creditors, Incomes &
• Gaines.. etc)

User Interface and Company Management

• Creating a Company
• Altering and Deleting Company
• Gateway of Tally and User Interface

Ledgers

• Creating Ledgers
• Creating Multiple Ledgers
• Altering and Deleting Ledgers
• Bill wise Debtors and Creditors Ledgers

Groups

• Creating Groups
• Altering and Deleting Groups
• Vouchers
• Contra Voucher (Single Entry Mode/Double Entry Mode)
• Payment Voucher
• Receipt Voucher
• Journal Voucher

Day Book

• Altering and Deleting Transactions
• TALLY PRIME BASIC
• Pre-Allocation of Bills
• Practical Examples
• Cheque Printing
• CTS Cheque Printing System
• Practical Examples

Inventory

• Integrating Accounts and Inventory
• Practical on Stock Group
• Practicals on Godown and Locations
• Practical on Stock Category
• Practical on Units of Measure
• Practical on Stock Items
• Manual Stock Valuation without Inventory

        TALLY PRIME BASIC

Goods and Services Tax (GST)

• Activating Tally in GST
• Setting Up GST (Company Level, Ledger Level or Inventory Level)
• GST Taxes & Invoices
• Understanding SGST, CGST, IGST & UTGST
• Creating GST Masters in Tally

Purchase Voucher with GST

• Updating GST Number for Suppliers
• Practical on Intra-State Purchase Entry in GST (SGST + CGST)
• Practical on Inter-State Purchase Entry in GST (IGST)
• GST Purchase Entry for Unregistered Dealer in Tally
• Reverse Charge Mechanism Entry for GST in Tally

Sales Voucher with GST

• Updating GST Number for Suppliers
• Practical on Intra-State Sales Entry in GST (SGST + CGST)
• Practical on Inter-State Sales Entry in GST (IGST)
• Printing GST Sales Invoices from Tally ERP9 Software

GST Reports and Returns

• GSTR 1 in Tally
• GSTR 1 Return Filing

        TALLY PRIME (ADVANCED)

Billing Features

• Zero-valued entries
• Different Billing and Actual Quantity
• Additional Cost of Purchase Discount Column on Invoices

Purchase Order Processing

• Purchase Order Voucher with Examples 
• Receipt Note (Inventory) with Examples
• Rejection-Out Voucher with Examples

Sales Order Processing

• Sales Order Voucher with Examples
• Delivery Note (Inventory) with Examples
• Rejection-IN Voucher with Examples

Debit and Credit Notes

• Debit Note Returns with Examples
• Credit Note Returns with Examples, etc.

        MICROSOFT SQL SERVER

Database Design with My SQL . Why use a relational database? Blasted Anomalies

• Normalization
• Types of Relationships
• Advanced Database Concepts
• The Structured Query Language for Creating and Altering Tables
• Essential De
• The Create Database Statement
• The Use Database Statement
• The Create Table Statement
• Column Types
• Creating IndexesTable Types
• The alter table Statement
• Using the show Command
• The Structured Query Language for Inserting, Editing,and Selecting Data
• The Basic select Statement
• Joining Tables

        SAP FICO MODULE Syllabus:

SAP FI-BASICS
SAP FI: Organization Structure
SAP FI: FINANCIAL ACCOUNTING GLOBAL SETTINGS
SAP FI: GENERAL LEDGER

SAP FI-GENERAL LEDGER II

SAP FIACCOUNTS PAYABLE:
SAP FIACCOUNTS RECEIVABLE:-
BANK ACCOUNTING
SAP FI: ASSET ACCOUNTING

SAP FI: ASSET ACCOUNTING (II)

INVESTMENT MANAGEMENT
TAX CONFIGURATION
SAP FICO: GST Configuration

REPORTS