Advanced Excel (MIS)
We not only clear the theoretical basics but also impart comprehensive practical training to students through its courses that helps them to be industry ready by the end of carreer courses.
1. Excel Basic: Training on Excel Basics eg. formating, basic calculation formulas, how to work on different sheets etc..
2. Use of essential formulas and calculation methods. Eg. VLOOKUP PIVOT table, if related formulas HLOOKUP and many more.
3. How to prepare different types of graphs using excel.
4. Basic Knowledge to prepare macros
5. Short cut methods to enhance efficiency
1. Practical Application of Labour Laws (like minimum wages act, gratuity, bonus act etc..)
2. Payroll (CTC and NTH breakup) in excel.
3. Joining Formalities.
4. Leave Policy.
5. Preparation of Attendance Sheet in Excel.
6. Preparation of Salary Sheet, Paysheet.
7. Full and Final Settlement.
8. Exit Formalities.