8368722963 info@nxaeon.com Admin Login

DCA

With the growing demand of computers and the role it plays in our life, more and more skilled professionals are required to take care of the finer points. With new innovations in this arena there is a growing demand for computer professionals with a sound understanding of basic computer applications in business covering key programming languages, database management, systems analysis, computer software development in specific applications such as studies, financial management and long range planning.

It studies various computer applications like MS Office, Internet applications, Operating System, Database Management System, HTML among other subjects. A person who has completed DCA can apply as a computer operator in any firm. He or she can get placed at clerical levels like receptionist, computer operator or cyber cafe owner. He can also work at BPO. DCA diploma holder can execute basic computer tasks and can also become an Accountant. He/she can also become a computer teacher at primary level or can also own Computer teaching Centre for children or adults who wish to learn computer basics.

 

 

Syllabus of DCA

Introduction to Computer System

  • Basic Computer Concept
  • Computer Organization
  • Windows OS
  • Windows XP Vs Windows 7
  • Windows 10

Microsoft Office

  • MS Word
  • MS Excel
  • MS PowerPoint

Internet & its Usage

  • Internet Basics
  • E-Business
  • Software Hacking & IT security

Multimedia

  • Photoshop
  • Adobe Premiere
  • Adobe InDesign

Miscellaneous

  • Internet & its usage
  • PC Assembly & Maintenance
  • Basics of Programming languages
  • Basic networking Concept

Multimedia

  • Photoshop
  • Adobe Premiere
  • Adobe InDesign

Miscellaneous

  • Internet & its usage
  • PC Assembly & Maintenance
  • Basics of Programming languages
  • Basic networking Concept

Tally ERP with GST

Tally prepares your GST returns simultaneously while you do the accounting entries (Sales, Purchase, Payment, Receipt, Journals etc.) And looking at the complications in GST Regime, preparing your GST Returns manually would be a very very difficult task if the number of transactions are high. Nx-aeon is one of the best training institute in Mayur Vihar Phase for Tally ERP 9 with GST. We not only provide training on Tally ERP 9, we also provide practical training on Goods & Services Tax (GST), All Income Tax Returns, Tax Audit, MIS Reporting, TDS Returns, Firm Registrations, ROC Returns, Balance Sheet Finalization by Experienced faculties & Industry Experts.

Syllabus of Tally ERP 9 with GST

 

Tally ERP 9 Basics

  • Company Info Menu
  • How to select company and  Shut Company
  • How to Create Company, How to alter company
  • How to Create Group Company
  • How to apply Security Control
  • How to Split company data
  • How to take Backup
  • How to restore Backup
  • How to use Tally Audit Feature

Tally ERP 9 Specific Configuration

  • How to fill up country details
  • How to change styles 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 Tally Audit Feature.
  • How to use general
  • 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 Email
  • How to do Data configuration

Accounts  Information and 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
  • Inventory Information
  • How to use Accounting features
  • How to use Inventory features

 Setting Inventory Configuration & Inventory Info Menu

  • How to set up stock Group
  • How to set up Stock categories
  • How to create Stock Items
  • How to create Units of measurement
  • Inventory voucher types

Accounting and Order Voucher

  • Purchase voucher entry
  • Receipt voucher entry
  • Journal voucher entry
  • Contra voucher entry
  • Purchase order entry
  • Sales order entry

Inventory Voucher

  • Payment voucher entry
  • Sales voucher entry
  • Debit note & Credit note voucher entry
  • Receipt note entry
  • Delivery note entry
  • Rejection in  & Rejection out entry
  • Stock journal entry
  • Manufacturing Journal entry
  • Physical stock voucher entry

 

Advanced Accounting Features

  • How to create cost categories & Cost centres
  • How to configure check printing
  • How to set credit limits
  • How to do Bank reconciliation

Tax Deducted at Sources (TDS)

  • What is TDS PROCESS?
  • How to prepare and issue of TDS certificate
  • How to do filling E-TDS return
  • Enabling TDS
  • What is nature of TDS related payments?
  • Deductive Types
  • How to create TDS masters
  • How to Pass TDS voucher entries – Transactions How to do pass TDS on expenses (General entries)
  • How to do pass expenses party subject to TDS (General entries)
  • How to do accounting multiple expenses & deducting letter
  • How to do TDS on advance payments
  • How to do adjusting advances against the bill
  • How to do changes in TDS percentage computation
  • TDS Challan Reconciliation print form 16A
  • Form 26Q Annexure to 26Q
  • Form 27Q Annexure to 27Q
  • Form 26 and Form 27
  • Annexure to 26
  • Annexure to 27 E- Return
  • E- TDS print form 27A

