M.I.S Course In Kanpur

Join M.I.S program 8 Months Course at VFX Era kakadeo, Kanpur.

M.I.S Certification Course 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. Join M.I.S Course Vfx Era Kakadeo Kanpur.

M.I.S Course Modules

Office Automation Syllabus

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

Statistical Analysis Using MS Excel Syllabus

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

Database Management Using MS Access Syllabus

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

Web Productivity Tools Syllabus

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

Tally GST Professional

Module 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

Module 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

Module 3 -

F12 Configuration
Setting up Account Heads
F11 Features

Module 4 - Inventory In Tally ERP 9

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

Module 5 Accounts Info In Tally ERP9

Single Ledger Creation
Multiple Ledger Creation
Display Ledger
Alter Ledger

Module 6 - Accounting Voucher Entry In Tally ERP9

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

Module 7 - Inventory Voucher

Stock Transfer
Physical Stock Verification

Module 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

Module 9 - Advance Accounting In Tally ERP9

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

Module 10 - Advance Inventory In Tally ERP9

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

Module 11 - Technological Advantages Of Tally ERP 9

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

Module 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

Module 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

Module 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)

Module 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

Module 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

Module 17 - Practical GST Work in Tally

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

Module 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

Module 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

Module 20 - Tax deducted at sources

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

Module 21 - Return

GSTR 1
GSTR 2
GSTR 3B

Module 22 - TCS (Tax Collected at Sources)

Introduction of Financial Accounting

Direct Tax (Basic Concept of Income Tax

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

Ratio Analysis

Programming Practices & Techniques

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

Programming in VBA

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