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