Course Outline

Module 1: Introduction to Advanced Excel

• Navigating Excel’s layout and settings
• Using Excel shortcuts for efficiency
• Importing and saving HR data
• Using Excel’s data import tools
• Case Study: Set up an HR data template

Module 2: Advanced Excel Formulas and Macros

• Applying advanced logical and text formulas
• Working with arrays and lists
• Creating VBA macros for HR tasks
• Using Excel’s macro recorder
• Case Study: Automate a payroll calculation

Module 3: HR Metrics and Data Analysis

• Understanding staffing and performance metrics
• Analyzing training and development metrics
• Calculating the Bradford Factor
• Using Excel’s statistical functions
• Case Study: Analyze turnover metrics

Module 4: Excel Charts for HR

• Creating bar, line, and scatter charts
• Using sparklines and histograms
• Formatting charts for HR reports
• Using Excel’s chart tools
• Case Study: Visualize hiring trends

Module 5: HR Dashboards

• Building dashboards for age and gender distribution
• Visualizing department and hiring sources
• Using animated macro charts
• Using Power Query for dashboard data
• Case Study: Create an HR dashboard

Module 6: Pivot Tables and Data Formatting

• Creating and formatting pivot tables
• Using pivot charts for HR insights
• Applying named ranges and indirect functions
• Using Excel’s pivot table slicers
• Case Study: Summarize performance data

Module 7: Predictive Analytics with Linear Regression

• Understanding linear regression basics
• Exploring types of data and statistics
• Describing data graphically
• Using Excel’s Analysis ToolPak
• Case Study: Predict employee attrition

Module 8: Data Preparation for Machine Learning

• Performing univariate analysis and EDD
• Treating outliers and missing values
• Creating dummy variables for qualitative data
• Using Excel’s data cleaning tools
• Case Study: Prepare an HR dataset

Module 9: Building Regression Models

• Creating simple and multiple linear regression models
• Assessing model accuracy with R-squared
• Interpreting categorical variables
• Using Excel’s regression tools
• Case Study: Build a retention model

Module 10: HR Analytics Mini Project

• Processing and preprocessing HR data
• Interpreting regression model results
• Presenting predictive analytics findings
• Using Excel’s Power Pivot for analysis
• Case Study: Complete an HR analytics project