pub » Page 7 of 52 » excelguru.io

turnover dashboard that calculates attrition and retention rates by department.

Turnover & Attrition Dashboard

Monitor employee turnover and workforce retention with this free Turnover Attrition Dashboard Excel Template. Track employee exits, resignation reasons, departments, tenure, attrition rates, monthly turnover trends, voluntary and involuntary exits, and key HR insights in one simple Excel dashboard. Ideal for HR teams, managers, founders, and business owners that need an easy way to analyze attrition patterns, identify retention risks, and improve workforce planning.

Headcount Planning

Plan future workforce requirements with this free Headcount Planning Excel Template. Track current employees, open roles, planned hires, departments, job titles, hiring timelines, salary budgets, vacancy status, and headcount forecasts in one simple Excel file. Ideal for HR teams, finance teams, founders, managers, and small businesses that need an easy way to plan staffing levels, control hiring budgets, and support workforce planning.

shift roster that assigns weekly shifts and calculates hours, off days and coverage

Shift Roster & Scheduler

Plan and manage employee work schedules with this free Shift Roster Scheduler Excel Template. Create weekly or monthly shift rosters, assign employees to shifts, track days off, monitor working hours, manage staff coverage, and organize team schedules in one simple Excel file. Ideal for HR teams, managers, operations teams, retail stores, restaurants, and small businesses that need an easy way to schedule staff and maintain proper workforce coverage.

payroll sheet that calculates gross pay, deductions and net pay for the whole team.

Payroll & Salary Sheet

Manage monthly payroll calculations with this free Payroll Salary Sheet Excel Template. Track employee details, basic salary, allowances, overtime, deductions, taxes, bonuses, gross pay, net salary, and payment status in one simple Excel file. Ideal for HR teams, payroll staff, finance teams, startups, and small businesses that need an easy way to prepare salary sheets and maintain accurate payroll records.

VBA: Automate Email Sending from Excel with Outlook

Automate Outlook emails directly from Excel with this practical VBA tutorial. Learn how to send emails using Excel data, create subject lines and message bodies, loop through recipient lists, add attachments, and manage bulk email workflows with VBA. Ideal for Excel users, analysts, admin teams, finance teams, and professionals who want to save time by automating repetitive email tasks from Excel.

DAX SUMX & AVERAGEX: Iterative X‑Functions Explained

Understand how DAX SUMX and AVERAGEX work in Power Pivot with simple, practical examples. This tutorial explains iterator functions, row-by-row calculations, calculated totals, weighted averages, and when to use SUMX or AVERAGEX instead of regular SUM or AVERAGE. Ideal for Excel users, analysts, finance teams, and Power Pivot learners who want to build more accurate and flexible DAX measures.

DAX RANKX: Ranking with Ties & Custom Order

Understand how the DAX RANKX function works in Power Pivot with practical ranking examples. This tutorial explains how to rank sales, products, employees, customers, or categories, handle ties, use ascending or descending order, and build dynamic ranking formulas based on filter context. Ideal for Excel users, analysts, finance teams, and Power Pivot learners who want to create accurate ranking calculations in DAX.

DAX ALL & ALLEXCEPT: Remove Filters for Advanced Calculations

Understand how the DAX ALL and ALLEXCEPT functions work in Power Pivot with simple examples. This tutorial explains how to remove filters, keep specific filters, calculate grand totals, create percentage-of-total formulas, and control filter context in Excel Power Pivot. Ideal for Excel users, analysts, finance teams, and Power Pivot learners who want to build more flexible and accurate DAX calculations.

DAX EARLIER Function: Row‑by‑Row Calculations in Power Pivot

Understand how the DAX EARLIER function works in Power Pivot with simple row-by-row calculation examples. This tutorial explains row context, calculated columns, nested calculations, ranking logic, and common EARLIER use cases in Excel Power Pivot. Ideal for Excel users, analysts, finance teams, and Power Pivot learners who want to build stronger DAX formulas and understand how calculations work across rows.

Recruitment Pipeline

Manage your hiring workflow with this free Recruitment Pipeline Excel Template. Track open roles, candidate details, application sources, screening status, interview stages, recruiter notes, hiring decisions, and pipeline progress in one simple Excel file. Ideal for HR teams, recruiters, hiring managers, startups, and small businesses that need an easy way to organize candidates and improve recruitment tracking.

Training Matrix

Manage employee training and skills development with this free Training Matrix Excel Template. Track employee names, departments, training programs, required skills, completion status, certification dates, expiry dates, competency levels, and training gaps in one simple Excel file. Ideal for HR teams, managers, compliance teams, startups, and small businesses that need an easy way to monitor workforce training and maintain accurate learning records.

Performance Appraisal Tracker

Track and manage employee performance reviews with this free Performance Appraisal Tracker Excel Template. Record employee details, review periods, goals, competencies, manager feedback, appraisal ratings, development actions, review status, and final outcomes in one simple Excel file. Ideal for HR teams, managers, startups, and small businesses that need an easy way to organize performance appraisals and support employee development.