Diploma in Computer Application Courses In Mumbai
JM Computer Institute offers one of the best Diploma in Computer Application Courses in Mumbai. The institute offers an DCA ITC Certification Course.
It has a dedicated team of skilled teachers who provides practical training to help the students develop a better future.
Our DCA Course includes
- Basic + MS-Word
- Basic + Advanced Excel
- Basic + Advanced Tally
- Project Works & Online Exam
Course Fees
-
Course Duration: 6 Months
-
ITC Course Certification.
-
100% Placement Assistance.
-
Hands on Practical Experience
-
Expert Trainers
Computer Introduction
♦ Computer functions
♦ Computer software
♦ Input, Processing and Output
♦ Computer Equipment
♦ Getting to Know the Keyboard
♦ Saving and Retrieving files
♦ Making Changes and Corrections
♦ Accessing the Internet
♦ Basic Navigation
♦ Opening Image Files
♦ Points to Note When Accessing a
Web Page
♦ Create, save, delete, send, read, reply, forward and print a mail
♦ Use address book or mailing list to send e-mail to a group of recipients
MS-Windows
♦ Get Started with Windows
♦ Navigate the Windows 10 Desktop
♦ Use the Start Menu
♦ Use Desktop Applications
♦ Use Windows Universal Apps
♦ Multitask with Open Apps
♦ Install Apps from Windows Store
♦ Manage Files and Folders with File Explorer
♦ Store and Share Files with OneDrive
♦ Customize the Start Screen
♦ Customize the Desktop and Lock Screen
Internet
♦ What is it and why do we use it?
♦ Structure of the Internet
♦ History of the Internet
♦ Introduction to the Internet – The Basics
♦ Getting to know the URL
♦ Navigating through the Browser tool bar
♦ Browser Window
♦ Learning to Navigate
♦ Keyboard shortcuts
♦ Internet Bookmarks
♦ Surfing the net
♦ Researching on the net
♦ Search Engines
♦ Search Techniques
♦ Business Models
♦ Browser Set Ups & Maintenance
♦ Judging Information Value
♦ Plagiarism
♦ Security
♦ Privacy
♦ What is social media and why use it?
♦ Activities
♦ Components
♦ Why use email?
♦ Productivity Tools
♦ Email addresses
♦ Email providers
♦ Security issues
♦ Setting up an email account
Basic + Advanced Excel Courses Module with ITC Certification.
Elevate your Excel skills to new heights with our Advanced Excel Mastery Course at JM Computer Institute. Learn complex formulas, data analysis tools, pivot tables, Power Query, VBA programming, and more. Gain hands-on experience, personalized feedback, and a recognized certification. Enroll now and excel in data analysis!
♦ Interface
♦ Menu System
♦ Fundamentals of Spreadsheets
♦ Short Cut Keys
♦ Changing Excel’s Default Options Using AutoCorrect and Customizing It Customizing the Ribbon
♦ Using Functions – Sum, Average, Max, Min, Count, Counta
♦ Absolute, Mixed, and Relative Referencing.
♦ Upper, Lower, Proper
♦ Left, Mid, Right
♦ Trim, Len, Exact
♦ Concatenate
♦ Find, Substitute
♦ Today, Now
♦ Date, Date if, DateAdd
♦ Day, Month, Year
♦ Month, Weekday
♦ SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs
♦ Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
♦ Basic conditional formatting
♦ File Level Protection
♦ Workbook, Worksheet Protection
♦ Setting Up Print Area
♦ Customizing Headers & Footers
♦ Designing the structure of a template
♦ Print Titles –Repeat Rows / Columns
♦ Paste Formulas, Paste Formats
♦ Transpose Tables
♦ Paste Validations
♦ Filtering on Text, Numbers & Colors
♦ Sorting Options
♦ Advanced Filters on 15-20 different criteria(s)
♦ Setting Up Print Area
♦ Print Titles –Repeat Rows / Columns
♦ Designing the structure of a template
♦ Customizing Headers & Footers
♦ Goal Seek
♦ Data Tables (PMT Function)
♦ Solver Tool
♦ Scenario Analysis
♦ Number, Date & Time Validation
♦ Dynamic Dropdown List Creation using Data Validation – Dependency List
♦ Custom validations based on a formula for a cell
♦ Text and List Validation
♦ If Function
♦ Complex if and or functions
♦ Nested If
♦ How to Fix Errors – iferror
♦ Vlookup / HLookup
♦ Vlookup with Helper Columns
♦ Creating Smooth User Interface Using Lookup
♦ Index and Match
♦ Reverse Lookup using Choose Function
♦ Nested VLookup
♦ Worksheet linking using Indirect
♦ What are the Array Formulas, Use of the Array Formulas?
♦ Array with if, len, and mid functions formulas.
♦ Basic Examples of Arrays (Using ctrl+shift+enter).
♦ Advanced Use of formulas with Array.
♦ Array with Lookup functions.
♦ Creating Simple Pivot Tables
♦ Classic Pivot table
♦ Basic and Advanced Value Field Setting
♦ Calculated Field & Calculated Items
♦ Grouping based on numbers and Dates
♦ Planning a Dashboard
♦ Adding Dynamic Contents to Dashboard
♦ Adding Tables and Charts to Dashboard
♦ Using SLICERS, Filter data with Slicers
♦ Various Charts i.e. Bar Charts / Pie Charts / Line Charts
♦ Manage Primary and Secondary Axis
Basic + Advanced Tally Courses Module with ITC Certification.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
♦ How to Select company
♦ How to Shut company
♦ How to Create company
♦ How to Alter company
♦ How to apply Security control
♦ How to Change tally vault
♦ How to Split company data
♦ How to take Back up
♦ How to Restore Back up
♦ How to use Tally audit features
♦ How to fill up Country details
♦ How to change Style of dates
♦ How to Configuration of numbers
♦ How to use Other options
♦ Loading A Company
♦ How to Select company
♦ How to change Company name
♦ How to set Financial year
♦ How to use Accounting features
♦ How to use Inventory features
♦ How to activate Functions in accounts info. Menu
♦ How to prepare Groups Tally ERP 9
♦ How to prepare Ledgers
♦ How to enter Voucher entries
♦ How to use Numeric symbols
♦ How to use Accts/inventory info.
♦ How to pass Voucher entry
♦ How to prepare Invoice / orders entry
♦ How to take Printing
♦ How to send E- mailing
♦ How to do Data configuration
♦ How to create cost categories & cost Centres
♦ How to configure Cheque printing
♦ How to set Credit limits
♦ How to do Bank Reconciliation
♦ Payment voucher entry
♦ Receipt voucher entry
♦ Journal voucher entry
♦ Sales voucher entry
♦ Purchase voucher entry
♦ Debit note voucher entry
♦ Credit note voucher entry
♦ Purchase order entry
♦ Sales order entry
♦ Receipt note entry
♦ Delivery note entry
♦ Rejection out entry
♦ Rejection in entry
♦ Stock journal entry
♦ Manufacturing journal entry
♦ Physical stock voucher entry
♦ How to set Inventory configurations & features Inventory info. Menu
♦ How to set up Stock groups
♦ How to set up Stock categories
♦ How to create Stock items
♦ How to create Units of measurement
♦ How to create Bills of materials Locations / Godown
♦ Inventory voucher types
♦ What is TDS Process
♦ How to prepare and Issue of TDS Certificate
♦ How to do Filing of E-TDS Return
Enabling TDS
♦ What is Nature of TDS related payments Deductee types
♦ How to Create TDS Masters (Expense ledger, Party Ledger, Tax ledger)
♦ How to pass TDS Voucher Entries/Transactions
♦ How do pass TDS on expenses (Journal Voucher)
♦ How to pass Expenses partly subject to TDS (Journal voucher)
♦ How to do Accounting multiple expenses and deducting TDS later
♦ How to record TDS on advance payments
♦ How to do Adjusting advances against the bill
♦ How to Changes in TDS Percentage Computation
♦ TDS Challan Reconciliation Print Form 16A
♦ Form 26Q Annexure to 26Q Form 27Q Annexure to 27Q
♦ Form 26
♦ Annexure to 26
♦ Form 27
♦ Annexure to
♦ 27 E-Return
♦ E-TDS, Print form 27A
♦ How to Enabling payroll in tally
♦ How to generate pay slip
♦ How to Create Payroll Masters
♦ How to pass Payroll Voucher Entry
♦ How to view Statements of payroll
♦ How to view Attendance-Reports
♦ How to view Payroll Statutory
♦ Reports Payroll Statutory
♦ Computation Employees Provident Fund (EPF)
♦ Reports Employees State -Insurance (ESI)
♦ Reports Professional Tax Report, Gratuity Report
♦ GST Account Creation
♦ SGST / CGST/ IGST
♦ Voucher entry of GST with different rates
♦ HSN Code classifications
♦ Various classification of Goods and Services
♦ Payment of GST
♦ Filing of Challan GST
♦ GST Returns like :-GSTR1, GSTR2, GSTR3, GSTR4
♦ Accounting Reports
♦ Trial Balance
♦ Profit & Loss
♦ Balance Sheet
♦ Inventory Reports
♦ Stock Summary
♦ Sales Register
♦ Purchase Register
♦ Tax Reports- Challans, Registers
♦ E Filing
♦ Payroll Reports
♦ Pay Slips
♦ Salary Register
♦ PF Challan
♦ ESI Challan
♦ MIS Reports
♦ Receivables
♦ Payables
FAQ's
It depends on the course you select. Class will be 6 days in a week. Sunday will be holiday. Each day course will be for 1 hour.
You will receive an ITC Certification (Information Technology Council) which is government recognised and valid all over India.
Yes definitely you will be getting support after the course. But it depends on what kind of support you need.
At the time of enquiry we use to do counselling of the candidate, understand their needs and accordingly suggest them their best courses.
Any course you select, it would be knowledge based. Less theory and more practical. We provide project works to do, to rectify your mistakes and clear your doubts.
Any course you select, it would be knowledge based, it would develop your skill and it would be helpful for you to crack any interview related to the course and your educational qualification.
