HR Learning & Development Data Analytics in Excel
Drive the insights from L&D data to optimize employees learning journey
Data & Analytics,Human Resources,Business,Business Analytics & Intelligence
Lectures -6
Resources -1
Duration -37 mins
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
This course is not only about enabling HR professionals to use Microsoft Excel to develop dashboards, but it will help them to formulate data analysis plans, execute the data evaluation and data cleansing process, and learn the sophisticated Excel functions.
This course is optional for people just thinking of starting with Excel.
Our approach to the course will be:
Planning the analysis job; is one of the most crucial aspects of data analysis. We will start with understanding the potential user, identifying their needs, and describing the necessary KPIs.
Once we have the user's requirements, we will initiate the data evaluation, understanding, and cleansing process. In this phase, we will see the information available to us. We will understand how the available information meets our requirements. We will use Excel formulas to create helper columns and drive the information we may need for analysis. We will learn DatedIff, If, Today, Vlookup, Round, and many other formulas.
After creating the helper columns, we will make the reports in PivotTables. Finally, participants will learn the sophisticated functions available in PivotTables.
Ultimately, this is the time to create a robust dashboard to present the data story in graphs. In addition, we will incorporate interactivity in the dashboards by using slicers, etc.
Goals
What will you learn in this course:
Learners can expect to achieve after completing the course:-
- Organisation's Learning & Development (L&D) Data Analysis Techniques;
- Microsoft Excel Pivot Tables for Dashboard Development;
- Techniques of using Microsoft Excel formulas and functions to create helper columns; and
- Creating Charts in Excel.
Prerequisites
What are the prerequisites for this course?
- Participants should have basic Microsoft Excel skills.
Curriculum
Check out the detailed breakdown of what’s inside the course
Planning the Analysis
1 Lectures
- Planning the Analysis 04:04 04:04
Understanding the Data
1 Lectures
Data Cleansing and Evaluation Process
1 Lectures
Excel Formulas for Helper Columns
1 Lectures
PivotTables and Report Building
1 Lectures
Building the Dashboard
1 Lectures
Instructor Details
Asif Rehman
Help businesses to capture meaningful insights from data to gain competitive advantage | Data Science | Data Storytelling | Data Strategy | Consumer Insights | Data Analytics | Trainer
I have an accountancy background, but I am passionate about using data creatively to solve business challenges. The blend of finance specialization, business analytics, and IT expertise enable me to identify real value in data.
I partner with business leaders in my consulting work to provide insightful commercial support and superior technical solutions.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now