Payroll

  • 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 Employee State – Insurance
  • (ESI) Reports Professional Tax Report

Display of Reports

  • Accounting reports
  • Trial Balance, Profit & Loss and Balance Sheet
  • Inventory Reports
  • Stock Summary
  • Sales Register
  • Purchase Register
  • Tax Reports- Challans , Registers
  • E-filing
  • Payroll Reports
  • Pay Slip
  • Salary Register
  • PF Challan and ESI Challan
  • MIS Report
  • Receivables & Payables

Goods & Services Tax (GST)

  • GST Account Creation
  • SGST/ CGST/ IGST
  • Voucher Entry of GST with different rates
  • HSN Code classifications
  • GST Tax Classification
  • Various classifications of Goods & services

Data Analytics

Data analytics is the process of examining data sets in order to draw conclusions about the information they contain. It enable organizations to make more-informed business decisions keeping all the aspects of analytics in mind. There is a step by step process in Data Analytics which assists the business to know their existing strategies’ loopholes and lapses. Data Analytics can act as a tool for the Data Analysts rather than a trouble. The depths of Data Analytics can amaze you to the extent of starting your own business with Data Analytics as your partner. To realize and accept the true nature and power of DA we have dwell into it.

Data analytics is primarily conducted in business-to-consumer (B2C) applications. Global organizations collect and analyze data associated with customers, business processes, market economics or practical experience. Data is categorized, stored and analyzed to study purchasing trends and patterns.

Evolving data facilitates thorough decision-making. For example, a social networking website collects data related to user preferences, community interests and segment according to specified criteria such as demographics, age or gender. Proper analysis reveals key user and customer trends and facilitates the social network’s alignment of content, layout and overall strategy.

Syllabus of Data Analytics

Data Analytics

  • Warming up
  • Setting up machine
  • The basics of Python language
  • Regular Expressions in Python
  • Scientific libraries in Python – NumPy, SciPy, Matplotlib and Pandas
  • Effective Data Visualization
  • Scikit-learn and Machine Learning
  • Practice and deep learning

Python

Python is a general-purpose interpreted, interactive, object-oriented and high-level programming language. Currently Python is the most popular Language in IT. Python adopted as a language of choice for almost all the domain in IT including Web Development, Cloud Computing (AWS, OpenStack, VMware, Google Cloud, etc), Infrastructure Automations , Software Testing, Mobile Testing, Big Data and Hadoop, Data Science, etc. This course to set you on a journey in python by playing with data, creating your own application, and also testing the same.

Syllabus of Python

An Introduction to Python

  • Brief History
  • Why Python
  • Where to use

Beginning Python Basics

  • The print statement
  • Comments
  • Python Data Structures & Data Types
  • String Operations in Python
  • Simple Input & Output
  • Simple Output Formatting

Python Program Flow

  • Indentation
  • The If statement and its’ related statement
  • An example with if and it’s related statement
  • The while loop
  • The for loop
  • The range statement
  • Break & Continue
  • Assert
  • Examples for looping

Functions & Modules

  • Create your own functions
  • Functions Parameters
  • Variable Arguments
  • Scope of a Function
  • Function Documentation/ Docstrings
  • Lambda Functions & map
  • An Exercise with functions
  • Create a Module
  • Standard Modules

Exceptions

  • Errors
  • Exception Handling with try
  • Handling Multiple Exceptions
  • Writing your own Exceptions

File Handling

  • File Handling Modes
  • Reading Files
  • Writing & Appending to Files
  • Handling File Exceptions
  • The with statement

Classes in Python

  • New Style Classes
  • Variable Type
  • Static Variable in class
  • Creating Classes
  • Instance Methods
  • Inheritance
  • Polymorphism
  • Encapsulation
  • Scope and Visibility of Variables
  • Exception Classes & Custom Exceptions

Regular Expressions

  • Simple Character Matches
  • Special Characters
  • Character Classes
  • Quantifiers
  • The Dot Character
  • Greedy Matches
  • Grouping
  • Matching at Beginning or End
  • Match Objects
  • Substituting
  • Splitting a String
  • Compiling Regular Expressions
  • Flags

Data Structures

  • List Comprehensions
  • Nested List Comprehensions
  • Dictionary Comprehensions
  • Functions
  • Default Parameters
  • Variable Arguments
  • Specialized Sorts
  • Iterators
  • Generators
  • The Functions any and all
  • The with Statement
  • Data Compression
  • Closer
  • Decorator

Thread in Python

  • Thread life Cycle
  • Thread Definition
  • Thread Implementation

Network Programming Introduction

  • A Daytime Server
  • Clients and Servers
  • The Client Program
  • The Server Program
  • Recap
  • An Evaluation Client and Server
  • The Server Portion
  • A Threaded Server

