MGM Institute Of Management & Research
(A Constituent Institute of MGM University, Aurangabad)
(NAAC Accredited - Grade 'A' )
ISO 9001:2015 & 14064:2006 Certified
MGM Institute Of management
MGM Institute Of management & research
MGM Institute Of Management And Research
(A Constituent Institute of MGM University, Aurangabad)
(NAAC Accredited - Grade 'A' )
ISO 9001:2015 & 14064:2006 Certified
Programs offered for all

Overview:

Microsoft Excel is perhaps the most important software programme being used today. It has become a necessity in both business and professional life, irrespective of the role the hierarchy, the business function or the industry. This course has been designed in such a way as to enable the learner to gain a complete understanding of the advanced excel concepts and apply such concepts to their relevant role and business.

Outcomes:

At the end of this course, you will be able to:

Master Microsoft Excel from Beginner to Advanced

Differentiate yourself at work, quickly and dramatically using the power of Excel

Create dynamic reports by mastering one of the most popular tools, PivotTables and Dashboards

Unlock dynamic formulas with If, Vlookup, Index, Match functions and many more



Content

Basic MS Excel

Advance Numeric, Logical, Text, Data , Date, Lookup, Array and Finance Function

Advance Conditional Formatting

Data Filtering, Data Validation, Data Sorting, What-if-Analysis, Data Consolidation

Pivot Table, Dashboards

Protecting Worksheets



Who This Course is for:

Excel users who have basic skills but want to get better

Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level

Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

Excel users looking to build strong analytical thinking and business intelligence skills



About the Trainer:

Dr. Abhijeet Birari is an Assistant Professor at MGMIOMR having experience of more than 10 years. He specializes in Financial Modelling and is also an MS Excel trainer. He has trained many students and professionals in basic as well as advanced excel.

Duration :4 Weeks (10 Hrs) (Friday and Saturday, 2 hours per day)

Fee: Rs. 1000 per participant.

Overview:

Business Accounting is considered as the language of business. The one who is in the field of business or intending to be a business owner needs to have a clear understanding of fundamental aspects of accounting for profitability of the business. The success of a business depends upon how a businessman takes financial decisions; these financial decisions are taken from the data provided by accounting. On completion of this course the learner shall be able to gain insights into fundamental theoretical and practical aspects of Accounting with its applicability in business.

Outcomes:

understand the need and importance of accounting

interpret and apply the accounting principles, concepts and conventions

describe various terms used in accounting

prepare books of accounts

find and correct errors in accounting

prepare and communicate the financial data for various users of accounting information



Content

Introduction to Accounting

Bookkeeping

Accounting - Objectives and Types

Accountancy, Accounting and Bookkeeping

Accounting Principles, concepts and conventions

Terms used in Accounting

Accounting System - Single and Double entry accounting

Methods of Accounting

Account - Types

Rules of Debit and Credit

Journal

Ledger

Subsidiary books

Trial Balance

Accounting Errors

Rectification of errors

Final Accounts



Who This Course is for:

Accounting Students

Finance Students

Business Owners

Anyone who is interested in Accounting



About the Trainer:

Prof. Hrishikesh S Kakde is an Assistant Professor at MGMIOMR having experience of 5 years. He has trained many students in accounting.

Duration : 5 Weeks (18 Hrs) (Friday and Saturday, 2 hours per day)

Fee: Rs. 550 per participant.

Overview:

Filing ITR on time is beneficial in many ways while keeping you tax- compliant.Individuals whose annual income is in excess of the basic exemption limit of Rs 2.5 lakh must mandatorily file their income tax returns. Even when there is no tax liability, an income tax return (ITR) must be filed if the total income exceeds the above-mentioned threshold. Income tax return is a form in which taxpayers declare details of income, deductions, exemptions, and taxes payable on their taxable income. Filing income tax return is mandatory to claim tax deductions under Section 80C, 80D, etc. and other eligible exemptions like long-term capital gains exemptions, which may eventually bring your taxable income to zero.

Outcomes:

E File Income Tax Return of a salaried employee.

Claim various deductions to make taxable income minimum.

Understand procedure of appeal.

Understand the various penalties in case of non filing of return, concealing income etc.



Content

Prerequisites of Income Tax Filing

Understanding relevance of Tax credit Statement, Form 16 while filing return.

E Filing Procedure

Procedure for appeal and penalties in case of nonfiling and concealing of income.



Who This Course is for:

Individuals like salaried persons to comply with ITR filing requirements every year.

Anyone wants to learn and earn by e filing.

Students from commerce and management



About the Trainer:

Dr. Jitendrasinh Jamadar is a management graduate with specialization in Finance. He is approved Management Faculty in Savitribai Phule Pune University since February 2009 and awarded Ph. D on topic “A Study of Microfinance and its contribution in Economic Development with Special Reference to Latur and Nanded Districts in the State of Maharashtra”, from Savitribai Phule Pune University. He taught subjects such as Accounts, Financial Management,Direct Taxation to MBA Students. He was also a visiting faculty at D Y Patil, University, Vishwakarma University Pune for MBA Course. Sinec 2017 he is associated with MGM Institute of Management under MGM University as Assistant Professor.

Duration : 4 Weeks (16 Hrs) (Friday and Saturday, 2 hours per day)

Fee : Rs. 1500 per participant