New Year '20 Offer
New Year '20 Offer
Excel for HR Training (5 Courses, 10+ Projects)
This Excel for HR Training is a comprehensive training of 5 courses, 10 Projects with 62+ hours of video tutorials and Lifetime access.
Along with this, you also get verifiable certificates (unique certification number and your unique URL) when you complete these courses. You will learn how MS Excel Function and Formulas that are used most frequently by human resource professionals can be put to use effectively.
Microsoft Excel Basic Training
Microsoft Excel 2013 - Advanced
Project - HR Dashboard using Excel
Project - Advanced HR Dashboard
Project on Excel VBA - Attendance Register using Microsoft Excel VBA
What you get in this Excel for HR Training?
Mobile App Access
About Excel for HR Training
|Course||No. of Hours|
|Microsoft Excel Basic Training | Excel 2013 Courses Online | Beginners||4h 22m|
|Microsoft Excel 2013 - Advanced||11h 06m|
|Project - HR Dashboard using Excel||6h 5m|
|Project - Advanced HR Dashboard||7h 8m|
|Project on Excel VBA - Attendance Register using Microsoft Excel VBA||2h 7m|
|Project on Excel VBA - Restaurant Billing System using Microsoft Excel VBA||3h 5m|
|Microsoft Excel 2016 - Beginners||4h 03m|
|Microsoft Excel 2016 - Advanced||5h 11m|
|Project - Creating Interactive Dashboards using VBA||2h 25m|
|Project - Creation of Basic CRM by using Microsoft Excel VBA and SQL Express||3h 56m|
|Project - Interactive Dashboards using Microsoft Excel VBA||2h 4m|
|Project - Microsoft Excel Dashboard Training||6h 1m|
|Microsoft Excel for Business Professionals and Managers||1h 26m|
|Working with Pivot Tables Presentation||4h 12m|
|Pivot Table Case Study - Performance Ratings of Employees||1h 12m|
|Course Name||Online Excel for HR Training Bundle|
|Deal||You get access to all the 5 courses, 10 Projects. You do not need to purchase each course separately.|
|Hours||62+ Video Hours|
|Core Coverage||Microsoft Excel, HR Dashboard & Analytics, Attendance Register using Microsoft Excel VBA, Restaurant Billing System using Microsoft Excel VBA|
|Course Validity||Lifetime Access|
|Eligibility||Anyone who is serious about learning Excel for finance|
|Pre-Requisites||Basic knowledge of Excel|
|What do you get?||Certificate of Completion for each of the 5 courses, 10 Projects|
|Certification Type||Course Completion Certificates|
|Verifiable Certificates?||Yes, you get verifiable certificates for each 5course, 10 Projects with a unique link. These link can be included in your Resume/Linkedin profile to showcase your enhanced skills|
|Type of Training||Video Course – Self Paced Learning|
|System Requirement||1 GB RAM or higher|
|Other Requirement||Speaker / Headphone|
Excel for HR Training Curriculum
In this course, you will learn a ton. Before we talk about the prerequisites, the target audience, the FAQs, the career benefits, let’s talk about the excel for finance course curriculum –
This training is formed keeping in mind the excel requirements for HR managers and is tailored as such. This course will provide a fair overview of excel to the learners and also cover advanced features of excel so as to help the learners in actual application of those concepts in their advantage.
The course will take you through the basics of excel and then walk you through important excel functions and tools. The learners will also experience projects, that will help hem understand about the development and functioning of various dashboards.
Let us have a look on the core concepts that will be covered in the course.
Learners will develop understanding about basic concepts of MS Excel 2013 such as data entry, calculations, formulas, formatting, graphs and charts, pie charts, sorting and filter, freeze and slip and so on.
In the next segment, learners will strengthen their concept clarity on advanced excel concepts such as essential excel functions, data functions, what-if-analysis, text functions, auditing formulas, pivot charts, pivot tables, macros, power view etc.
A session will be covered on basic concepts of MS Excel 2016. Topics such as data entry, calculations, formulas, formatting, conditional formatting, graphs, pie charts, sorting and filter etc. will be covered.
The learners will then move ahead with advanced excel functions of 2016 version such as data functions, what-if-analysis, text functions, auditing formulas, charts etc.
Training will be conducted to demonstrate presentation of pivot tables. In this segment we will be discussing about stock analysis, project dashboard, company dashboard and sales analysis case study.
In the last segment, we will take up a case study based on performance rating of employees using features of excel.
Following are some projects that are included in the course curriculum.
A project will be discussed relating to creation of HR dashboard as well its analysis. Topics such as index design and tab designing, employee front face, pivot data list, MOM headcount, department and location analysis, tenure wise and age wise analysis, job rating analysis etc. will be covered.
HR dashboard will then be discussed on an advanced level. Here we will use excel features such as data and animated macro chart, predictive attrition, v-lookup analysis, BGV analysis and so on.
Learners will also undergo a project based on creation of HR attendance register with the help of excel VBA.
A project will be undertaken to discuss restaurant billing system using excel VBA. In this project, learners will understand about system interface, billing calculator, currency activation, check box and text box, tax and home delivery buttons.
We will understand the process for creation of interactive dashboards in excel using VBA.
In the next project, we will focus on the process for creation of basic CRM using excel VBA and SQL express.
Introduction will be provided on interactive excel dashboards with the help of a project.
Detailed training will be carried out on excel dashboards and management of data using such dashboards.
Excel for HR Training – Certificate of Completion
- Willingness to do this course: As you can see this excel for HR training isn’t for everybody. If you are an HR aspirant or you are an HR professional, and you’re willing to understand how HR analytics & MS Excel work, this course is a goldmine for you.
- The basic knowledge of HR: You may not know everything about HR. But if you don’t understand the quantifiable metrics under HR, then it would be difficult for you to do this course. Just have a basic understanding of human resource management and you would be good to go.
- Students of HR: This excel for HR training is right for you if you are a student of HR or pursuing your MBA in HR. Even if we call it MS Excel for HR managers, you can still extract the value out of this course if you want to further your career in the HR domain.
- HR Managers/HR Professionals: Any HR professional would get a great value out of this course. They would not only learn MS Excel, but they will also master the quantifiable aspects of human resources.
Excel for HR Training FAQ’s- General Questions
Why should I do this excel for HR training?
There’s no reason why you shouldn’t. If you are in the HR domain and want to pursue a career in HR, this is one of the best courses for MS Excel in the market.
How this course will help me?
This course will not only teach you, MS Excel, it will also teach you how you can create a system that will help you measure many HR aspects.
I don’t have an HR background. Can I do this course?
Yes, you can. This excel for HR training will teach you MS Excel plus HR analytics. But having a basic idea about HR would definitely help.
Dashboard with excel
Christoffer Alejandro Neil Meng Hui Ng
Even though Excel have some confusing/hard content to understand, this course is able to make it quite simple. It’s a nice content for people who knows the basics. First time I see a advanced excel course that offers Solvers and data analysis tools (other courses stop at Pivot)
Álvaro Chagas da Luz Neto