Become a Certified Computer & Accounting Professional with Tally, Busy, GST, Web Designing, Graphics & AI Tools.

Learn Computer Basics, covering Office Management, Graphic Design, Web Design, Video Editing, E-Accounting, and MIS Reporting through practical assignments, guided exercises, and business-oriented learning activities.

16–21 Months
3 Academic Semesters
Placement Assistance

Course Overview

The Advanced DCA with Accounting & MIS Course at Sardar Patel Academy & Research Centre (SPARC) is designed for learners who want to build practical computer, accounting, and business management skills under a single programme. Rather than focusing on one subject, this course combines multiple industry-relevant disciplines that prepare students for today's technology-driven workplaces.
The programme is divided into three structured semesters that gradually develop your skills. You begin with computer fundamentals, office applications, and graphic design, then move on to website development and video editing, and finally gain expertise in accounting software, taxation, Advanced Excel, MIS reporting, and business intelligence tools. This learning approach helps students build confidence while mastering one skill after another.
Every module includes practical assignments, software-based training, and project work that reflects real business scenarios. Students gain hands-on experience with popular tools such as Tally Prime, Busy, Adobe Photoshop, Illustrator, Canva, HTML, CSS, JavaScript, WordPress, Power BI, and AI-powered productivity tools, making them capable of handling diverse responsibilities in modern organisations.
Whether you are a student, graduate, working professional, or job seeker, this course provides the technical knowledge and practical exposure needed to pursue careers in administration, accounting, finance, graphic design, web development, MIS reporting, and other office-based roles. With expert faculty, structured classroom training, and placement assistance, the programme is designed to help learners become confident, multi-skilled professionals ready for today's competitive job market.

Get Free Counseling

Fill the form & our team will contact you

What You Will Learn

Industry-Ready Courses | Real-World Projects Based Training | Digital Marketing Course Curriculum

