Course Duration in Hours
225
225
DCA (Diploma in Computer Application)
Fundamental
• Introduction About Computer fundamental
• Difference between hardware and software
• Difference between input and output device
• Introduction About OS
• Introduction About Memory
• Introduction About Computer Generation
• Computer Assembling and dissembling
• Computer Windows Formatting
• Trouble Shooting
Notepad
• Introduction About Notepad
• File
• Edit
• Menu
• All computer Shortcut Key
M.S OFFICE
• M.S Word
• M.S EXCEL
• M.S Power Point
• M.S Access
• Typing
• HTML
• Internet
Adv. Excel
Overview of Basic Excel
Introduction About Excel
How to Start excel
All Excel Short cut key
Home Tab
Insert Tab
Page Layout
Formula Tab
Data Tab
Review Tab
View Tab
Customizing Excel Ribbon
Excel Ribbon Customizing
Create default list
Add Excel User Form
Change Excel Default Option
Formatting and Number System
Advance Conditional Formatting
Number System
Paste Special
Go to Special
Formula
Logical Formula
Text Formula
Date & Time Formula
Financial Formula
Lookup Formula
Function Formula
Logical Formula
If
And
Or
Nested If
If Error
Is text
Is Number
Is Blank
Text Formula
Upper
Lower
Proper
Left
Right
Mid
Len
Trim
Code
Char
Replace
Substitute
Concatenate
Date & Time Formula
Now
Date
Time
Hours
Minute
Second
Year
Month
Day
Eomonth
Today
Day 360
Network days
Dated if
Week Day
Lookup Formula
V Lookup
V Lookup + List
V Lookup + Search Box
V Lookup + Match
V Lookup+ Match + Search Box
V Lookup+ Match + Conditional Formatting
Offset
H Lookup
Match
Index
Rows
Columns
Reverse Lookup
Transpose
Financial Formula
PMT
IPMT
PPMT
Rate
PV
NPER
Function Formula
SUM
SUM IF
SUM IFS
SUM PRODUCT
SUM SQ
COUNT
COUNT A
COUNT IF
COUNT IFS
AVERAGE
Max
Min
Large
Small
Choose
Rank
CHART
Create Basic Chart
Create 2D & 3D Chart
Pie Chart
Line Chart
Column Chart
Bar Chart
Area Chart
Basic Dashboard Chart
Pivot Table
Intro Pivot Table
Create Simple Pivot Table
Basic & Advance Value Setting
Project
Power Pivot Table
Dashboard
Intro Dashboard
Create Simple Dashboard
Adding Table & Chart to Dashboard
Project work
Create Dynamic Dashboard
Macro
Intro Macro
Basic Recording Macro
Relative Macro Option
Absolute Option
Project work
Basic Macro Coding
VBA
Intro VBA
What can you do with VBA?
Basic VBA Coding
Recording VBA code
What Is Variable
Data Type
Massage Box
Button
If Else Statement
Looping
Macro Error
Basic Macro Coding
VBA formula Apply
Create User Form
Project Base Work
Tips & Trick
Excel Sheet Password Break
Excel Workbook Password Break
Online Excel Work
VBA Amazing Code
Short Cut key
Data Validation
Number System
Amazing tips and Trick
Project Work
TALLY ERP 9 with GST
Accounting
Introduction About Accounting
Basic term of Accounting
Journal Entry
Ledger Posting
Final Report
Trial Balance, Balance sheet, Profit & Loss, Trading Account
Trial Balance Error
Identify of Group
Depreciation
Adjustment Entry
Debtor
Cash & Bank Book
Discount
Bank Statement Entry
BRS
Project Work
TALLY ERP 9
Introduction About Tally ERP 9
Tally version
Tally Mode
Tally install & Startup
Company Info
Gate way of Tally
Accounts Info
Group & Ledger
Inventory Info
Stock item, Stock Group,Unit,Go downs
Ledger Configuration
Short Cut Key & Hot Key
Voucher
Accounting Voucher
Purchase Voucher
Sale Voucher
Payment Voucher
Contra Voucher
Debit Note
Credit note
Contra Voucher
Optional Voucher
Memo Voucher
Reversing Journal Voucher
Receipt Voucher
Journal Voucher
Voucher Configuration
Inventory Voucher
Purchase Order Processing
Sale Order Processing
Discount Allowed
Zero value Entry
Additional Cost of Purchase
Backup & Restore
Import & Export
Report Generate
Adjustment Entry
Bank Statement Entry
Debtor Entry
Fixed Asset on Deprecation
Discount Allowed Entry
BOM
Price List
Standard Rate
Payroll
Audit
See The All type of report
GST(Goods &Service Tax)
Introduction About GST
Gst Registration
Difference Between Regular & Composition Delar
GST Party Type
Gst Rate of Percentage
HSN code & SAC code
ITC
RCM
GST NO
Introduction About GST Return Filing
Live GST Return Filing
Regular Party GST Return Filing
Composition Party GST Return Filing
Nil Return
GST Payment
Late Fee, Penalty
New GST Return Filing
Create GST Excel Format Data
Live Project
TALLY ERP 9 WITH GST
Activation of GST in Tally ERP 9
Single GST Rate of Percentage Entry
Multiple GST Rate of Percentage Entry
GST Adjustment Entry
GST Entry for Goods
GST Entry for Service
Round off GST Invoice
Purchase & Sale Order Processing Under GST
Standard Rate
Import GST Entry in EXCEL
GST Entry for RCM on Purchase
GST Expenses Entry
Tally – GST Advance Payment & Receipt
Nil Rated Invoice Under GST
Offline GST Return Filing
Live Online GST Return Filing
New GST Return Filing
Live Tally with GST Company Level Project
PAYROLL
Introduction About Payroll
Activation Payroll
Payroll Info
Payroll Units Attendance and Production Type
Earning Pay Heads
Employee Deduction Pay Heads
Employee Contribution Pay Heads
Payroll Salary Structure
Payroll Income Tax
Payroll Voucher Entry
Payroll Report
TDS with GST
Introduction About Payroll
TDS Registration
TDS Activation in Tally ERP 9
TDS Journal Entry with GST
TDS Rate Chart
Full TDS Accounting Work
Income Tax Rule
TDS on Salary Calculation
TDS on Rent Calculation
ITR Return Filing
TDS Payment
TDS Report
Project Work
PROJECT WORK
Company Work Accounting
Hotel Accounting
Institute Work Accounting
Soap Accounting
DTP
Adobe Photoshop CC
• Introduction About Photoshop
• Photoshop Version
• Tools hide and unhide
• How to use all Photoshop tools
• Background change
• Hair Selection
• Dress Color change
• Hair color change
• Eye and lips color change
• Skin Retouching
• Layer Masking
• Manipulations
• Shortcut key
• Design Passport Size Photo
• Design Visiting card
• Design Poster and Banner
• Design small Video in Photoshop
• Background Design
• 3D Effect
• Logo Design
• Live Project Work
Corel Draw X8 2019
• Introduction About Corel Draw
• Corel draw Version
• Tools hide and unhide
• How to use all Corel draw tools
• Background change
• Design Visiting card
• Design Poster and Banner
• Background Design
• 3D Effect
• Logo Design
• Live Project Work
6 Months, 100% Job Placement Training For IT and non IT Students
BCIT WORLD, Shivpuri (Patna),Patna,IN