For Free HR Job Interview & Interview Q&A



Validation code:
Can't read the image? click HERE to refresh.

An ISO 9001:2008 & Award Winning Company

HR Spot offers Corporate oriented Basic and Advanced Excel for daily office work in the easiest way.

Best Human Resource Management Training Institute in Kolkata,Bhubaneswar and Hyderabad

Certified Expert in Microsoft Excel

OFFER Soft Skill and Interview Preparation session free of cost.
  • About The Course

Objective

Learn everything about MS-Excel. Learn all advanced features of MS-Excel required to do modern data management.

Duration

1 - 2 Month(s)

Class pattern

Weekly, Bi-Weekly, Weekdays, Saturday, Sunday

Syllabus

  • Basics
  • Basic of Excel, Basic MIS, Data Entry, Formatting

  • Advanced Formatting
  • Advanced Formatting, Conditional formatting

  • MIS Functions
  • Sorting, Filtering, Autosum, Working with Decimal, Custom number formats, Working with Dates

  • Corporate Excel
  • Inserting Comments, Freeze Panes, Shortcut keys, Autofill, Data validation, Find & Replace

  • Formula Basics
  • Absolute & Relative referencing, Excel Mathematical function: SUM(), AVERAGE(), MIN(), MAX(),ROUND()

  • Data cleaning
  • Data cleaning & functions: COUNT(), LEN(), LEFT(), RIGHT(), MID(), FIND(), SEARCH(), TRIM()

  • IF and Other
  • IF(), Nested IF(), AND(), OR(), SUMIF(), COUNTIF()

  • Advanced MIS Functions
  • MIS function: VALUE(), SUBSTITUTE(), VLOOKUP(), HLOOKUP(), COUNTBLANK(), Excel Graph & Chart

  • Reporting Tools
  • Macros, Pivot Table & Graph, Goal seek, Scenarios

  • Dashboard & Management
  • Working with MIS, Creating Dashboard, Protecting Excel file, Useful Shortcuts

  • Project & Evaluation
  • Corporate Excel, Project, Evaluation

    1. Role of HR & HRM

    Learning Objectives - The introduction to HR jobs and functions of HR manager in an organisation.

    Topics - What is HRM, Role & Responsibilities of HR, Qualities required for professional HR

    2. Recruitment & Sourcing

    Learning Objectives - In this module, you will be able to understand what Recruitment & Sourcing is. How Recruitment process and model works in an organisation. You will also be able to learn difference methods and process of Recruitment and how to function as Recruitment Manager in a company.

    Topics - Employee Life Cycle, Recruitment Basics, Recruitment Life Cycle, Selection vs. Recruitment, Selection Life Cycle, Manpower Planning, Recruitment Process, Types of Recruitment, Recruitment Process Outsourcing, Head Hunting, Job Description, Recruitment Sources, Recruitment Funnel, Recruitment Budget, Job Portal-Basic, Job Portal-Job Posting, Job Portal-Candidate Searching, Screening & Short listing, Recruitment MIS, Telephonic Screening, Types & Techniques of Interview, Interview Feedback, Documentation, Verification Process, Joining Formalities, Offer & Appointment Letter Recruitment, Induction & Orientation

    3. Compensation & Benefits

    Learning Objectives - This module is designed to share a clear idea and knowledge about compensation & Benefits structure of an organisation. You will learn about components of C&B package and various models of CTC structures.

    Topics - Basics of Compensation & Benefits, Components of C&B, Goals of balanced C&B package, Cost to Company (CTC), Components of CTC, CTC Designing, Difference between CTC, Gross Pay, Gross Salary and Net/Take Home Salary, Income Tax or TDS calculation.

    4. Payroll Management

    Learning Objectives - In this module, you will be able to understand how monthly salary is being calculated in an organisation. You will also get to learn about difference types of attendance & leave management process, Statutory deduction during monthly salary processing and how to generate salary slip after salary disbursement. 

    Topics - Monthly Payroll Management, Attendance Management, Leave Management, Monthly Salary calculation, Payslip generation, PF calculation, ESI calculation, P.Tax calculation.

    5. Performance Management

    Learning Objectives - This module will help you to understand how Performance Management System can change the company business strategy and how PMS can help the business to achieve the business goals. You will learn about Performance Management System, Goal setting and also about difference PMS methods & techniques. 

    Topics - Basic of Performance Management, What is Performance, Expectation versus Delivery, Objective of PMS, Role of HR in PMS, Process of PMS, Steps of PMS, Goal Setting, Key Result Area (KRA), Key Performance Indicator (KPI), How to design KRA & KPI, PMS frequency, Rating Scale, PMS Technique, PMS Form, Bell Curve, PMS rating errors, 360 degree feedback process, Talent Management, Balanced Score Card.

    6. Labour Laws

    Learning Objectives - Labour Law is very important for any HR function and in this module, you will learn about different important Labour Laws and how the laws can impact an organisation at various stage. 

    Topics - PF Act, ESI Act, Gratuity Act, Bonus Act, Shop & Establishment Act, Maternity Act.

    7. Statutory Compliances

    Learning Objectives - This module will cover difference activities related to Statutory Compliances which are needed to be followed by HR department to avoid any legal hassle. You will also learn few statutory mandate that each and every company needs to follow for smooth HR lawful operation. 

    Topics - Basics of Statutory Compliances, Standing Instructions, Managing Employee Disciplinary Process, PF Calculation, PF Online challan submission, ESI calculation, ESI online challan submission,

    8. HR Operation

    Learning Objectives - In this module, you will learn how HR team manages the difference operational activities of an organisation. You will get to know about different operational jobs of HR department and how to maintain the same properly. 

    Topics - What is HR Operation, What is Functional & Operational role of HR, Designing HR Policy, Personal Verification, Professional Verification, Educational Verification, Reference check, Documentation, Designing Offer & Appointment letter, Induction & Orientation, Confirmation Letter, Show Cause letter, Warning letter, Transfer letter, Termination letter, Exit formalities, Full & Final settlement, Release letter, Employee survey, Employee engagement, HR MIS.

    9. Advanced MS-Excel

    Learning Objectives - MS-Excel is considered as most important software required to manage HR functions. Hence you will learn about main features and functions of MS-Excel, which will help you in your daily life of HR jobs, without that knowledge nobody can survive. 

    Topics - Basic Excel, Features of Excel, Basic & Advanced Formatting, Conditional Formatting, Sorting, Filtering, Data Management, Basic mathematical Formula, IF, AND, OR, Chart/Graph, Freeze Panes, Locking the content, Vlookup(), Hlookup(), Pivot Table, Hyperlink, Data Validation.

    10. One to One Session

    Objectives - This is an personalised and customised session for each and every individual to discuss the career concern and to get proper career guidance. Choose proper growth path for your career with the consultation with HR expert. Redesign your Resume as per the need with professional guidance. 

    11. Mock Interview

    Objectives - This session is designed to prepare students for all rounds of personal and technical interview so that you can be rest assured about your selection post the training. You will be given all around guidance and simulation for real life interview environment so that your confident level can rise and you can be job ready. 

    During admission every candiadate is provided with a unique user id and passward with the help of which candiadtes can login online and can accesses the study materials.
    It's totally depends on the candidate credentials, but all the jobs are totally based on the HR functions.
    Anyone who is looking for knowledge in the field of HR with or without the expectation of placement.
    It depends on the nature of the batch assigned. For regular batches, their class for weekdays, it will be take two months and for weekend batch, it will be take three months.
    Two weeks to three weeks maximum.
    Yes, You are welcome to attend any one of our classes with our existing batch, which will be a free demo class for you.
    Yes, You can take multiple number of classes for any subject related to our course.
    Every module has its own importance, but Recruitment is the base of HR and Statutory is the pricipal of HR.
    Not only India, but HR is the backbone of a company, all over the World.
    At the completion of this course, a person will have a strong base on the operation and concept of HR or She will be industry ready to face the challenges.
    a fresher in HR can expect anything between 8K-12K to start off with depending on industry and Job role.

    HR Spot Certification Process:

    Every student has to attend all subjects and has to complete the training maximum within 5 months. He/She has to submit the requisite project work, assignment and case studies as per the instruction of the trainer.

    Once you are successfully through with the project (reviewed by an expert), you will be eligible for the final Online Certification test. The student will be awarded with the certification once he/she qualifies in the Online test. 

    If you do not qualify in Online final test in 1st attempt, more attempts will be provided. You can take additional assistance to understand the concepts better, attend more classes and reattempt the Test free of cost.
    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Ipsita Sah

    Batch No: 20
    Enrollment No:Feb/19/2016/11

    Talk to her on Facebook

    Lots Of learning,Healthy environment,Good in Recruitment and selection. Got a job from HR SPOT.Thanks to HR SPOT Team.

    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Annesha Ghosh

    Batch No: 23
    Enrollment No:Jun/03/2016/271

    Talk to her on Facebook

    HR SPOT has provided us with all the technical and academic assistance as and when required. I am extremely happy to be a part of HR SPOT family

    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Niladri Mukherjee

    Batch No: 20
    Enrollment No:Feb/07/2016/1

    Talk to him on Facebook

    HR SPOT gives me the chance to grow my professional career. I got so many learning opportunities here, management are very suppotive.

    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Ujjwal Pradhan

    Batch No: 21
    Enrollment No:Feb/28/2016/141

    Talk to him on Facebook

    I have done HR course from HR SPOT. I am very much satisfied with the job and course as well. Thanks to HR SPOT Team.

    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Indrani Ray

    Batch No: 19
    Enrollment No:Jan/12/2016/118

    Talk to her on Facebook

    Ofcourse, in many ways. The course materials and the method of teaching is very good and has relevance to the actual industry practices.

    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Kajori Majumder

    Batch No: 19
    Enrollment No:Feb/12/2016/6

    Talk to her on Facebook

    It was a good experience throughout. I being from a different background altogether did not faced any difficulties and was possible because of HR Spot.

    HR Spot Certification Process:

    Every student has to attend all subjects and has to complete the training maximum within 5 months. He/She has to submit the requisite project work, assignment and case studies as per the instruction of the trainer.

    Once you are successfully through with the project (reviewed by an expert), you will be eligible for the final Online Certification test. The student will be awarded with the certification once he/she qualifies in the Online test. 

    If you do not qualify in Online final test in 1st attempt, more attempts will be provided. You can take additional assistance to understand the concepts better, attend more classes and reattempt the Test free of cost.
    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Ipsita Sah

    Batch No: 20. Enrollment No:Feb/19/2016/11

    Lots Of learning,Healthy environment,Good in Recruitment and selection. Got a job from HR SPOT.Thanks to HR SPOT Team.

    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Annesha Ghosh

    Batch No: 23. Enrollment No:Jun/03/2016/271

    HR SPOT has provided us with all the technical and academic assistance as and when required. I am extremely happy to be a part of HR SPOT family

    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Niladri Mukherjee

    Batch No: 20. Enrollment No:Feb/07/2016/1

    HR SPOT gives me the chance to grow my professional career. I got so many learning opportunities here, management are very suppotive.

    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Ujjwal Pradhan

    Batch No: 21. Enrollment No:Feb/28/2016/141

    I have done HR course from HR SPOT. I am very much satisfied with the job and course as well. Thanks to HR SPOT Team.

    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Indrani Ray

    Batch No: 19. Enrollment No:Jan/12/2016/118

    Ofcourse, in many ways. The course materials and the method of teaching is very good and has relevance to the actual industry practices.

    Best HR Certification Course in Kolkata,Bhubaneswar and Hyderabad

    Kajori Majumder

    Batch No: 19. Enrollment No:Feb/12/2016/6

    It was a good experience throughout. I being from a different background altogether didn’t faced any difficultieswhile changing the role. This was possible because of HR Spot.

    Want to get a call from us to know more?

    Validation code:
    Can't read the image? click HERE to refresh.

    Course Features

    We can provide you 100% written job placement guarantee in our company letter head,as per terms and conditions. If we are unable to provide job,then the course fees will be refundable.
    Internship plays a valid role for every freshers.For that reason, HR Spot provide Internship programme for freshers.We will also provide experience certificate.
    Practical training is a very important part for every employee, so HR Spot providing 100% HR practical training.
    Projects and assignments are the most important part of HR practical training.Projects and assignments is making this programme more realistic.
    HR Spot will arrange unlimited classes incase of absent or any doubt clearance on particular subject matter.
    If you need to crack an interview, We must have proper knowledge of interview technics and proper mannerism. So HR Spot provide you Grooming and interview session.
    Individual portal access will be granted to the candidates,which include study material project,home task, case studies and other helpful resources.
    A good HR person should have knowledge in Excel, So we are providing advance Excel session. Now those days SAP very demanding in HR career, so HR Spot is giving you chance to learn SAP module totally free of cost.

    Other Training Programs

    HR Generalist Training in kolkata,Bhuabneswar,Berhampur and Hyderabad

    Human Resource Management Professional

    HR Operational Management Course

    Operational Human Resource Management

    HR Operational Management Course

    Certified Recruitment & Sourcing Manager

    HR Practical Training institute

    Certified Compensation Benefits Manager

    PMS training institute in kolkata,Bhuabneswar,Berhampur and Hyderabad

    Certified Performance Management Professional;

    Statutory Compliance and Labour Law Training

    Certified Statutory Compliances Manager

    Testimonial

    100% satisfied students and their words speak for us. Connect with them. Get to know about us.