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.
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
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
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
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)
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.
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
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
Accounting Students
Finance Students
Business Owners
Anyone who is interested in Accounting
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)
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.
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.
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.
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
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)