+91-892 015 0908

ADFM

Quick Enquiry


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