HR Analytics Using Excel

By Subbulakshmi Somu   |   Dayananda Sagar College of Arts, Science and Commerce
Learners enrolled: 8544
The course "HR Analytics using Excel" is designed to equip learners with the knowledge and skills to effectively utilize Excel as a tool for Human Resources (HR) data analysis and decision-making. In the 8-week course, learners will discover the basics of HR analytics and master Excel skills to process, analyse, and visualize HR data effectively.They will explore various HR analytics concepts, such as descriptive, diagnostic, predictive, and prescriptive analytics, and understand their applications in HR management. The course will cover topics such as creating HR dashboards, trend line analysis, correlation, and regression using Excel. Learners will gain hands-on experience in applying Excel's features and functions to interpret HR metrics, identify trends, and make data-driven decisions. Additionally, they will explore real-world examples and cases of HR analytics to understand how data insights can drive strategic HR initiatives and improve workforce management. By the end of the course, learners will be proficient in creating dynamic HR dashboards, conducting various data analyses, and presenting HR analytics insights effectively. Whether for talent acquisition, employee performance evaluation, or workforce optimization, "HR Analytics using Excel" empowers learners to leverage Excel's capabilities to enhance HR decision-making.
Course Status : Completed
Course Type : Core
Duration : 8 weeks
Category :
  • Management Studies
Credit Points : 3
Level : Postgraduate
Start Date : 19 Jan 2024
End Date : 30 Apr 2024
Enrollment Ends : 29 Feb 2024
Exam Date : 18 May 2024 IST
Shift :

Shift 2

Note: This exam date is subjected to change based on seat availability. You can check final exam date on your hall ticket.

Page Visits

Course layout

Week 1: Introduction to HR Analytics 
Week 2: Data and Its Types
Week 3: Descriptive Analytics through Data Visualization 
Week 4: Descriptive Analytics - Data statistics
Week 5: Diagnostic Analytics
Week 6:  Predictive Analytics
Week 7: Prescriptive Analytics
Week 8: Reporting and Dashboard creation

Click here for syllabus page

Exam schedule

Books and references


Instructor bio

Subbulakshmi Somu

Dayananda Sagar College of Arts, Science and Commerce
Dr. Subbulakshmi Somu is an Associate Professor at Dayananda Sagar College of Arts, Science and Commerce. Her areas of teaching are Organizational Behaviour, Human Resource Management, Strategic HRM, and HR Analytics. With a strong academic background, she holds a Ph.D. in Human Resource Management from Annamalai University, Chidambaram, Master's degree in Business Administration from Anna University, Chennai, where she was a university rank holder. Additionally, she has completed her M.Sc. in IT from Madras University and is also NET qualified. Her research areas include Strategic Human Resource Management, HR Analytics, Nudge Theory, and Entrepreneurship. She has presented her research papers at prestigious national and international conferences, including the PAN-IIM World Management Conference and the International conference at IBS, Hyderabad, where she received accolades for her outstanding work, including best paper awards. She published in Scopus-indexed and peer-reviewed UGC-approved journals. She is an esteemed reviewer for the Academy of Management (AOM) and various other journals of international repute. She also holds the distinction of being a certified Mendeley advisor by Elsevier, UK, reflecting her expertise in reference management and high-quality publishing. She has conducted numerous Faculty Development Programs (FDPs) and workshops for faculties and research scholars across the country. Her workshops have focused on topics like high-quality publishing, reference management, and research tools such as SPSS, Smart PLS, Psychometrics, and mediation and moderation analysis.

Course certificate

Enrolling and learning from the course is free. However, if you wish to obtain a certificate, you must register and take the proctored exam in person at one of the designated exam centre’s. The registration URL will be announced when the registration form is open. To obtain the certification, you need to fill out the online registration form and pay the exam fee. More details will be provided when the exam registration form is published, including any potential changes. For further information on the exam locations and the conditions associated with filling out the form, please refer to the form.

Grading Policy: 

Assessment Type


Mid-Term & End-Term


Final Exam


Certificate Eligibility:
  • 40% marks and above in Mid Term & End Term
  • 40% marks and above in the final proctored exam


Type of Certificate



75 - 89


70 - 74


40 - 70

Successfully Completed


No Certificate

Sample Certificate:

Disclaimer: In order to be eligible for the certificate, you must register for enrolment and exams using the same email ID. If different email IDs are used, you will not be considered eligible for the certificate.

MHRD logo Swayam logo


Goto google play store