Certificate Program in Industrial Accounting

ACIP – Anubhav Computer IT Professional Program, which is recognized as the Most Trending Course in 2021.  So, Enroll Now at Anubhav, which is know as the Institute for Graphic Design, Digital Marketing, Business Accounting.

Industry Expert
Trainer

Learn the entire Course from Industry Trainer with their experience.

Practical Live
Traininig

Learn Practically from Trainer and Implement it in front of the Trainer.

Update Syllabus &
Tools

Learn the Industry Updated Syllabus which will help you to get a Job.

5+ Government
Certificates

Learn and Master yourself to get Job with 5+ Government Certificates.

100% Placement Assistance

*Terms and Conditions Applied

CIA+ Courses

MS-Office

MS-Office Syllabus

1. WINDOWS

  • Introduction to Keyboard
  • Creating Folders
  • Giving Password to the Folder
  • Changing Attributes ( Read only and Hide )
  • Rename Folders and Files
  • Delete / Restore Files and Folders

2. MS-WORD

  • Overview of Word Processing
  • Creating a Simple Document
  • Formatting and Page Layouts
  • Printing Concept
  • Table of Content
  • Creating Greeting Card, Letterhead, Creating Flyer, Resume
  • Hyperlink and Bookmarks
  • Mail Merge

3. MS-EXCEL

  • Overview of Excel
  • Formatting
  • Sum, Average, Min, Max, Len, Count, Upper, Lower
  • Pivot Table and Chart
  • Page Layout 
  • Planning Event Expenses
  • Creating Planner
  • Planning of Monthly Budget
  • Protect Sheet

4. MS-POWERPOINT

  • Overview of Power Point
  • Inserting Slides / Types of Slides
  • Title Slides
  • Title and Content
  • Section Header
  • Two Content
  • Comparison
  • Title Only
  • Blank Slide
  • Content with Caption
  • Picture with Caption
  • Text type and formatting
  • Creating Digital Photo Album
  • Transition and Animation Effect

MS-CIT

MS-CIT Syllabus
  • Typing Skills
  • 21st Century Job Skills
  • 21st Century Daily Life Skills Websites and Apps
  • 21st Century Citizenship Skills
  • 21st Century Study Skills
  • IT Concepts and General Awareness
  • Go Green
  • Ergonomics
  • Scripting Skills
  • Netiquettes
  • Cybersecurity Skills

Internet Skills

Internet Skills Syllabus
  • E-mail ID Creation
  • Google Drive
  • Online Birth, Death Certificate
  • Filing PAN, Aadhaar Card
  • Online Passport
  • Online Ticket Booking
  • Linking Aadhaar Card with PAN Card
  • Online Payment of Bills, Taxes
  • Sharing Documents, Images
  • Downloading or Uploading
  • Creating Blogs, Own Pages
  • Online Net Banking
  • Using Debit or Credit Cards

Advanced Excel

Advanced Excel Syllabus

 STARTUP WITH MS-EXCEL

  • Data Customization & Formatting
  • Work Protection
  • Page Setup & Shortcut Keys
  • Functions V Finance Function
    • SUM, MIN, MAX, AVERAGE V PMT, PPMT, IPMT
    • COUNT, COUNTA, COUNTIF V FV, PV
    • COUNTBLANK, CONCATENATE
  • Conditional Formatting ADVANCE FORMULAS & FUNCTIONS
    • Highlight cell rule
    • Top/ Bottom Rules
    • Data Bar & Colour Scales

2. MIS REPORTS

  • Match & Index Function
  • Consolidation
  • Data Validation
  • What If Analysis
  • Scenario manager
  • Goal Seek
  • Data Table 
  • Merge Workbook
  • Freeze Panes
  • Subtotal Function
  • Work With Spark Lines
  • Surface, Rader & Combination Charts
  • Share Workbook
  • Remove Duplicate Data

3. BILLING & FINANCE FUNCTIONS

  • GST Bill Calculation
  • Preparing GSST Bill
  • Page layout- margin setting
  • Finance Function
  • PMT, PPMT, IPMT
  • FV, PV

4. ADVANCE FORMULAS & FUNCTIONS

  • If, AND, OR, NOT Condition
  • Nested if Function
  • Dated If Function
  • Sorting and Filter Data
  • Advance Filter
  • Advanced and Date Filter
    – Today, Date, Day
    – Year, Weekday
    – Time, Hours, second
  • Manipulation Text
    – Text to column
    – Concatenate
  • Advance Text Function
  • Upper, Lower, Proper
  • Left, Right, Mid
  • Len and Exact
  • Search and Replace
  • Macro
  • Pivot table
  • Pivot chart
  • Slicer
  • Report Layout
  • Report Connects

