MIS & DATA ANALYST PRACTICAL TRAINING

1.    WHAT IS EXCEL?

Microsoft Excel is a general-purpose electronic spreadsheet used to organize, calculate, and analyze data. The task you can complete with Excel ranges from preparing a simple family budget, preparing a purchase order, create an elaborate graph/chart, or managing a complex accounting ledger for a medium size business

BASIC & ADVANCE EXCEL 

OBJECTIVE:

Provide Basic/Advanced Understanding of Excel, make user familiar to create formula and give platform to make good analysis and introduce Powerful tools of advance excel so that user can make advance analysis with the help of those tools.

• Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.
  • SUM,COUNT, COUNTA, COUNTBLANK, AVERAGE, MAX, LARGE MIN, ABS, SUMIF, COUNTIF, SUMIFS, COUNTIFS, LOWER, UPPER, PROPER, TRIM, LEN, LEFT, RIGHT, MID, CONCATENATE, SUBTOTAL,AND, OR, DAY, YEAR, EOMONTH, EDATE, NETWORKDAYS, TODAY, WEEKDAY, WEEKNUMBER, WORKDAY, FIND,SEARCH, VLOOKUP, HLOOKUP, MATCH, IFERROR, IFNA, IF, INDEX, OFFSET
• Filters (Basic, Advanced , Conditional), Sort ( Ascending, Descending, Cell/ Font Colour), Single and Multiple Charts/Graphs, Conditional Formatting, Data validation, Group & ungroup, Data split.
• Pivot Table and Chart, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display

DASHBOARD & VBA

 OBJECTIVE

Dashboard reports allow user to get high-level overview of the business and help them make quick decisions. Dashboards are often called as management information system (MIS), which provides information that organizations require to manage themselves efficiently and effectively.

• To define KPIs (Key performance Indicator), Customer Service Dashboards or Project Management Dashboard (Gantt Chart)
• Dashboard reports based on Tables and number or Charts/Graphs or Both.VBA (Visual Basic Programming) is generally known as VBA Macros which comprises of UDFs (User Defined Functions) and generally used to simplify repetitive task.
• Macro Recording, Create user defined function, User Form Concepts, Report Automation, Outlook Connectivity, Command Buttons, Worksheets/Workbooks Functions.

1. MS- Access

INTRODUCTION TO MS- ACCESS, CREATE QUERY, TABLES AND RELATIONSHIPS, BASIC QUERIES USING SQL

2.  Payroll Processing

• Pay structure
• Leave management (CL, EL, SL, and ML)
• Basic, HRA, DA, Conveyance, Medical allowance, Lunch allowance etc
• PF, ESIC, Bonus, Gratuity, Overtime, Calculations, Deductions. etc
• Calculation of Gross , Net salary & CTC
• Preparation of Break- up salary, Designing CTC and salary break up and discussion on Compensation and benefits.

3.1 TAX PLANNING FOR SALARIED EMP.

• PT- Slab Process
• TDS (Salaried People)
• Slab Process of TDS
• Calculation of TDS for Men, Women, Senior Citizens
• Education Cess
• Routine Tax Planning
• Tax Exemptions Under different Sections

3.2 PAYROLL REPORTING

• PF report in Excel sheet
• ESI report in Excel sheet
• Professional report Tax

BATCH DETAIL :

Regular Batch : 1.5, Month

Weekend Batch : 12 Sundays.

Fast Track Batch : 5 Days ( Full Time Class )

MEGARA InfoTech PVT. LTD.
ADDRESS : NM 29, Old DLF Colony,Sector-14,Gurgaon (HR)122001

Mob ; +91-9999858239, Tel: +91 124-4058233

Visit : www.megara.co.in

Follow us at : http://www.facebook.com/Megarainfotech

ACCOUNTS & TAXATION PRACTICAL TRAINING

We, at Megara InfoTech are dedicated to offering satisfactory training to all the professionals and students who are seeking to enhance their career.

Detail of Accounts & Taxation Practical Training

MODULE 1-- BALANCE SHEET FINALIZATION-- BY CHARTERED ACCOUNTANT
Passing Routine and Book Closure Entries in Tally ERP 9
Preparation of Bank Reconciliation Statement (BRS) in Tally ERP 9
Preparation of P & L Balance Sheet as per Schedule III of Companies Act, 2013.

MODULE 2 - FINANCE-- BY CHARTERED ACCOUNTANT
Ratio Analysis
Preparation of Fund Flow Statement and Cash Flow Statement
Working Capital Management

MODULE 3 - BANKING- BY CHARTERED ACCOUNTANT
Financial Instruments
Bank Guarantee
CC/OD
L/Cs

