VFX ERA: Best Computer Training Courses Institute in Kanpur

The Smart Pro – MIS Advanced Program is designed to help you begin your first step in IT programming through the principal language. It will also train you to develop, test, and modify VBA procedures, You will also learn business accounting and inventory management for small & medium businesses, which will help you develop as an MIS expert.

Introduction to Computer Basics
Introduction to Windows 8
Introduction to the Internet
Using Google Products
Getting Started with Microsoft Excel 2016
Features of Microsoft PowerPoint 2016
New features in Word 2016
New Features in Excel 2016
Getting Started with Microsoft Word 2016
Formatting in Microsoft Word 2016
Working with Lists, Tables, and Graphics
Additional Features in Microsoft Word 2016
Using Formulas and Functions
Introduction Microsoft Outlook 2016
New Features in PowerPoint 20 16
New Features in Outlook 2016

Sharing and Maintaining Workbook
Formulas and Functions
Advanced Chart Features
Presenting Data Visually
Data Analysis
Macros and Forms

Introduction to Microsoft Access 2016
Working with Tables
Working with Queries
Working with Forms
Working with Reports
Working with Macros
Web Databases Using Access

Introducing Google Applications
Working with Mails
Managing Google Drive and Docs
Working with Google Sites
Additional Google Tools

1 - Financial Accounting

Introduction and Meaning of accounting
Meaning of bookkeeping
Objective of accounting
Rules of debit and credit, Golden rules
Meaning of double-entry mode system
Depreciation
Preparation of journal ledger, Trial balance,
Exercise journal entry and trading profit and balance sheet
Financial statement trading and profit of loss account
Financial statement with adjustment

2 - Fundamental Of Tally ERP 9

Getting Started With Tally ERP
Company deleting process in Tally ERP
Company Creation/ Setting Up Company in Tally ERP

3 - Features

F12 Configuration
Setting up Account Heads
F11 Features

4 - Inventory In Tally ERP 9

Stock Group
Stock Category
Go Down/ Location
Unit of Measure
Stock Item

5 - Accounts Info In Tally ERP 9

Single Ledger Creation
Multiple Ledger Creation
Display Ledger
Alter Ledger

6 - Accounting Voucher Entry In Tally ERP 9

Purchase Voucher
Sales Voucher
Payment Voucher
Receipt Voucher
Contra Voucher
Journal Voucher

7 - Inventory Voucher

Stock Transfer
Physical Stock Verification

8 - Sales Invoice In Tally ERP 9

Company Bank Details Coolum in Sales Invoice
Creation of Sales Invoice
MRP Column Sales Invoice
Meaning of Sales Invoice
Discount on Sales Invoice
Insert discount Coolum in sales invoice

9 - Advance Accounting In Tally ERP 9

Bill Wise Details
Cost Center Cost Categories
Voucher Class
Multiple Currencies
Interest Calculation
Budget and Control

10 - Advance Inventory In Tally ERP 9

Tracking Number
Rejection In
Rejection Out
Order Processing
Purchase Order
Sales Order
Different Actual and Bill Quantities
Debit Note
Credit Note
Batch Wise Details
Additional Cost of Details
Price Level and\ Price List
Zero Value Entry

11 - Technological Advantages Of Tally ERP 9

Back-Up Restore/li>
Split Company Data
Export and Import Data Tally to Excel
Tally Vault
Security Control

12 - Extra Additional Advance Option In Tally ERP 9

Manufacturing Practical Process
Party Interest transaction
Party Cheq Bounce Entry
Credit Limit Set In Debtors Report
Advance Receipt from Customer Adjustment
Bank Loan Interest Calculation Module transaction
Reminder Latter
Adjustment Entry in Journal Voucher
Bank Reconciliation

13 - Payroll Accounting And Compliance

Configuring Payroll in Tally ERP 9
Creating Payroll Master
Creating Unit (Work) Creation
Attendance/ Production Type
Employee Salary Details
Payroll Voucher Class
Pay Heads
Employee Group Creation
Employee Name Creation
Creation
Employee Attendance Voucher

14 - Goods And Service Tax introduction

About Goods and Service Tax
Registration in GST
Understanding SGST CGST IGST
Meaning OF Regular Dealer
Meaning OF Consumer
Input tax credit
Returns
Tax Rates and classification
Tax invoice, credit and debit note
HSN codes
Activating Tally in GST
Creating Master in Tally ERP
Meaning OF Composition Dealer
Meaning OF Unregistered Dealer
Accounts and records
E waybill
Payment of tax
Time value of supply
Refund
Offenses penalties
Audit
Branch transfer
Setting Up GST (Company Level, Ledger or Inventory Level)

15 - Purchase Voucher With GST

Updating GST Number for Supplier
Practical on Intra-State Purchase Entry in GST (SGST+CGST)
Practical Interstate Purchase - State Purchase Entry in GST(IGST)
GST Purchase Entry for Unregister Dealer in tally

16 - Sales Voucher With GST