Python MySQL Database Access Introduction

  • Installation
  • DB Connection
  • Creating DB Table
  • INSERT, READ,UPDATE, DELETE operations
  • COMMIT & ROLLBACK operation
  • Handling Errors

Project Work

Advanced Excel

Advanced Excel is the tool that maximizes the data of companies that will be able to store, compare and analyze information effectively. Excel gives you the ease of using graphics and empower you to use of formulas, tables that are used in reports presentations, sales and others. Among the tools Excel includes ways to identify trends by means and averages that will be useful when seeking explanations of the behavior of certain figures. Advance Excel is especially for students and working professional who wants to gain necessary to use pivot tables, audit worksheet data, vlookup, utilize data tools. Create, Edit and Format all applications will be easily used in excel application. If you want to learn Advanced Excel Training then you can come to nx-aeon at Mayur Vihar Phase-III, New Delhi.

Introduction and Basic MS Excel

  • Customizing common options in Excel
  • Absolute and relative cells
  • Protecting and unprotecting worksheets and cells

Working with Functions

  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • VlookUP with Exact Match, Approximate Match
  • Nested VlookUP with Exact Match
  • VlookUP with Tables, Dynamic Ranges
  • Nested VlookUP with Exact Match
  • Using VLookUP to consolidate Data from Multiple Sheets

Data Validations

  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell

Working with Templates

  • Designing the structure of a template
  • Using templates for standardization of worksheets

Sorting &  Filtering Data

  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting
  • Filtering data for selected view (AutoFilter)
  • Using advanced filter options

Working with Reports

  • Creating subtotals
  • Multiple-level subtotals
  • Creating Pivot tables
  • Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables
  • Pivot charts
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources
  • Using data consolidation feature to consolidate data
  • Show Value As (% of Row, % of Column, Running Total, Compare with Specific Field)
  • Viewing Subtotal under Pivot

Advanced Excel More Functions

  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Formatting 

  • Using auto formatting option for worksheets
  • Using conditional formatting option for rows, columns and cells

whatIf Analysis

  • Goal Seek
  • Data Tables
  • Scenario Manager

Advanced Excel More Functions

  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Charts

  • Using Charts
  • Formatting Charts
  • Using 3D Graphs
  • Using Bar and Line Chart together
  • Using Secondary Axis in Graphs
  • Sharing Charts with PowerPoint / MS Word, Dynamically

New Features of Excel

  • Sparklines, Inline Charts, data Charts
  • Overview of all the new features

 

Creating Macro

  • Type of VBA Macro.
  • Display of Developers Tab and VB Editor.
  • Macro Security.
  • How to record a VBA Macro
  • Execution of recorded Macro.
  • Editing the recorded Macro
  • Various Keyboard Shortcuts related to VBA Macros.
  • Working on Various Examples of Macro recorder
  • Introduction to the writing of basic VBA codes
  • Saving Off Your Macro.
  • Introduction to the Personal Macros

Programming Writing Concepts

  • Defining Variables to Macro.
  • Discussion on different Types of Variables.
  • Use of Local Window.
  • Working on Programming, Understanding on VBA Language.
  • Introduction of Message Box in Macro.
  • Introduction of Input Box In Macro.
  • Use of decision making statements in Macro by using: If and Else conditions, And /OR conditions.

Working with Loops and Worksheet Ranges

  • Introduction of the loops in Macro
  • Use of Different type of loops like, For & Next LOOP, For & Each Loop, Do & Until LOOP While and While and Wend Loop
  • Working with ranges like selecting, copying and pasting the ranges and extract the data on same Worksheet level
  • Selecting, copying and pasting the ranges and extract the data on different Worksheet level in the same Workbook
  • Selecting, copying and Pasting the Ranges and extract the data on different Workbook Level.

Writing of Formulae in VBA an Error handling

  • Introduction of programming concepts for writing the Excel Formulas
  • Difference between the A1 and R1C1 style of writing formula in VBA
  • Look at the style A1 and R1C1 and decide which is better
  • Find out the better solution to write the formulas in VBA
  • Writing of the basic formulas in to VBA
  • Writing of the complex formulas in to the VBA
  • Writing of Logical formulas and Lookup formulas in VBA
  • Freezing of the formula in VBA
  • Other useful formulas to be write in Class
  • Error handling

Advanced VBA Functions

  • What is User Defined Function
  • Use of User Defined Function
  • How to create any Function OR Formula which is not available in Excel
  • What is ADD-IN
  • Use of ADD-IN and How to create ADD-IN.
  • What are Events
  • How and when to use the VBA Events.
  • VBA User Forms
  • What are User Forms,
  • Why to create User Forms and How to create User Forms

Project