Confidently Recommend Fair Pay

Why This Course?

Why should I spend time learning this?

Imagine inheriting a spreadsheet of 200 employees, 12 salary grades, and a department head asking you point-blank: “Are we paying our people fairly?”

Without structured metrics, answering this question turns into an emotional debate based on gut feelings, subjective tenure arguments, and raw dollar comparisons. Managers end up overpaying for new hires, creating painful internal equity gaps, or underpaying top performers until they quietly resign.

Salary ranges are not arbitrary numbers. They are deliberate economic structures anchored to external market data. To evaluate pay with precision, compensation professionals rely on two complementary lenses: Compa-Ratio (market alignment) and Range Penetration (internal salary runway).

Key Principle: Compa-Ratio benchmarks pay against the external market; Range Penetration measures remaining salary runway within the grade. You need both to make defensible compensation decisions.

This course gives you the mathematical tools, business context, and spreadsheet techniques needed to evaluate pay positioning objectively, guide department leaders during merit cycles, and stand confidently behind every compensation recommendation.

What You Will Learn

Core capabilities and compensation analytics frameworks you will master:

• Salary Structure Fundamentals: Master the relationship between Range Minimum (entry rate), Range Midpoint (market policy line), Range Maximum (mastery ceiling), and Range Spread.
• Compa-Ratio Analysis: Calculate $\frac{\text{Employee Salary}}{\text{Range Midpoint}}$ to evaluate whether employees carry a market discount, sit at market median, or command an expert premium.
• Range Penetration Analysis: Calculate $\frac{\text{Salary} - \text{Minimum}}{\text{Maximum} - \text{Minimum}}$ to measure remaining salary runway and avoid hitting structural pay ceilings.
• Pay Positioning Zones: Interpret distribution across the Developing Zone (80-90%), Target Market Zone (90-110%), and Premium/Expert Zone (110-120%+).
• Practical Compensation Scenarios: Model new hire offers, standard 8-12% promotional increases, market midpoint updates (compression), and red-circled employee packages.
• Financially Weighted Group Metrics: Eliminate mathematical distortion by calculating Group Compa-Ratio as $\frac{\text{Total Group Salary}}{\text{Total Group Midpoints}}$.
• Spreadsheet Automation: Build dynamic Excel models using XLOOKUP, nested IF zone classifications, and conditional formatting alerts.

Course at a Glance

Module 1: Foundations of Compa Metrics
Module 2: Understanding the Calculations
Module 3: Interpreting Results
Module 4: Common Compensation Scenarios
Module 5: Calculator Workshop
Module 6: Applying Results in Salary Reviews

Module Breakdown:

Module 1: Foundations of Compa Metrics

• Core Concept: Salary ranges as deliberate economic structures and why Compa-Ratio and Range Penetration answer two distinct business questions.
• Decision Tool: The Midpoint as the external market policy line and the mathematical checkpoint ($\text{Compa-Ratio } 100% = \text{Range Penetration } 50%$).
• Outcome: Learn why single-metric evaluations create dangerous blind spots during compensation planning.

Module 2: Understanding the Calculations

• Core Concept: Step-by-step arithmetic mechanics for individual and multi-employee payroll datasets.
• Decision Tool: Parentheses rules in Range Penetration, data normalization (annual vs. hourly), and dynamic grade table mapping.
• Outcome: Eliminate common Excel calculation errors that corrupt merit matrices and budget forecasts.

Module 3: Interpreting Results

• Core Concept: Layering organizational context (tenure, performance ratings, and skill scarcity) over raw percentages.
• Decision Tool: Compa-Ratio and Range Penetration diagnostic zones (Developing, Target, Premium, and Warning).
• Outcome: Identify hidden compression traps and overpaid underperformers before salary calibration meetings begin.

Module 4: Common Compensation Scenarios

• Core Concept: Applying metrics to high-frequency hiring, promotion, and equity challenges.
• Decision Tool: Promotional modeling matrices (8% vs. 12%), market compression audits, and red-circle treatment options (Capped vs. Lump-Sum vs. Split).
• Outcome: Provide strategic, budget-defensible compensation advice to department directors and executive leaders.

Module 5: Calculator Workshop

• Core Concept: Building institutional-grade, multi-sheet compensation workbooks in Microsoft Excel.
• Decision Tool: Dynamic formula integration, structured tables, error handling, and visual conditional formatting.
• Outcome: Automate department-wide equity reviews and salary review dashboards.

Module 6: Applying Results in Salary Reviews

• Core Concept: Translating compensation analytics into actionable merit allocation strategies and manager coaching conversations.
• Decision Tool: Financially weighted Group Compa-Ratio ($\text{Total Salary} / \text{Total Midpoints}$) and merit matrix distribution.
• Outcome: Lead high-impact salary review meetings that protect company budgets while rewarding and retaining top talent.

Practice: The Experience Lab

Where you build, calculate, and model real-world salary structures.

In the Academy Experience Lab, you take on the role of an HR Analyst at Globex Corp, auditing a 200-employee payroll dataset and preparing department leaders for high-stakes salary review cycles:

• 🧪 Salary Range Formatter & Policy Line Analyzer: Structure multi-grade pay bands, format currency values, and calculate average market midpoints.
• 🧪 Compa-Ratio & Range Penetration Calculator: Automate calculations across diverse job families, testing edge cases and verifying the 100%/50% symmetry rule.
• 🧪 Pay Positioning Zone Auditor: Write nested logical formulas to classify employees into Developing, Target, and Premium zones, applying color-coded audit alerts.
• 🧪 Promotional Modeling & Red-Circle Simulator: Model post-promotion pay scenarios for newly promoted staff and engineer lump-sum split packages for maxed-out senior experts.
• 🧪 Departmental Group Compa-Ratio Engine: Calculate financially weighted group averages to build accurate, executive-grade merit pool budget requests for the CFO.

Retain: Resources Built for Real-World Work

Ready-to-use frameworks and practical job aids that travel with you beyond the course:

• 🧰 Compensation Metrics Cheat Sheet: Quick-reference guide with Compa-Ratio, Range Penetration, and Group Compa-Ratio formulas, common Excel pitfalls, and zone interpretation benchmarks.
• 🧰 Executive Learning Digest: Comprehensive synthesis covering salary structure design, market midpoint anchoring, and merit matrix integration.
• 🧰 Interactive Flash Cards: Reinforcement cards for pay zones, promotional increase guidelines, and red-circle compensation treatments.
• 🧰 Salary Review Calculator & Audit Toolkit: Downloadable Excel spreadsheet models with pre-built formulas, dynamic lookup tables, and conditional formatting rules for salary reviews.