BFSI

Banking, Financial Services and Insurance

.Introduction to Indian Financial system

2.Introduction to Banking system with Digital banking

3.General Principles of Investing

4.Banking products & investment opportunities in banking sector

5.Agricultural insurance, Life insurance, General insurance schemes for protection

6.Risk and risk assessment in stocks/shares

7.Mutual Funds and methods to invest

8.Systematic Investment Plans (SIP)

9.Financial analysis and credit rating of an individual

10.Investment in Post Office schemes, Government bonds

11.Microfinance

12.Career in banking sector & BFSI agent

13.Career as a Necessary communication, networking and selling skills for career in BFSI sector

14.Handling and resolving customer grievances

Tally Prime

Tally Prime with GST Syllabus

1. ACCOUNTING BASICS

  • Introduction to Accounting
  • Introduction to Tally Prime
  • Accounting Methods
  • Golden Rules
  • Shortcut Key

2. RECORDING DATA

  • Company Creation
  • Accounting ledger detail
  • Under Group & Ledger
  • Accounting voucher
    • Purchase & Sales voucher
    • Receipt & Payment voucher
    • Journal & Contra voucher
  • Display reports
    • Balance Sheet
    • Profit & Loss Account
    • Trail Balance

3. ADVANCE INVENTORY

  • Introduction to Inventory
  • Stock Item & Group
  • Stock Group & Category
  • Stock Units
  • Godown / Location
  • Cost Center & Cost Category
  • Order Processing
  • Bill of Material

4. MIS REPORTS

  • Interest Calculation
  • Exporting Data to Various Formats
  • Account Configuration
  • Depreciation
  • Day Book Report
  • Stock Summery
  • Ration Analysis
  • Trail Balance
  • Account Book
  • Statements Of Accounts
  • Inventory Book

5. PAYROLL

  • PF & ESIC, Monthly Leaves, Gratuity
  • Payroll Ledgers, Payroll Voucher
  • Attendance voucher
  • Pay Slip / Salary Slip
  • Deduction Pay Heads
  • Create Earning Pay Heads

6. GST (Goods & Services tax) 

  • Introduction of GST
  • Tax components of GST
  • Types of taxes under GST
  • Recording transaction with GST
  • Purchase & Sales in with GST
  • Recording GST transaction of Trading firms
  • Recording GST transaction of Services providers
  • Generating GST reports
  • GST Report
  • GSTR1, GSTR2 & GSTR3B

7. BANK RECONCILIATION

  • Bank Reconciliation Process
  • How to enable banking features
  • Summary Reconciled Transaction and Narrations

8. Tax Deduction at Sources ( TDS )

  • How to enable tax deducted at source (TDS)
  • Example for Deductor and Deductee
  • How an emplyoee get TDS Refund
  • Income Tax filing Process
  • Calculate Interest on Late Payment of TDS

9. Multi Currency

  • Understanding about Foreign Gain/Loss
  • How to Active Multi-Currency
  • How to use Multi-Currency Feature
  • Defining Rate of Exchange
  • Creating Party Ledger with Foreign Currency
  • Creating Sales Ledger and Bank AC Ledger
  • To View Foreign Exchange Gain or Loss

Advanced Accounting

Advance Accounting Syllabus

1. ADVANCE ACCOUNTING

  • Bill-wise details
  • Cost Centers and Cost Categories
  • Multicurrency
  • Bank Reconciliation
  • Interest Calculations
  • Budgets & Controls
  • Scenario Management

2. ADVANCED INVENTORY

  • Order Processing
  • Re-order Level
  • Tracking Number
  • Additional Cost Details
  • Bill of Materials (BOM)
  • Price Level and Price List
  • Stock Valuation
  • Inventory Ageing Analysis
  • Different and Billed Quantities

3. POINT OF SALES (POS)

  • Features of Point of Sales (Pos)
  • POS Invoice
  • POS Report

4. JOB COSTING

  • Configuration Job Costing
  • Creating Master for Job Costing
  • Recording Transactions
  • Job Costing Report

5. PRICE LIST OR PRICE LEVELS

  • Activating price List and Defining Price level
  • Creating price list
  • How to modify price list
  • How to import price list

