Become a Job-Ready Accounting & Office Professional with Industry Certification

Gain practical experience in Computer Fundamentals, Graphic & Web Designing, Tally, Busy, Advanced Excel, GST, TDS, Payroll, and MIS Reporting using real business scenarios and project-based learning.

16–21 Months
3 Academic Semesters
Placement Assistance

Course Overview

Practical Accounting & Computer Training

Modern workplaces require accounting professionals to have both finance and computer skills. The Advanced DCA with E-Accounting & MIS programme at Sardar Patel Academy & Research Centre (SPARC), GTB Nagar, North Campus combines practical accounting, office tools, and business reporting to help students develop job-ready skills.

Complete Course Learning: The course starts with computer fundamentals and office tools and gradually moves into accounting software, manual and digital accounting, inventory management, taxation, and MIS. This step-by-step approach helps students understand both computer applications and accounting functions used in real workplaces.

Why Choose Sardar Patel Academy?: SPARC provides practical classroom training for students from GTB Nagar, Mukherjee Nagar, North Campus, Kamla Nagar, Civil Lines, and nearby areas. The course combines computer and accounting skills in one structured programme with practical assignments and career-focused learning.

Career Opportunities: The programme helps students prepare for roles in Accounting, Finance, MIS, Billing, Office Administration, Data Entry, and other computer-based business functions.

Get Free Counseling

Fill the form & our team will contact you

What You Will Learn

Industry-Ready Courses | Real-World Projects Based Training | Adv.DCA with E-Accounting & MIS Course Curriculum

Find your Space in Computer (File & Folder)

  • Window explorer , File & folder

Searching : Find your File/Folder Wild Cards

  • Extensions of program
  • Wild card Asterisk(*), Question mark(?)
  • Searching for file and folder

1.Start your Career - CV/Resume Creation

  • Definition, Feature
  • How to start Ms Word
  • File, font group

2.Beautifying your CV/Resume (Formatting)

  • Quick Access Tool Bar
  • Paragraph Group, Clipboard group, Editing group

3.Letterhead - Show case of Your Company

  • Insert tab: Header & footer group
  • Date & Time, Symbol Picture
  • Home tab: change Case, Border & Shading

4.News Paper & Magazine Creation (Column)

  • Page layout tab: columns, column break
  • Insert tab: Drop cap, Book cover
  • file:Auto correct
  • Review tab: Word Count, Spell Check, Thesaurus

5.Create your Own Book

  • Refrence tab: Insert endnotes, Insert footnotes, table of content
    watermark, Hyphenation

6.Links and Security

  • Refrence tab: Insert caption, index entry,
  • Links: Booksmarks, Hyperlink, cross Reference
  • Review tab: Track changes, Protect document

7.Connect your Customer (Bulk Mailing)

  • Mail Merge , Main document & Data source

8.Connect your selected customer(Record filtration)

  • Sorting of Record
  • Filter of Record
  • Lables
  • Envelope

9.Mark sheet Creation (Tabular format data )

  • Insert table, Draw table
  • Layout tab
  • Design tab

10.Document is ready to print/Record your actions

  • Page setup
  • Print preview
  • Print
  • Macro

1.World of Row and Column - First interaction with excel

  • Introduction of excel, Workbook, Worksheet, Row, Column, Cell, type of entries
  • Home tab: Cell group, Font group, Alignment

2.Invoice / Bill of Supply

  • Type of Reference : Absolute, Relative
  • Basic formulas
  • Sum, Product, Minus, Quotient, Mod, Percentage)

3.Result Declared (Automatic Calculation)

  • Function

4.Secure your Data/ Lock your data/ Restrict editing

  • Styles group :  Format as table, Conditional Formatting, Cell styles
  • Protection: Track Changes, Protection

5.Data Analysing Tool (Expense Limit & Comparision)

  • What if Analysis: Goal seek, Scenario, Data table

