Microsoft Excel for HR and Administrative Professionals
- Date : 05 - 06 August 2022
- Duration : Evening(7:00 PM-10:00 pm)
- No. of Classes/ Sessions : 2 Days
- Class Schedule : Friday & Saturday
- Total Hours : 6
- Last Date of Registration : 3 August, 2022 ( within 5pm )
- Venue : Bdjobs Training, BDBL Building (Level 08), 12 Kawran Bazar C/A, Dhaka 1215.
- Training certificate will be provided within 10 working days after completion of training successfully.
Introduction
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.
Methodology
Interactive classContents of Training:
1. Highlight above and below average performers2. 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
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.
Bdjobs
Android App
Facebook
Google
Youtube
LinkedIn
Instagram
