MIS & DATA Analysis Training In Pitampura Delhi

DIPLOMA IN MIS & DATA ANALYSIS

Descriptions

Module 1: OFFICE MANAGEMENT (MS-OFFICE)

WORD (OFFICE Documentation)

  • WORD (OFFICE Documentation)
  • Page Setup, Text formatting, Data Proofing, Paragraph setting, Header & footers
  • Mail Merge, Table (Applying Math formulas in table)
  • PROJECT (Resume, Official Application, Letter, etc.)

ADVANCE EXCEL (STATISTICAL ANALYSIS)

  • Basics of Mathematics Calculation, Customizing Excel sheet and workbook, Referencing
    (Relative, Absolute, Mixed), Various Functions & formulas
  • Data Importing & Exporting, Recording and Editing Macros, Sorting and filtering, Data Validation,
    Pivot Table, If-And analysis, What-If Analysis
  • H Lookup – V Lookup, Consolidation of Multiple Sheets, Scenarios, Goal Seek, Naming Cell Range,
    Password Protection, Analyzing Data with Charts
  • Creating Reports, Printing Reports , etc. (PROJECT)

POWERPOINT (Presentation & Projects)

  • Slide Layout, Slide Transition, Slide Show, Animation, Sound and Video Effects
  • Working with Advanced Tools and Masters, Inserting Illustrations

MS- OUTLOOK (MANAGING BULK e-MAILS)

Module 2 (VBA MACRO PROGRAMMING )

Create a Macro

  • With Excel VBA you can automate tasks in Excel
    by writing so called macros. In this chapter, learn how to create a simple macro.

MsgBox

  • The MsgBox is a dialog box in Excel VBA you can
    use to inform the users of your program.

Workbook and Worksheet Object

  • Learn more about the Workbook and Worksheet object in Excel VBA.

Range Object

  • The Range object, which is the representation of
    a cell (or cells) on your worksheet, is the most important object of Excel VBA.

Variables

  • This chapter teaches you how to declare, initialize and
    display a variable in Excel VBA.

If-Then Statements

  • Use the If Then statement in Excel VBA to execute code
    lines if a specific condition is met.

Loop (While, For and For Each loop )

  • Looping is one of the most powerful programming techniques.
    A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.

Array

  • An array is a group of variables.
    In Excel VBA, you can refer to a specific
    variable (element) of an array by using the array name and the index number.

Function

  • In Excel VBA, user defined function can be used.

Control

  • Learn how to create control such as command button.

Module 3 (Tally (ERP) WITH G.S.T.)

BASICS OF ACCOUNTING (With Project

  • BASICS OF ACCOUNTING
  • Ledger Posting, Bill wise details, Cost center, Allow Invoice
  • TDS(Tax deducted at source), TCS(Tax collecting at sources)
  • Debit note and Credit note, Price list, Bill of material
  • Check printing, Zero value entry,
  • Multiple Godown, Integrate account and inventor
  • Budgets and scenario management
  • Maintain stock categories
  • Maintain batch wise details (set expiry dates for batches)
  • Use different actual and billed quantity
  • Separate discount column on invoices
  • Use tracking number (delivery/receipt notes)
  • Use rejection inward/outward notes
  • Payroll (Basic Salary, HRA, TA, DA, PF, ESI, Net Salary)
  • Profit and Loss Statement, Balance Sheet

Module 4: MS- Access

  • Table Creation (Designing View, Wizard, Setting Relationship
  • Query Management (Designing View, Wizard, Sorting, Applying condition, Formulas)
  • Form Building : (Designing View & Wizard View)
  • Report & Label Creation (Designing View & Wizard View)
  • Importing – Exporting
  • Query Building (Cross Tab, Unique, Duplicate, Delete, Update, Append etc.)
  • Setting up Relationships

Module 5: MySQL RDBMS(Relational Database)

  • RDBMS Terminologies (Attribute, Records, Entity, Entity Set etc.)
  • Data Integrity (Entity Integrity, Referential Integrity)
  • Types of Keys ( Primary Key, Foreign Key, Super key etc. )
  • Data Types in SQL ( Char, Varchar, Numeric, Date, Long etc.)

Integrity Constraints

  • Primary Key, Not Null, Unique, Check, Default
  • References, On Delete Cascade

Types of SQL Commands (DDL, DML, DCL)

  • Creating a Database Table (Create Table Command)
  • Alter Table, Update Table
  • Inserting Data in Table
  • Retrieving information from Table (Select Command)
    • Conditional Retrieval using Where
    • Use of Logical Operator (AND, OR, NOT) with where.
    • Special Operator IN, NOT IN, BETWEEN, NOT BETWEEN
    • Use of Wild Card Operator.
    • DISTINCT clause with Select
    • Working with NULL Values.
    • Using Expression with column
  • Working with Date
  • Arranging of Records in Table (ORDER BY).
  • Group By (Creating Smaller Groups in a Table)
  • Having Clause
  • Aggregate Functions (Count, Sum, Max, Min, Avg etc.)
  • Arithmetic Functions (ABS, CEIL, FlOOR, MOD, POWER etc.)
  • Character Functions (CHR, ASCII, LOWER, UPPER, SUBSTR etc.)
  • Date Functions (SYSDATE, ADD_MONTHS, LAST_DAY etc.
  • Query With Multiple Tables ( JOINS)
  • Using Table Alias
  • SET OPERATORS (UNION, INTERSECTION, MINUS ETC)
  • NESTED QUERIES
      • Using Aggregate Functions In Nested Queries
      • Using Special Operators (EXISTS, NOT EXISTS, ANY, ALL)
  • Corelated Queries
  • Updating and Deleting Columns From a Table
  • QUERIES ON VIEW
  • Data Controlling Using Grant And Revoke Command
  • Indexes (Create, Alter, Drop), Clustered-Non Clustered Index
  • Transaction Management (Begin, Commit, Rollback, Save)
  • Triggers (Creating, Altering and Dropping Triggers)
  • Magic Table
  • Procedures and Functions
  • Procedures and Functions
  • Temp Table (Local and Global)

Module 6: NET BANKING & ONLINE RETURNS (E-Filing)

  • Internet Banking (Corporate and Individual Login)
  • Beneficiary Management (Addition and Deletion of PAYEE, Setting Transaction Limits etc.)
  • Fund Transfer (NEFT, RTGS, Third Party Transfer etc.)
  • E-Filing Of TAX
  • Filling Income Tax Return [ Form 16-A], e-Filing TDS and GST etc.,
  • Revised Returns
  • Utility Payment through Net Banking, Debit Card, IMPS, e-Wallet etc.

Quick Contact

Are You Looking For MIS & DATA Analysis Training ?
Open chat