Accounts & Finance

ACCOUNTING SOFTWARE EXPERT

• Fundamentals of Accounting and Tally.ERP 9
  
• Creating Masters in Tally.ERP 9
  
• Voucher Entry and Generation of Reports
  
• Tally Vault and Security Controls
  
• Export, Import and Splitting of Data
  
• Connectivity & Printing Reports
  
• Advanced Accounting and Inventory in Tally.ERP 9
  
• Job Costing and Job Order Processing
  
• Installing & Activating Tally.ERP 9
  
• TDS : Tax Deducted at Source
  
• GST : CALCULATION
  
• Central Sales Tax (CST)

FINANCIAL Accounting

• Creating A Company
  
• Company Configuration
  
• Setting up a New Company
  
• Ledger / Creating Groups
  
• Account Heads / Voucher Entry
  
• Payment / Receipt Voucher
  
• Contra Entry
  
• Purchase / Sales Register
  
• Creating Cost Centres
  
• Cost & Ratio Analysis
  
• Creating Trial Balance
  
• Viewing Statement of Accounts
  
• Profit & Loss Account
  
• Balance Sheet
  
• Bank Reconciliation
  
• Interest Calculation
  
• Printing of Accounts
  
• Bank & Cash Books
  
• Display of Accounts
  
• Purchase / Sales Register
  
• Company Configuration
  
• Company Controls
  
• TDS : Tax Deducted at Source
  
• GST : CALCULATION

INVENTORY

• Features
  
• Stock Groups
  
• Stock Items
  
• Physical Stock Voucher
  
• Creating Units of Measure
  
• Rejections In & Out
  
• Purchase & Sales Order
  
• Multi Currency
  
• Invoicing, Bill or Stock Wise
  
• Debit / Credit Notes
  
• Budgets & Controls
  
• Multiple Godowns
  
• Rejection Notes
  
• Sales Plan / Purchase Plan
  
• Sales Order Processing
  
• Purchase Order Processing
  
• Printing of Accounts
  
• Maintaining Physical Stock
  
• Display of Accounts
  
• Inventory Reports & Statements
  
• Interest Calculation
  
• PRINT PREVIEW

Work on LIVE PROJECTS

ASSIGNMENTS

Cell References

• Relative and Absolute References
  
• Row and Column References

Protections

• Protect Cell's
• Hide Formulas

Logical Functions

• IF | AND | OR | NOT
• IFNA | IFERROR

Text Functions

• SUBSTITUTE | CONCATENATE
• LEN | SEARCH | VALUE
• CHAR | TEXT | TRIM
• LOWER | UPPER | PROPER
• LEFT | RIGHT | MID

Statistical Functions

• AVERAGE
• AVERAGEIF | AVERAGEIFS
• COUNT | COUTA
• COUNTBLANK
• COUNTIF | COUNTIFS
• MAX | MIN
• LARGE | SMALL
• FREQUENCY

Math and Trig Functions

• RAND | RANDBETWEEN
• ROUND
• ROUNDDOWN | ROUNDUP
• SUM | SUMPRODUCT
• SUMIF | SUMIFS
• ABS

Financial Functions

• PMT
• RATE | PV
• NPER

Database Functions

• DGET | DMAX | DMIN
• DCOUNT | DCOUNTA
• DAVERAGE | DSUM

Lookup Functions

• LOOKUP
• VLOOKUP | HLOOKUP
• ROW | COLUMN
• INDEX | MATCH | CHOOSE
• OFFSET | INDIRECT
• GETPIVOTDATA | HYPERLINK

Date and Time Functions

• TODAY | NOW
• EDATE | EOMONTH
• HOUR | MINUTE | SECOND
• DATE | MONTH | YEAR
• DAY | WEEKDAY | WORKDAY
• NETWORKDAYS | TIME

Creating Complex Nested Functions

• Nested IF
• Nested Vlookup
• Nested Index Match

Working with Array

• What is an Array and Array Formula?
• Creating Array Formula
• Conditional Evaluation in an Array Formula
• TRANSPOSE Array Function

Data Validation

• Specifying a valid range of values for a cell
• Specifying a list by valid name range
• Creating a list based on Data in another worksheet
• Custom validations based on the formula for a cell

Working with Styles and Conditional Formatting

• Format as Table
• Conditional Formatting Using large no of icons and bars
• Highlight cell values in a column based on Numeric/textual/date/Time etc
• Conditional Formatting by using AND, OR Functions
• Conditional Formatting by using Vlookup functions

Working with Charts

• COLUMN CHART | BAR CHART | LINE CHART
• PIE CHART | COMBO CHART | DOUGHNUT CHART
• Adding a Shape and Images to a Chart
• Adding a Trendline to a Chart
• Adding a Secondary Axis to a Chart
• Adding Additional Data Series to a Chart
• Using Charts within a Dashboard the right way

Data Manipulation

• Excel Tables
• Pivot Table | Pivot Chart
• Insert Slicers | Timeline
• Filter Connections and Layout
• Dynamic Pivot Data Source

Introduction to Power Query for Excel

• What is Power Query
• Power Pivot
• Power Query Editor
• Detect Data Type
• Combine Queries
• What's Next?

Excel VBA Macros

• What is Excel VBA Macros?
• Creating, Storing and Running Your First Macro
• Macros based on Absolute and Relative References
• Change macro security settings
• Trigger a Macro with Keyboard Shortcut
• Assigning Macros to Ribbon
• Troubleshoot macro
• View and Edit VBA Macro codes
• What's Next?

Overview of Goods and Services Tax

• Overview of GST
  
• Implementation of GST
  
• Liability of the Tax Payer
  
• GST Network
  
• GST Council

Levy of an Exemption from Tax

• Levy of GST – Introduction
  
• Composition Scheme
  
• Remission of Tax / Duty

Registration

• Introduction
  
• Registration Procedure
  
• Important Points
  
• Special Persons
  
• Amendments / Cancellation

Meaning and Scope of Supply

• Taxable Supply
  
• Supply of Goods and Supply of Services
  
• Course or Furtherance of Business
  
• Special Transactions

Time of Supply

• Time of Supply - Goods
  
• Time of Supply –Services
  
• Other Points

Valuation in GST

• Transaction Value
  
• Valuation Rules

Payment of GST

• Introduction
  
• Time of GST Payment
  
• How to make payment
  
• Challan Generation & CPIN
  
• TDS & TCS

Electronic Commerce

• Introduction
  
• Tax Collected at Source (TCS)
  
• Procedures for E-commerce Operator

Job Work

• Introduction
  
• Part II

Input Tax Credit

• Introduction
  
• Important Points
  
• Job Worker
  
• Case Studies – Part I
  
• Case Studies – Part I

Input Service Distributors

• Concept of Input Service Distributor
  
• Legal Formalities for an ISD
  
• Distribution of Credit

Matching of Input Tax Credit

• Returns
  
• GSTR-2
  
• Other Taxable Persons
  
• Annual Return

Overview of the IGST Act

• Overview
  
• Other Provisions

Place of Supply of Goods & Services

• Introduction
  
• Registered and Unregistered Persons
  
• Case Studies – Part I
  
• Case Studies – Part II

GST Portal

• Introduction
  
• GST Eco-system
  
• GST Suvidha Provider (GSP)
  
• Uploading Invoices