Updating GST NUmber for Customer Ledger
Practical on Intra-State Sales Entry in GST (SGST+CGST)
Practical Interstate Sales-State Sales Entry in GST(IGST)
Creating Sales Invoice in Tally
Multiple Tax Rate Invoice in GST
Practical GST Sales Invoice Practice
GST Voucher Class creation in Tally ERP

17 - Practical GST Work in Tally

POS Invoice
Reverse Charges Entry
Insert MRP Colum in GST Invoice
Debit note and credit note

18 - Auditing

Meaning of Audit
Scope of Auditing
Objective of Auditing
Main Features of Auditing
Difference Between Accounting and Auditing
Statutory Audit
Private Audit
Government Audit
What Are the Type of Audit
Audit Note Book
Audit working paper
Audit File

19 - Banking

Type of Nationalization Bank in India
PPF Account
Current Account
Saving Account
Recurring Account
Fixed Deposit Bank Account
Advantages of Online Banking
Types of cheques
Meaning of NIFT
Meaning of RTGS
Practical in Tally (Banking Option)
Cheque Printing
Cheque register
Deposit Slip
Post Dated Cheque
Payment Advice

20 - Tax deducted at sources

The basic concept of TDS
Configuration TDS in Tally ERP 9
Creating Ledger
Processing transaction
TDS report

21 - Return

GSTR 1
GSTR 2
GSTR 3B

22 - TCS (Tax Collected at Sources)

Basic Concept
Residence and scope of Total Income
Heads of Income

Income from Salary
Income from House property
Profit and Gains from Business and Profession
Income from other sources
Income from Other Sources

Deductions from gross total income
Computation of total income and tax payable
TDS and its Provisions

Introduction to Computers
Introduction to Programming Tools
Flowcharts and Pseudo codes
Selection Constructs
Operators
Iteration Constructs
Structured Programming
Arrays
File Handling
Data Flow Diagrams
Elements of Programming Language

Essentials of Spreadsheet Application Development
Introducing Visual Basic for Applications
VBA Programming Fundamentals
Working with VBA Sub Procedures
Creating Function Procedures
Understanding Excel's Events
VBA Programming Examples and Techniques
Working with Pivot Tables
Working with Charts
Interacting with Other Applications
Working with External Data and Files
Leveraging Custom Dialog Boxes
Introducing UserForms
UserForm Examples
Advanced UserForm Techniques
Creating and Using Add-Ins
Working with the Ribbon
Working with Shortcut Menus
Providing Help for Your Applications
Leveraging Class Modules
Understanding Compatibility Issues

Courses Details

MIS Course

Tools

1 - Financial Accounting

2 - Fundamental Of Tally ERP 9

3 - Features

4 - Inventory In Tally ERP 9

5 - Accounts Info In Tally ERP 9

6 - Accounting Voucher Entry In Tally ERP 9

7 - Inventory Voucher

8 - Sales Invoice In Tally ERP 9

9 - Advance Accounting In Tally ERP 9

10 - Advance Inventory In Tally ERP 9

11 - Technological Advantages Of Tally ERP 9

12 - Extra Additional Advance Option In Tally ERP 9

13 - Payroll Accounting And Compliance

14 - Goods And Service Tax introduction

15 - Purchase Voucher With GST

16 - Sales Voucher With GST

17 - Practical GST Work in Tally

18 - Auditing

19 - Banking

20 - Tax deducted at sources

21 - Return

22 - TCS (Tax Collected at Sources)

CAREER COUNSELLING

Job Aspect

Our Courses

Get in touch

Subscribe

Courses Details

MIS Course

Tools

What will you learn from this course?

Module 1: Office Automation Syllabus

Module 2: Statistical Analysis Using MS Excel Syllabus

Module 3: Database Management Using MS Access Syllabus

Module 4: Web Productivity Tools Syllabus

Module 5: Tally GST Professional

1 - Financial Accounting

2 - Fundamental Of Tally ERP 9

3 - Features

4 - Inventory In Tally ERP 9

5 - Accounts Info In Tally ERP 9

6 - Accounting Voucher Entry In Tally ERP 9

7 - Inventory Voucher

8 - Sales Invoice In Tally ERP 9

9 - Advance Accounting In Tally ERP 9

10 - Advance Inventory In Tally ERP 9

11 - Technological Advantages Of Tally ERP 9

12 - Extra Additional Advance Option In Tally ERP 9

13 - Payroll Accounting And Compliance

14 - Goods And Service Tax introduction

15 - Purchase Voucher With GST

16 - Sales Voucher With GST

17 - Practical GST Work in Tally

18 - Auditing

19 - Banking

20 - Tax deducted at sources

21 - Return

22 - TCS (Tax Collected at Sources)

Module 6: Introduction of Financial Accounting

Module 7: Direct Tax (Basic Concept of Income Tax)

Module 8: Ratio Analysis

Module 9: Programming Practices & Techniques

Module 10: Programming in VBA

CAREER COUNSELLING

Job Aspect

Our Courses

Get in touch

Subscribe