IT/Digital Era - Entering into Computer World Keep your Data (Storage Device)

  • Computer Definition & Features
  • Application of computer
  • How to start Computer
  • login screen - user & Password
  • Desktop- Taskbar, Wallpaper, Icons
  • How to start paint, some basic tools

  • Computer Architecture Diagram
  • Father of computer
  • Devices of computer: Input, output & processing Memory Unit(MU)
  • Primary memory, Secondary memory
  • Unit of measurements
  • Hardware & Software
  • File & folder

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.My Business Card

  • Document (Page Setup), Size of Business Card
  • Tools (Selection, Direct Selection , Shape Tool(Rectangle, Ellipse, Polygon)
  • Shapes Property Fill Color & Outline Color
  • File Menu New, Open, Save, Save as, Exit

2.Typography

  • Tools Gradient, Text Tool & its properties, Type on Path Tool
  • Object Menu Arrange, Group, Ungroup, Lock, Unlock
  • Place Image

3.Magazine Cover

  • Tools Text tool, Gradient Tool
  • Layout Menu Ruler Guides, Create Guides, Layout Adjustment
  • Object Menu Effects

4.Stylish Brochure Template

  • Tools Frame Tool (Ellipse, Rectangle, Polygon), Eye Dropper, Pen, Pencil, Eraser, Line
  • Object Menu Corner Options, Pathfinder"
  • Layout Menu Columns, Ruler Guides, Create Guides, Layout Adjustment

5.Books & News Paper Publishing

  • Layout Menu Add Page, Go to Page, Edit In Story, Auto flow
  • Page Pallete Insert Page Number, Master Page
  • Type Menu Drop Cap, Bullets & Numbering, Alignments

6.Indexing

  • Type Menu Character, Paragraph, Table & Object style
  • Layout Menu Table Of Contents

7.Design & Database Fusion-Merging

  • Window Menu Data Merge
  • File Menu Export

8.Mail and Print

  • Types of Printing
  • File Menu Export, Print

1.Layering - Backbone Of Picture /Photo

  • Intro Photoshop, Application of Photoshop
  • Difference Between Image & Layer
  • Color Foreground & Background
  • Tools Move, Marquee, Zoom, Hand
  • File Menu New, Open, Save

2.Play With Background

  • Tools Pencil tool , sharpen , smudge , dodge
    ,burn , sponge , Lasso, Magic Wand, Crop, Slice
  • Layer pallete new, duplicate,delete,
  • Image menu color balance, hue & saturation

3.Masking (Amazing creativity)

  • Tools Brush tool
  • Layer Menu Layer Mask, Vector Mask, Clipping Mask
  • Filter Menu Effects

4.Movie Poster Making

  • Gradient ,eraser , paint, bucket, eye dropper
  • Layer menu layer style ,merge visible, merge down, flattern 

5.Wedding Album

  • Tools  Pattern Stamp, History Brush, Art History Brush
  • Layer Menu Masking

6.Logo Creation

  • Tools Text and its Parts
  • Image Menu modes (RGB, CYMK ,Grayscale)
  • Shape Tools Custom Shape Tool, Other Shapes

7.Day to Night Conversion , Water Ripple

  • Tools Pen, Path Selection, Direct Selection
  • Edit Menu Define Brush
  • View Menu Ruler

8.Retouching Image

  • Tools Healing Brush, Patch, Clone Stamp, History Brush, Smudge
  • Layer Pallate Blending Modes

9.Light & Glow

  • Filter Menu Extract, Liquefier, Distort, Stylize, Artistic Gallery
  • Layer Pallate Blending Modes

10.Animated Photo & Waterfall

  • Layer Pallete Adjustment Layer
  • Image Menu Adjustment
  • Window Menu Animation (Frames , Timeline)

11.Web Layout/Thumbnail

  • Filter Menu Vanishing Point
  • Edit Menu Free Transform

12.Passport Size Photos

  • File Menu Automate (Batch Create Droplet, Conditional Mode Change, Fit Image, Photo Merge, Crop & Straighten Photo, Picture Package, Contact sheet II Action)
  • Layer Menu Smart Object

13.2D Painting

  • Image Menu Adjustment Options
  • Layer Menu Blending Options

 

1. Introduction to Canva

  • Overview of Canva and its features
  • Setting up a Canva account
  • Navigating the Canva dashboard

2. Social Media Graphics

  • Designing social media posts for Facebook, Instagram, Twitter, and LinkedIn
  • Creating social media stories and ads
  • Using Canva's social media templates and design tools

3.Presentations

  • Creating engaging presentations for work, school, or personal projects
  • Using Canva's presentation templates and design tools
  • Adding text, images, and graphics to presentations

4.Infographics

  • Visualizing data and information with Canva's infographic templates
  • Designing and customizing infographics
  • Using charts, graphs, and icons in infographics

5.Posters, Flyers, and Brochures

  • Designing eye-catching posters for events, promotions, or advertising
  • Creating flyers for events, businesses, or services
  • Designing tri-fold or bi-fold brochures for marketing materials

6.Business Cards and Branding Materials

  • Creating professional business cards with Canva's templates and design tools
  • Developing brand guidelines, logos, and visual identities
  • Designing letterheads, envelopes, and other branding materials

7.Videos and Animations

  • Creating short videos or animations using Canva's video editing tools
  • Adding text, images, and graphics to videos
  •  Exporting and sharing videos

8.Invitations and Advanced Topics

  • Creating invitations for events, parties, or weddings
  • Using advanced Canva features like custom fonts, illustrations, and animations


 

1.Masking

  • Intro of Illustrator, Document (page Setup)
  • Tools Selection Tool, Direct Selection Tools, Shape Tool(Rectangle, Rounded Rectangle, Ellipse, Polygon), Bloat Tool, Warp Tool
  • Shape Property Fill Color & Outline Color
  • Clipping Mask

2.Logo Creation

  • Tools Gradient, Pen Twirl, Pucker, Scalop , Crystalize, Wrinkle, Group Selection, Magic Wand, Lasso
  • Object Menu Arrange Group, Ungroup, Lock, Unlock, Hide, Show
  • File Menu Place Image

3.Create Your Own Pattern / Now Your Creativity

  • Tools Text & Its Part, Line Segment, Arc, Spiral, Polar Grid, Rectangle Grid,
  • Symbol & Its Part, Shape Bulider tool ,object menu :Blend

4.Floral Vector

  • Tools Brush, Pencil, Smooth, Path Eraser, Rotate, Reflect
  • Object Menu Blend Option
  • Effects Menu Distort & Transaction
  • Window Menu Align, Gradient, New Brush

5.Social Media Post

  • Tools Scale, Shear Text tool, Gradient tool
  • Object Menu Clipping Mask
  • Effects Menu Photoshop Effects

6.Boucher /Flyer Designing

  • Tools Shapes, Pen tool, Gradient
  • Type Menu (Font, Recent Fonts, Size, Glyphs, Area Type options, Type on a path, Create Outlines, Find Fonts, Change Case
  • Object Menu Clipping Mask
  • View Menu Ruler Guide

7.3D Fun

  • Effects Menu 3D > Extrude And Bevel
  • Tools Eraser, Hand, Zoom, Star, Flare
  • Edit Menu Copy, Paste in Front, Paste in Back , Key board shortcuts

8.Beautiful Flower pot With Symbol

  • Object Menu Expand & Expand Appearance
  • Effects Menu 3D > Revolve
  • Tools Shapes, Pen Tool, Star, Flare

9.Funny Hairy Text (Effect)

  • Effect Menu Distort and Transaction, Pathfinder
  • Object Menu Blend Options

10.Portrait (Vector Art)

  • Tools Pen tool, Pencil Tool
  • Object Menu Live Trace
  • Effects Menu Illustrator Effects, Convert To Shape, Distort & Transform, Stylize

11.Landscape ( Scenery)

  • Effects Menu Photoshop Effects( Noise , Flim Grain ,Grain, etc)
  • Tools:- pen tool , Brush Tool
  • Object Menu :- Path , Offset Path

12.Mandala Art (Graphics)

  • Window Menu Pathfinder, Swatches, Transform, Transparency, Creating Symbols
    Brush Pallete & Creating Brush,

13.Smart Features

  • Window Menu  Align, Appearance & Creating Texture Using Appearance, Graphic Style, etc

14.Car Parking ( Smart Features)

  • Theory - Revision (Assignment Solve)
  • Practical Day - Written Test

1.Learn Web Development 

  • HTML Basic Intro and Version
  • Elements & Tags , Types of elements(Empty and Container)
  • Basic HTML element, Hgroup
  • Element(H1 to H6)

2.Styles your webpage

  • Using Font Element & Its Attributes
  • Styles Element (B,I,U,SUB,SUP,EM,MARK)
  • Paragraph Element ,Contents Editable
  • Center Element, BR element

3.News Section/Digital Showroom

  • Image Element, Image Placeholder, Image Map
  • Quotation Element (q , bdo , abbr, address)
  • Marquee Element

4.Landing Site/Linking 

  • Types of Linking : (Local, Interrnal, External, Download, Mail)
  • Anchor Element and its Atributes

5.Count The Points

  • Order List , Unorder List, Nested List
  • Definition List

6.Result Declaration

  • Table Element
    Its Components (TR, TH, TD)
    Its Attributes
  • Rows &column Merge, Caption Element

7.Framing

  • Frameset Element
    Frameset Rows, Frameset Cols, Frame Src ,
  • Iframe Element

8.Video/Audio Gallery

  • Use Video Element And Audio Element

9.Enquiry Form/Lead Generation

  • Form Element
  • Input Element And Its Type
    (Text, Radio, Checkbox, Number, range, Email, Password, Button, Submit, Reset, Image, File, Color, Date, Time, Date time-Local, Search)

10.Banking Form/KYC Form

  • Form Element
  • Advance Attribute of  Input Element (Autocomplete, Autofocus, Tab index, Required, Size, Step)
  • Advance Form Element (Select, Text area, Field set, Legend) 

1.Dynamic Site

  • CSS Introduction
  • Types Of CSS
    (Inline CSS , Embedded CSS, Link/External CSS)

2.Blocks Creation

  • DIV Element, Span Element , Margin, Padding, ID & Class

3.Background Magic

  • Background Effects
  • Background Properties
  • Gradient Background
  • Linear, Radial, Angular, Diagonal, Repeating
  • Browser Supports Key

4.Customize Text

  • Formatting Text Font Properties
  • Text Properties Text-Overflow, Word-Break, Word-Wrap, Columns
  • Border Effects Style, Width, Color

5.Designer List/Chart Library

  • Modified List & Tables
    List Properties, Table Properties
  • Shadow Effect Box-shadow, Text-Shadow
  • Round Corners
  • Div, Button etc 

6.Menu Bars/Google Map

  • Creating Menu Bar, Anchor Properties, Transition Effects
  • Hover Effect Text, Image

7.Timeline/Animated Webpage

  • Animation/Transition
  • 2D Animation And 3D Animation

1.Introduction Of  WordPress

  • WordPress intro 
  • Xmapp Intro
  • Apace , SQL , Localhost 
  • PHP,  my admin

2.Log-in Directory Interface

  • Dashboard 
  • Front end , Backend Appearance
  • Theme , Site Identity

3.Menu/Page Creation 

  • Page (Simple)
  • ADD,
  • Edit
  • Delete
  • Menu Location

4.Plugins

  • About Plugins
  • Download , Activate
  • Elementor 
  • (Text, Inner Section, Button Video , Heading ,Image)

5.Plugins(Form)

  • Contact From , Short Code
  • WP-from
  • Gravity Form
  • Formidable From
  • Ninja From

6.Plugins(Gallery)

  • Envira Gallery
  • Nextgen Gallery
  • Photo Gallery By Loweb
  • Lightbox 
  • Divi Gallery Extended

7.Widgets & Posts

  • Widgets 
  • Main, Secondary Post
  • Add , Delete , Edit 
  • Category
  • Tags

8.Roles and Capabilities Of User

  • Administrator , Super Admin 
  • Author , Editor 
  • Subscriber 
  • Add Plugins 
  • Easy Collage Plugins

9.Comments And Appearanc

  • Comment 
  • Moderate & Unmoderated 
  • Hide Comments Appearance
  • Style.CSS , 404 Template 

10.Website Completion

  • Revision

11.Google Sites 

  • Intro Of Google Sheet 
  • Creation a Website

12.Advance In Google Sheet 

  • Page Creation

13.Google Site With Google Other App

  • Docs, Sheets , Sliders , Form

Introduction to Filmora

  • Overview of Filmora: Features and capabilities
  • Installing Filmora: System requirements, download, and installation process
  • Interface tour: Understanding the workspace, panels, and tool

Getting Started

  • Creating a New Project
  • Importing Media: Video, audio, and image files
  • Organizing Media: Managing files within the software

Basic Editing Techniques

  • Cutting, trimming, and splitting clips
  • Adding Transitions: Applying transitions between clips
  • Adding Text: Titles, subtitles, and captions
  • Working with Audio: Adjusting volume, adding music, and sound effects

Advanced Editing Techniques

  • Green Screen (Chroma Key): Removing background from footage
  • Picture in Picture: Overlaying multiple videos
  • Speed Control: Slow motion and fast-forward effects
  • Color Correction: Adjusting brightness, contrast, and color balance

Effects and Filters

  • Applying Filters: Presets and custom filters
  • Adding Motion Graphics: Animated elements and overlays
  • Using Effects: Special effects and visual enhancements
  • Working with Layers: Overlaying multiple tracks

Exporting and Sharing

  • Exporting Options: Formats, resolutions, and settings
  • Rendering Process: Understanding the export process
  • Uploading to Social Media: Sharing videos on platforms like YouTube, Facebook, and Instagram

Advanced Features (Optional)

  • Audio Editing: Advanced audio manipulation techniques
  • Keyframing: Creating animated movements and effects
  • Advanced Transitions: Custom transitions and effects
  • 3D LUTs: Applying color grading presets

Project Examples and Case Studies

  • Step-by-step walkthroughs of editing projects
  • Analysis of professional edits using Filmora
  • Final Project
  • Applying skills learned throughout the course to create a complete video project

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.Fundamental of Accounting

  • What is Accounting
  • Process of Accounting
  • Event of  Transaction
  • Accounting Terminology

2.Accounting Concept

  • Rules of Debit Credit
  • Accounting Equation 
  • Accounting Principles
  • Rules and Approach For Accounting
  • Traditional approach
  • Modern approach

3.Preparation of Ledger Account

  • What do you mean by leadger Format  method of posting leader

4.Explanation of Cash Book

  • What is cash book
  • Types of cashbook
  • Single column
  • Double column
  • Triple column
  • Why cash book maintain separately

5.Bank Reconciliation Statement

  • Introduction
  • Who maintain cash book and pass book
  • Why it is necessary
  • Causes of BRS

6.Depreciation

  • What is Depreciation factor
    causes of depreciation
  • Equation of Depreciation
  • Method of Dep.
  • SLM
  • WDV
  • Class Assignment

7.Basics of final Account

  • Trading A/C
  • Profit and loss  A/C
  • Balance sheet
  • Format of final accounting
  • Class assignment

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.Responsive Website

  • Intro of Javascript
  • How to Script Tags
  • String Operator

2.Marksheet & Interest Calculation

  • Operators 
    • String Operators
    • Arithmetical Operators
    • Conditional Operators
    • Comparison Operators

3.Your Turn to Give Command

  • Input Box 
    • Prompt()
  • Data Type
    • ParseIent()
    • ParseFloat()

4.Online Entrance Exams

  • Functions & Event 
  • Disabled Property 
  • Conditional statement 
    • Simple If
    • If-Else
    • Nested If

5.What Colour You Want

  • Switch Case
  • OnChanges Event
    • document.Bgcolor
    • document.Fgcolor

6.Check User Id & Password 

  • Functions 
    • Alert() 
    • Confirm()
  • Validate Form
    • OnLoad Event
    • unOnLoad Event

  • Introduction to Power BI
  • Power BI Interface & Data Importing
  • Data Transformation with Power Query
  • Data Modeling & Relationships
  • Introduction to DAX
  • Advanced DAX Functions
  • Data Visualization
  • Advanced Charts & Custom Visuals
  • Filters, Slicers, and Drill Through
  • Power BI Dashboard Creation
  • Power BI Security & Performance Optimization
  • Power BI & Excel Integration
  • Final Project & Q&A Session

Tools & Skills Covered

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


Why You Should Choose Our ADCA Course with Accounting & MIS in Delhi

There is no shortage of institutes offering a "computer diploma course" in Delhi. The real question is which one prepares you for multiple job roles — not just one — and that is where Sardar Patel Academy - SPARC's structure makes the difference.

Project Based Training

Every topic is taught through real-world projects and assignments, not just theory. This hands-on approach helps you build practical skills you can actually apply on the job. By the end of training, you'll have a portfolio of work to show, not just certif

Affordable Fees

Quality training shouldn't mean an unaffordable price tag. Sardar Patel Academy - SPARC is structured to make a genuinely advanced curriculum accessible, so you don't have to choose between budget and quality when comparing the best digital marketing inst

CSS Based Classes

Our Class Status Sheet keeps every student's daily progress clearly documented and easy to track. It gives you a structured view of what's been covered and what's coming next. This transparency helps you stay organized and consistently on top of your lear

Mobile Application

Our dedicated Android app delivers daily test assignments straight to your phone. It's designed to help you reinforce concepts right after class and track your progress over time. Learning stays consistent, even when you're on the move.

Job Placement

We don't just train you — we help you get hired. Our placement support connects you with relevant industry opportunities and guides you through the transition from student to professional. Your career goals are part of our commitment, not an afterthought.

Study Material

Our study materials are research-based and developed through our own in-house publication team. This ensures the content is accurate, relevant, and tailored to industry needs. You get comprehensive resources designed to support real learning, not generic


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 Sradar 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.

FD

Full-Stack Developer

Voodo

Posted On 21 Jul 2026
Location Delhi
Salary 32000 Monthly
DM

Digital Marketing Strategist

Voodo

Posted On 21 Jul 2026
Location Delhi
Salary 32000 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 Digital Marketing With AI

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 principally covers three areas across three semesters: core computer and office management skills plus graphic design in Semester 1; web design and video editing in Semester 2; and E-Accounting and MIS tools (Tally Prime, Busy, GST, TDS, Advanced Excel, Power BI) in Semester 3.

Yes. The programme starts from the very beginning — how to use a computer — and builds up gradually to financial systems, accounting software, and MIS dashboards. No prior software or accounting knowledge is necessary.

The course runs for 16 to 21 months across three semesters, depending on the batch and schedule. Each class is 1 hour, with regular practical sessions built into the programme.

The entire course is built around projector-based practical training — with real tools at every stage: Photoshop and Illustrator for graphics, HTML and WordPress for web, and Tally Prime, Busy, and Power BI for accounting and MIS. You practice on actual software throughout, not just at the end.

Students can apply for roles such as E-Accountant, MIS Executive, Back-Office Coordinator, Accounts Assistant, Tally Operator, Junior Graphic Designer, Junior Web Designer, Video Editor, and Office Administrator — or start freelancing across multiple skill areas.

Yes. Students receive live internship experience as part of the programme.

Yes. SPARC offers structured placement support including resume building, HR mock interviews, personality development sessions, and job referrals — helping you transition from training into an actual paying role, not just a certificate.

Yes. The course is structured with flexible batch timing specifically to accommodate working professionals and college students who want to upskill without disrupting their current schedule.

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