dots bg

Diploma In Computer Application and Accounting

All in one, job oriented and Industry ready package!

Course Conducted in : हिंglish | मराठी | English

 

Eligibility :

  1. 10th Standard
  2. 12th Standard (Arts / Com. / Sci.)
  3. Graduated in Any Stream

₹15000.00 ₹28500.00 47% OFF

To enroll in this course, please contact the Admin
dots bg

Course Overview

  • Basics of Computer
  • Operating System
  • MS-Word 2021
  • Working with Documents
  • MS-Excel 2021
  • Data Maintaining with Spreadsheet
  • MS-PowerPoint 2021
  • Prepare successful Presentation
  • Internet
  • Printing & Scanning
  • Many More

  • Fundamental Introduction
  • Entering and editing worksheet data
  • Essential worksheet Operations
  • Working with Cell and Ranges
  • Introduction of Table
  • Introduction of Formulas and Functions
  • Worksheet Formatting
  • Workbook Operations
  • Designing Excel with Templates
  • Printing Work
  • Working with data
  • Data Formatting

  • Customisation of Software
  • LEN, UPPER, LOWER, PROPER
  • List Sort & Filter
  • Creating formulas that lookup values
  • MIS with Pivots Tables
  • MIS with Xlookup Function
  • Types of Charts
  • Conditional Formatting
  • Dashboard
  • Use of Data Validation

  • About Tally Software
  • Basics of Tally
  • Accounting Masters creation
  • Accounting Entries
  • Inventory Management
  • Purchase process
  • Sales Process
  • Banking
  • Accounting with Services
  • Data Maintenance & Exchange
  • Reports Working
  • Tax Deducted at Source
  • Depreciation
  • Additional Concepts Under tally

  • Logo Designing
  • Templates Designing
  • Digital Marketing Posts Designing
  • Photo Editing
  • Working with Live Projects
  • Formats
  • Photo album Video
  • Video mixing
  • Audio mixing
  • Voice note
  • Timeline Work
  • Live Project Works

  • New Office 365 Features
  • Spill Arrays
  • Dynamic Formulas
  • Xlookup
  • Power Filter Formula
  • Unique Formula
  • Funnels & Map Charts
  • MINIFS & MAXIFS
  • Data Types
  • Importing Stock Data in Excel Dynamically

 

Including Certification -

  • CENTRAL BOARD OF IT & VOCATIONAL TRAINING Certification (CBITVT) /
  • INFORMATION TECHNOLOGY COUNCIL Certification (ITC) /
  • DiTRP

Duration : 4-5 Months

Eligibility : 

  1. 10th Standard
  2. 12th Standard (Arts / Com. / Sci.)
  3. Graduation in Any Stream