6.Pictorial Representation of Data (Chart Magic)

  • Pictorial Represntation of data
  • Chart, type of chart, formatting of charts

7.Organize your Data (Easier to Analyze)

  • Data validation, Data filtration, sort, subtotal

8.Analyzing Complex Data (Pivot Table)

  • Logical function: if and, if or
  • Pivot table, Pivot chart, Paste special

9.Lookup & Reference , Extract Your Data

  • Lookup functions : lookup, vlookup, hlookup
    match, index

10.Data is ready to Print /Page Setup

  • Page setup
  • Print preview

1.Welcome to Presentation World

  • PowerPoint - Definition feature, purpose ,view of slides
  • Home tab-slide group

2.Beautifying presentation (Formatting of presentation)

  • Font & Alignment Group
  • Inset tab - Illustration group
  • Themes & Background

3.Masters of Slide/ Slide Automation

  • Masters
  • Animation(triggers
  • Transition
  • Hyperlink, Actions
  • Slide background

4.Its presentation time now

  • Slide show tab - From beginnng, from current slide, Custom slide show,setup slide, Hide slide, Record narratio, Rehearse timing, slide show
  • Inset tab- photo album

5.Advance feature of Presentation

  • Running Clock, Moving Car, Making Picture, Bouncing Ball

1.World of Internet 

  • Internet introduction & Benefit
  • Computer Network: LAN, WAN, MAN
  • Services of internet
  • Search engine, Web browser

2.Online Communication

  • Inbox , Reply, Forward, composing, Attachments of file,
    Change password(setting of E-mails) , Facebook account handling, 
    Facebook page creation

3.Downloads/Booking

  • Ticket Reservation & Booking, Online shopping, Online Bill payment, Book movie ticket
  • Download: Image, font style, app, pdf, song, movie

4.Digital India

  • Cash less society
  • E-wallets, UPI, Plastic money, USSD, Net Banking

1.Lets Upgrade Advance Skills

  • Type Of Function 
  • Find, Concatenate , Length , Abs ,Round ,Roundup , Rounddown,
  • Power ,Exact ,Left, Right, Trim, Find , Substitute , ABS , Text 

2.Audit & Management Of Data

  • Trace Precedent , Trace Dependent ,
  • Remove Arrow , Error Checking , 
  • Text to Column , Flash Fill, 
  • Data Validation , Remove Duplicate , 
  • Consolidate

3.Salary Sheet

  • Definition
  • Salary sheet Calculation
  • Pay slip

4.Dashboard

  • Pivot Table
  • Pivot Chart
  • Slicer
  • Timeline 
  • Value Function
  • Convert Function 

5.Loan Installment Sheet 

  • Financial Function 
  • PMT, NPER, PV , FV, RATE

6.Garbage Clearing

  • If function in Loan Sheet 
  • Age Calculation

7.Working With Function

  • Double Vlookup Function 
  • Vlookup With Match
  • Vlookup With Hlookup

8.Xfunction

  • If with Vlookup & Hlookup 
  • IF with Not
  • Xlookukp Function
  • XOR

9.Special Tools In Excel 

  • Name Manager 
  • Conditional Formatting 
  • Calendar
  • Checkbox

10.Attendance Sheet

  • If Error Function
  • Eomonth Function

11.Trick & Techniques

  • Basic Tricks
  • Subtotal With Filter

1.Stock/ inventory Keeping Units

  • Introduction
  • Creation of stock group
  • Creation of Unit of Measure
  • Creation of Stock Item
  • Creation of Godown

2.Recording of Day to Day Transaction –Voucher

  • Introduction
  • Receipt Voucher
  • Contra Voucher
  • Payment Voucher
  • Purchase Voucher
  • Sale Voucher
  • Debit Note Voucher
  • Credit Note Voucher
  • Journal Voucher
  • Creation new Voucher Type
  • Non Accounting Voucher
  • Inventory Voucher
  • Assignment

3.Management of Accounts receivable and Payable

  • Management of bill wise bill maintenance Credit Limit

4.Fundaments of Inventory Management

  • Recording of  Day to Day Transaction –Voucher

5.Godown Management

  • Allocation of stock to Particular Godown while defining opening Balance
  • Recording of purchase ,sales, and Stock transfer with Godown Details
  • Stock category
  • Movements of goods in Batch/Lots-Batch wise Detail
  • Expired Batch/Transfer
  • Batch Reports
  • Stock Valuation Method
  • Assignments

6.Management of purchase and sales order

  • Purchase order processing
  • Sales order processing
  • Viewing order details
  • Pre close order
  • Reorder level
  • Assignments

1.Banking

  • Cheque management
  • Cheque Printing
  • Multi Cheque Printing
  • Cheque Register
  • Cancelled Cheque
  • Blank Cheque
  • Bank Reconciliation 
  • Deposit Slip
  • Assignment

2.Cost Centre and Profit Centre Allocation

  • Create Cost Centre
  • Cost center summary
  • Create Cost Category
  • Cost Category summary
  • Cost Centre Class
  • Assignments

3.Price level and price list

  • Creation of price list
  • Using price list
  • Revise price list
  • Assignments

4.Bills of Material

  • Set component (BOM)
  • Accounting of manufacturing process
  • Transferring of manufactured goods
  • Reports
  • Cost estimation
  • Assignments

5.Job Costing

  • Enable job costing
  • Creating Required masters
  • Creating manufacturing journal voucher
  • Job costing reports
  • Assignments

6.Job Work

  • Enabling job order processing
  • Voucher type set up for job Work In
  • Voucher type set up for job Work In
  • Job order processing
  • Voucher type set up for job Work In
  • Job order processing
  • Creation of inventory
  • Record job work out order voucher
  • Issued of raw material to job worker
  • Receipt of finished goods
  • Job work out reports
  • Recording job work in order voucher
  • Recording material in voucher
  • Manufacturing of finished goods
  • Dispatching finished goods to manufacturer
  • Job work in order reports
  • Assignments

7.Interest calculation

  • Activating interest calculation brining the calculated interest amount in books of account
  • Using advance parameters for interest calculation
  • Advance parameter explanation
  • Calculation of compound interest in Tally Prime
  • Interest calculation reports
  • Assignments

Payroll

  • Activating payroll
  • Employee group master
  • Employee masters
  • Creation of payroll units
  • Attendance production type
  • Creation of pay head
  • Defining salary details for an employee
  • Salary processing
  • Payroll reports
  • Payroll statuary deduction
  • Provident fund
  • EDLI
  • Employee state insurance
  • Professional tax
  • National pension scheme
  • Define salary details
  • Process salary
  • Payroll statuary reports
  • Gratuity
  • Assignments

Tax Deduction at Source

  • Activation of TDS feature in Tally Prime
  • TDS Statutory Masters
  • Configuring TDS at group level
  • Configuring TDS at ledger level
  • Booking of expense in purchase voucher
  • Expenses partly subject to TDS
  • Booking expense and deducting TDS later
  • Accounting multiple expense and deducting TDS later
  • Accounting for TDS on advance payment against Transport
  • TDS on expense at Lower rate
  • TDS on expense at Zero rate
  • Deducting TDS on payments
  • Reversal of expense with TDS
  • Deducting TDS on Expense with Inventory
  • Accounting TDS on Fixed Assets
  • Payment of TDS
  • TDS reports
  • Assignments

Tax Collection at Source

  • Configuring Tally Prime for TCS
  • Create TCS nature of Goods
  • Creation of Accounting Masters
  • Sales of TCS Goods at Lower Rates
  • Sales of TCS Goods at Nil rate
  • TCS on transfer to Right to Use
  • Payment of TCS
  • TCS reports
  • Assignments

Goods and Service Tax

  • Getting started GST with GST(Goods)
  • Introduction
  • Enabling GST and Defining Tax details
  • Intrastate Supply of Goods
  • Intrastate outward supply
  • Interstate supply
  • Interstate Inward supply
  • Interstate outward supply
  • Return Of Goods
  • Purchase return
  • Sales Return
  • Supplies Invoice of tax
  • Defining GST Rates at Stock Group level
  • Defining GST rates at Stock Item Level
  • Defining GST rates at transaction Level
  • GST Reports
  • Input Tax Credit Set off
  • GST Tax payment
  • Challan reconciliation
  • Assignments

GST(part-2)

  • Getting started GST with GST(services)
  • Introduction
  • Enabling GST and Defining Tax details
  • Intrastate Supply of service
  • Intrastate Outward Supply
  • Interstate Supply of Services
  • Interstate Outward Supply of goods
  • Cancellation of Services
  • Cancellation of Outward Supply
  • Defining tax Rates at Master and Transaction Level
  • Assignment

1.Setting up a Company in BUSY

  • Creating a New Company
  • Opening a Company
  • Editing a Company
  • Closing a Company
  • Deleting a Company

2.Accounting & Inventory

  • Creating Masters
  • Accounts
  • Account Group
  • Item
  • Item Group
  • Material Centre
  • Material Centre Group
  • Unit

3.Entering Vouchers

  • Sales
  • Sales Return
  • Purchase
  • Purchase Return
  • Payment
  • Receipt
  • Journal
  • Contra
  • Debit Note
  • Credit Note
  • Stock Transfer

4.Advance Features

  • Budget
  • Credit Limit
  • cost Centers
  • Price Levels
  • Point of Sale- POS
  • Bills of Material -BOM

5.Taxation In Busy

  • Tax Deduction at Source -TDS
  • Tax Collection at Source -TCS
  • Goods and Service Tax -GST

1.Introduction Of Income Tax

  • About Taxation in India
  • Direct and Indirect tax
  • Act and Law
  • Activity Day 01

2.Assessee And Computation With Slab

  • Assessee - tax payer
  • Period of taxation
  • Heads of Income
  • Slab Rate
  • Activity Day 02 

3.Prepaid Taxes And Interest

  • Prepaid Taxes
  • Interest on Advance Tax
  • Final Computation
  • ITRs Applicable on Different Income
  • Activity Day 03

4.E Filing Of ITR - 01

  • Income from Salary
  • One House Property
  • Other Sources
  • Deduction Chapter VI-A of the Act
  • Computation
  • e-filing of ITR -01 Through Portal
  • Practice Assignment

5.E Filing Of ITR - 03-Business Income

  • Business or Professional Income
  • Schedule of ITR-3
  • Computation

6.Return Filing Form -ITR-03

  • Practice Assignment
  • MCQ -10 Question

7.E Filing Of ITR -04-Presumptive Income

  • About Presumptive Income
  • Presumptive Scheme 44AD/44ADA/AE
  • Computation of income
  • Return filing form -ITR-04
  • Practice Assignment
  • MCQ -10 Question

1.TDS-Introduction

  • Important Abbreviations and Definition
  • Why TDS /TCS is Required
  • Objective of TDS
  • Who is Responsible for TDS Deduction
  • Payment eligible for TDS Deduction
  • TDS Deduction Threshold Limit & Rate
  • Online Challan payment of TDS - Challan 281

2.Payment to Other Than Salary -26Q

  • Party Payment and Deduction
  • Threshold Limit & Rate with TDS Section -193 to 194IB
  • FAQs on Payment and Deduction -26Q

3.TDS Return -26Q [Practical]

  • Step by Step Computation -FORM 26Q
  • Generate FVU File and FORM 26Q through Software

4.Allowance & Basic Salary

  • Type of Allowances
  • Computation of Allowance

5.Perquisites

  • Type of Perquisites
  • Computation of Perquisites

6.TDS Return -24Q

  • Salary Computation of Employee
  • TDS Deduction and Deposit by Employer
  • Generate FVU File and FORM 24Q through Web-e-TDS Software

7.Tax Collection at Sources (TCS)

  • What is TCS
  • Payment eligible for TCS
  • Threshold Limit & Section 206 with RATE CHART
  • Computation and Return filing of FORM - 27EQ
  • Generate FVU File and FORM 27EQ Through Software
  • FAQs on Payment and Deduction -27EQ

8.About Traces Website-WWW.Tdscpc.Gov.In

  • Login on TRACES
  • View 26AS -Details of Advance Tax and TCS/TCS
  • Download FORM 16/16A

1.Introduction of GST

  • Eligibility in India 
  • About GST Council 
  • GST Registration 
  • Slab Rates 

2.Understanding the concept of supply

  • Definition of supply 
  • Type of Taxable payer  
  • Type of supply 
  • Composite Supply 
  • Mixed supply

3.Time of supply 

  • Time of supply in case of Goods 
  • Time of Supply in case of services 
  • Time of supply in case of RCM
  • Time of Supply in case of Voucher 
  • Time of Supply in Case of Advance Receipt

4.Place of supply

  • Supply in India 
  • Supply outside India

5.Recording of advance entries in Tally Prime -1

  • Accounting Multiple Services in a Single Supply
  • Recording Partial Payment to Suppliers
  • Recording Outward Supply with Additional Expenses
  • B2C supply of services (Business to Consumers).
  • Exempt supply of services under GST
  • Reverse Charge on Services under GST
  •  Advance Receipts from Customers under GST
  • Advance Receipt and Issuing Invoice on Different Month

6.Recording of advance entries in Tally Prime -2

  • Purchases from Composition Dealer
  • Purchases from Unregistered Dealers
  • Exports Through LUT/Bond
  • Exempted Goods
  • SEZ Sales  Advance Receipts and Payments

7.Composition scheme

  • Threshold Limit for Composition Scheme
  • Who is eligible Assessee
  • Rate applicable to a Composition Dealer
  • Limitations of GST Composition Scheme
  • Registration under Composition Scheme

8.E-way bill under GST

  • Who Is Eligible to Issue E Way Bill
  • E-Way Bill Is Not Required
  • Format & Eligibility to Issue E- Way Bill
  • Information’s to Be Filled In E-Way-Bill
  • Process to Generate E Way Bill
  • Documents or Details Required to Generate E-way Bill

9.Input tax credit (ITC) and payment

  • How we claim ITC-Set off Tax Liability
  • How to Claim Input Credit Under GST
  • Documents to avail ITC
  • ITC on Job Work
  • Who is liable to pay GST
  • Electronic Ledger
  • Electronic LIABILITY ledger
  • Electronic CREDIT ledger
  • Electronic CASH ledger
  • Payment Process of GST
  • Due Date of Tax Deposit
  • FAQ On Payment

10.Return filing of GST-GSTR

  • Annual Return 
  • Due Date Chart
  • Process of e-filing of GSTR-01- Outward Supply
  • What is HSN Code
  • Process of Return Filing GSTR -2A to GSTR -02
  • Process of filing GSTR-03

Tools & Skills Covered

Get hands-on training in the most in-demand tools and real-world digital marketing skills.


Why You Should Choose Our Adv. DCA Course with E-Accounting & MIS

There's no shortage of institutes offering accounting or computer courses in Delhi. The real question is which one actually prepares you for a job — and that's where SPARC's structure makes the difference.

Project Based Training

Every module includes practical assignments and live projects, helping you apply your learning while building a professional portfolio.

Affordable Fees

We offer industry-relevant training at affordable fees, making quality education accessible without compromising on practical learning.

CSS Based Classes

Track your daily progress, completed topics, assignments, and upcoming lessons through our organised class status system.

Mobile Application

Access study materials, assignments, recorded resources, and course updates anytime through our dedicated mobile application.

Job Placement

Get placement assistance, interview preparation, resume guidance, and career support to help you begin your professional journey.

Study Material

Our research-based study materials are created by SPARC's in-house publication team to provide accurate, up-to-date, and industry-relevant content. Each module is designed to support practical learning and help you understand every topic with clarity.


Our successful alumni

We are proud to present our alumni who have made it big in the industry. Magic happens when our training and their hard work come together.

Placement Support

At Sardar Patel Academy - SPARC, we don’t just teach skills—we prepare students for successful careers. Our Placement Support program is designed to help learners become job-ready through professional resume building, interview preparation, and direct job assistance. We also conduct mock interviews and communication skills training sessions to boost confidence and improve performance during real job interviews. Additionally, our team provides job assistance by connecting students with hiring companies and recruiters, helping them explore relevant career opportunities and take the next step toward a successful future.

VE

Video Editor And Smo Handling

Astrologer

Posted On 07 Aug 2026
Location Model Town
Salary 12K -15K Monthly
CF

Computer Faculty

----------

Posted On 07 Aug 2026
Location School In Model Town
Salary 25k to 30K Monthly
CD

Computer Data Entry Operator

Jai Mahavir Electricals (purja)

Posted On 07 Aug 2026
Location Sadar Bazar, Delhi
Salary ₹12,000 – ₹18,000 Monthly
ME

Mis Executive

Action International Pvt. Lyd.

Posted On 30 May 2026
Location Peeragarhi, New Delhi
Salary salary depend on your advanced excel skills Monthly
A

Accountant

Sparc

Posted On 28 May 2026
Location Priyadarshini Vihar, Near Guru Harkrishan School
Salary 14,000 to 16,000/- Monthly
SE

Smo Executive

---

Posted On 16 Apr 2026
Location Moti Nagar, Delhi
Salary On interview bases Monthly
SE

Smo Executive

---

Posted On 16 Apr 2026
Location Delhi
Salary On interview bases Monthly
DM

Digital Marketing Internship

----

Posted On 30 Mar 2026
Location 528, City Centre Mall, Dwarka Sec 12
Salary On interview bases Monthly
DA

Data Analyst

---

Posted On 28 Mar 2026
Location New Azad Nagar, Delhi
Salary On interview bases Monthly
T

Telecaller/Receptionist

---

Posted On 28 Mar 2026
Location Delhi
Salary On interview bases Monthly
A

Accountant

Ca Firm

Posted On 27 Mar 2026
Location Delhi
Salary On interview bases Monthly

Career Opportunities After This Adv.DCA with E-Accounting & MIS

Build skills that can open multiple career paths across agencies, startups, brands, freelancing, and business growth.

What Our Students Say

Delivering practical skills, real projects, and career-focused training across Delhi-NCR
Average Rating: 4.9 /5 from 2500+ Reviews

Career Guidance Blog

Let's Clear up some doubts

Everything you need to know before joining — from eligibility to fees and career opportunities.

The course covers a mix of manual and software accounting with Tally, Busy, Advanced Excel, Inventory, Billing, Taxation, and MIS reporting.

Yes, no prior knowledge is required. The modules start with basic computer usage and gradually build up to complete financial and accounting systems.

Students can apply for roles such as Junior Accountant, Tally/Busy Operator, Billing Executive, Payroll Assistant, and MIS/Data Entry Executive.

Yes, you will work practically with Tally ERP, Busy Software, GST billing formats, Excel dashboards, and inventory reports throughout the course.

Yes. SPARC offers job placement assistance, including resume building, interview preparation, internship support, and job referrals.

The course runs for 16–21 months across 3 semesters, conducted offline with 1-hour training sessions.

SPARC is positioned to be one of the more affordable options among institutes offering this level of accounting and computer training in Delhi. Fill the enquiry form or call us for the current fee structure.

Start Your Career Journey Today

Join SPARC and become part of a community that believes in affordable, quality education

Areas We Serve : North Delhi| Rani Bagh| Janak Puri| Nangloi| Dwarka Mor| Nazafgarh
Call Now Chat Now