MODULE 4- PAYROLL PROCESSING- BY CHARTERED ACCOUNTANT
Monthly Payroll Processing
PF Computation, ECR Prepare & Online Filing, Generate Chalan & TRRN and Online Payment.
ESI Computation, MCS Prepare & Online Filing, Online Challan Payment and Return (Form 5)
TDS on Salary, Return Form 24Q

MODULE 5- LABOUR LAW'S-- BY CHARTERED ACCOUNTANT
Definition
Different clauses
Procedure to be followed
Register to be maintained

MODULE 6- TAXATION-- BY CHARTERED ACCOUNTANT
I) INCOME TAX
Income Tax Computation
Taxability of Different Allowances and Perquisites
Deductions (Tax Savings) under Chapter VI A
E-Filing TDS on Salary, Return Form 24Q and Online Challan 281
E-Filing ITR and Online Challan 280

II) TDS ON NON SALARY
Accounting for TDS Receivable and Payable in Tally ERP 9
TDS Rates and E-Payment of Online Challan 281
Filing TDS Return Form 26Q
Checking of Form 26AS
Procedure of Form 15CB and 15CA

MODULE 7- BASIC CONCEPT OF GST
Introduction of CGST, SGST and IGST
Central Goods and Services Tax
State Goods and Services Tax

MODULE 8- LEVY OF, AND EXEMPTION FROM, TAX
Levy and Collection of Central / State Goods and Services Tax
Composition levy
Taxable person
Power to grant exemption from tax
Remission of tax on supplies found deficient in quantity

Module 9. REGISTRATION
GST Registration
Special provisions relating to casual taxable person and non-resident taxable person
Amendment of registration

Cancellation of registration
Revocation of cancellation of registration

Module 10. TIME AND VALUE OF SUPPLY
Meaning of Supply
Time of supply of goods
Time of supply of services
Place of Supply
Change in rate of tax in respect of supply of services
Value of taxable supply

Module 11. INPUT TAX CREDIT
Transfer of input tax credit
Manner of taking input tax credit
Taking input tax credit in respect of inputs sent for job work
Manner of distribution of credit by Input Service Distributor
Manner of recovery of credit distributed in excess

Module 12. PAYMENT OF TAX
Payment of tax, interest, penalty, and other amounts
Interest on delayed payment of tax
Tax deduction at source

Module 13. RETURNS
Furnishing details of outward supplies
Furnishing details of inward supplies
Tax Return Preparers
Online Returns
Claim of input tax credit and provisional acceptance there of Matching
Reversal and re-claim of input tax credit Matching
Reversal and re-claim of reduction in output tax liability Annual return
Final return
Levy of late fee

Module 14. TAX INVOICE, CREDIT AND DEBIT NOTES
Tax invoice
Amount of tax to be indicated in tax invoice and other documents
Credit and debit notes

Module 15. ACCOUNTS AND RECORDS
Accounts and other records
Period of retention of accounts
Collection of tax at source
Special procedure for removal of goods for certain purposes

Module 16. ASSESSMENT AND AUDIT
Self-assessment
Scrutiny of returns
Assessment of unregistered persons
Summary assessment in certain special cases
Audit by tax authorities
Special audit

Module 17. REFUNDS
Refund of tax
Interest on delayed refunds

Module 18. MIS-ADVANCE EXCEL - BY MIS ANALYST
Provide Basic Understanding of Excel, make user familiar to create formula and give platform to make good analysis and introduce Powerful tools of advance excel so that user can make advance analysis with the help of those tools Topics Covered
Introduction, Basic Undersatanding , Sum,Count, Counta, Countblank, Average, Max, Large Min, Abs, Sumif, Countif, Lower, Upper, Proper, Trim, Len, Left, Right, Mid, Concatenate, Subtotal,And, Or, Day, Year, EOmonth, Edate, Networkdays, Today, Weekday, Weeknumber, Workday, Find,Search
Vlookup, Hlookup,Day and Time Calculation, Numeric Calculation, If Logical Condition, Dynamic Pivot, Dynamic Chart, Conditional Formating, Dated if, What Ifanalysis, Match index, Offset function, User form function in excel, Data validation, Advance filter, Sorting, Group & ungroup, Data split, Text function (data sepration), Substitue

SOFT SKILL
Time Management
Communication Skill
Motivation
Interview Tips

• CV Revision in a professional approach.
• Placement Support Assured.
• We Provide excellent Practical oriented course material for all the topics.

Batch Details :  

Regular Batch : 2.5 Month.

Weekend Batch : 20 Sundays.

Fast Track : 15 days (Full Time Class)

MEGARA INFOTECH PVT. LTD.
ADDRESS : M 46, OLD DLF COLONY, SECTOR-14,(HR)

Mob: +91-9999858239,Tel : 0124-4058233

Visit : www.megara.co.in

Follow us at : www.facebook.com/Megarainfotech