6. INTEREST CALCULATION

  • Break Down of Interest Rate
  • Activate Simple Interest Calculation in Tally
  • Benefits of Calculation of Interest with Tally
  • Generating Interest calculation report
  • Passing Interest receivable entry

7. TRADE DISCOUNT 

  • Activate Discount Column
  • Create Discount Ledger
  • Record Sale with Discount

8. ZERO VALUED ENTRIES 

  • To Activate Zero Value Entry
  • To Create Stock Group
  • To Create Stock Item
  • View Stock Summary

9. GOODS AND SERVICES TAX 

  • GST Portal
  • Configuring GST Features
  • Setting the GST rate
  • Returns summary
  • Creating Masters
  • Entering Transactions
  • GST Report
  • GST Filing
  • GSTR 1,2,3
  • Transferring the input tax credit to GST
  • Computation Details
  • Status reconciliation
  • HSN summary
  • Exporting GSTR 1,2,3B

10. TAX DEDUCTED AT SOURCES (TDS)

  • Basic Concepts of TDS
  • Configuring TDS
  • Recording a journal voucher for TDS Adjustment
  • TDS Statutory Master
  • Exemption, Lower Rate
  • Payment and Enable TDS
  • Booking of Expenses in Purchase Voucher
  • Processing Transaction
  • TDS Reports

11. PAYROLL AND COMPLIANCES 

  • Configuration Payroll
  • Enable Payroll
  • Enable Payroll Statutory & Taxation
  • Define Employee Categories
  • Creating Employee Group
  • Create Employee
  • Create Simple & Compound Unit
  • Creating Payroll Masters
  • Accounting For Employer PF Contribution
  • Accounting For Employer ESI Contribution
  • Payment Of Professional Tax

12. POWER PIVOT IN EXCEL

  • Import Data from Different Sources
  • Create Tables
  • Edit Data In A Table
  • Create Relationship Between Tables
  • Create Calculation
  • Create Pivot Table & Pivot Charts

13. ADVANCE FUNCTION

  • DATABASE FUNCTION
  • DGET
  • DPRODUCT
  • DMAX
  • DMIN
  • DCOUNT
  • DCOUNTA
  • DVAR

14. POWER QUERY IN EXCEL

  • Transformation
  • Data flows
  • Transfer raw data with power query calculation

15. ADVANCE FUNCTION

  • If Combination with And / Or Function
  • Offset Combined with Sum or Average Function
  • Choose Function
  • SUMIF Function
  • SUMIFS Function
  • COUNTIFS Function
  • Trim formula
  • IFERROR function
  • VLOOKUP with IFERROR Function
  • VLOOKUP with Table Array
  • Rank Function
  • Array Function

Interview Ethics

Interview Ethics Skills

1. BEFORE INTERVIEW

  • Introduction to Interviewing
  • Effective Resume Writing
  • Use of Technology Wisely

2. ONCE INTERVIEW IS SCHEDULED

  • Research the Company
  • Practice & Practice & Practice
  • Interview Preparation
  • Stay Healthy
  • Grooming for Success

3. DURING INTERVIEW

  • Types of Interviews
  • Make a Great First Impression
  • Body Language Dos & Don’ts
  • Interview Tips and Tricks
  • Ending the Interview

4. AFTER INTERVIEW

  • Take Notes
  • Thank the Interviewer
  • Following Up
  • The Second Interview

Communication Skills

Communication Skills Syllabus
  • Setting Clear Goals for Your Communication
  • Speaking Effectively
  • Building Presence
  • Writing Proficiently
  • Reading Deeply
  • Listening Actively
  • Hearing Vs. Listening
  • Body Language & Self Image
  • Learning From The Past
  • Understanding The Halo Effect
  • Understanding People Types
  • Core Communication Skills
  • The ‘Truth, Trust, Time’ Principle
  • Avoiding Communication Breakdowns
  • 00Hours
  • 00Minutes
  • 00Seconds

Enroll Now and Get Special Discount

Our Associations

Testimonials

Experience Matters

One of the fine institute in area with experienced faculty, also every one is very supportive So overall great experience.​
Prathamesh Khanolkar
Student
Anubhav institute is very nice teaching and atmosphere is so good and they clear our doubt so nice institute Thank You.
Laxmi Nishad
Student

Want to see all our client reviews & testimonials?

Connect with us for Most Trending Course in 2021

Get Your Dream Job

Festival Offer is ON

25% Discount on Online Training

Build Your Successful Career with Anubhav