Microsoft Excel for HR and Administrative Professionals training centre in Bangladesh


Microsoft Excel for HR and Administrative Professionals

  • Date : 14 - 15 October 2022
  • Duration : Day(7:00 PM-10:00 PM)
  • No. of Classes/ Sessions : 2 Days
  • Class Schedule : Friday & Saturday
  • Total Hours : 16
  • Last Date of Registration : 12 October, 2022 ( within 5pm )
  • Venue : Online Virtual
  • Training certificate will be provided within 10 working days after completion of training successfully.


Human Resource Management and Administration requires good hands on knowledge in Microsoft Excel. Day to day HR and Admin data analysis, reporting, tools and applications are prepared with Excel. It will be an advantage for course attendees to learn practical and advanced usages of Excel in HR and Admin field. Excel allows us to accomplish a task in multiple ways which will be shown to attendees with Pros and Cons of the methods.

How participants will benefit after the course
HANDS ON EXPERIENCES. Most widely practiced HR and related Excel topics are covered in the course syllabus with practical exercises. Participants will do the live exercises along with the trainer to learn faster and effectively. Learning the required Excel functionalities in course will ensure participants high performance in their career and academics.


Interactive class

Contents of Training:

1. Highlight above and below average performers

2. Count number of managers or any designation in a company

3. Find number of employees joined on particular date/month in an department in any country

4. Total number of employees in the company in different departments

5. Dynamically calculate monthly salary expenses

6. Find the total salary expenses in different regions, different departments

7. Find length of service or age in years, months and days

8. Find tenure/years of service of employees

9. Find the number of leaves taken by any employee with Pivot Table

10. Calculate number of yearly leaves taken by employees with Formula

11. Validate the hire/join date upon data entry

12. Set the department of an employee through data validation

13. Creating custom series for skills, departments, job positions etc.

14. Measuring the cost of staff turnover

Related Courses

Md. Feroz Kibria
  • 30 Sep - 1 Oct 2022

Having good spreadsheet skills therefore gives you the ...

Syed Saniat Ahmmad
  • 12 - 26 Oct 2022 (5 Sessions)

Practical examples, exercises & case studies with ...

Syed Saniat Ahmmad
  • 20 Oct - 1 Nov 2022

Practical examples, exercises & case studies with ...

Md. Feroz Kibria
  • 28 - 29 Oct 2022 (2 Sessions)

Having good spreadsheet skills gives you the ability to ...

Executives, Managers, Teachers, Developers, Students, Researchers and people who use Microsoft Excel for HR and Admin related activities
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Resource Person

Md. Feroz Kibria

Human Resources and Soft Skills Specialist

Md. Feroz Kibria has been involved in training, coaching and consulting for more than 10 years with the intention of dramatically increasing profit, productivity and the performance of people.

After completing his MBA & BBA in HR & Accounting, Feroz joined the corporate world and gaining experience in Human Resources Management and training in diversified industries e.g. Telecommunications, Networking Accessories, Customer Services, Engineering and Automobiles.

He also completed a certificate course on “People Management Skills for Professionals (PMSP)” from IBA, University of Dhaka under MDP (Management Development Program).

Through the experience from the local and multinational businesses operating in Bangladesh, Feroz has gained a versatile knowledge for the requirement of core development areas to build the strongest career.

Today, Feroz trains a wide range of Soft Skills like Microsoft Office Programs (Excel, PowerPoint, Access, Publisher, Visio, Word, Outlook and others), Time Management, Strategic Compensation & Benefits, Financial Modeling, Leadership & Team Building, Corporate Etiquettes, etc.

Feroz is passionate in inspiring lives and transforming people. Because of the dedication, he is well known for his energetic and power-packed training sessions.

His quest for continuous Human & Talent Development promises highly energizing and power-packed training style. He helps clients transferring knowledge into ready-to-use skills.

Interactive class

social link fb social link fb social link fb