Erin at Time Saving Templates

@UC1vNth44CLlTUqcIt2AJn0A - 5.5K subscribers

Save time and streamline your spreadsheets, with a Time Saving Template! In this channel, you'll find excel tips and tricks, along with template demos, for human resources/compensation professionals, small businesses and rental property management. Join the templates tribe list to get a discount code and free templates: timesavingtemplates.com/tribe/ See all the templates at www.timesavingtemplates.com

Home Videos Live Playlists

Comp Metric for Employee Pay + Salary Structure Benchmarking: Market Index Explained

Comp Metric for Employee Pay + Salary Structure Benchmarking: Market Index Explained Erin at Time Saving Templates

97 views - 1 month ago

Automate Excel to PDF for Compensation Letters and Employee Communications

Automate Excel to PDF for Compensation Letters and Employee Communications Erin at Time Saving Templates

58 views - 2 months ago

How to Create Dependent Drop-Down Lists in Excel

How to Create Dependent Drop-Down Lists in Excel Erin at Time Saving Templates

158 views - 2 months ago

Create Personalized PDFs for HR Merit Cycle Letters Example – Excel Automation

Create Personalized PDFs for HR Merit Cycle Letters Example – Excel Automation Erin at Time Saving Templates

76 views - 3 months ago

How to Rotate Columns to Rows in Excel, Transpose Excel data

How to Rotate Columns to Rows in Excel, Transpose Excel data Erin at Time Saving Templates

249 views - 4 months ago

HR Spreadsheet Templates - 7 Essential Tools for Salary Increases, PTO tracking, Turnover and more

HR Spreadsheet Templates - 7 Essential Tools for Salary Increases, PTO tracking, Turnover and more Erin at Time Saving Templates

223 views - 4 months ago

3 Excel Tips for Organized Spreadsheets in the New Year - Excel Templates for Business

3 Excel Tips for Organized Spreadsheets in the New Year - Excel Templates for Business Erin at Time Saving Templates

145 views - 6 months ago

Excel Pivot Table Showing Old Data in Drop Down List - How to refresh it!

Excel Pivot Table Showing Old Data in Drop Down List - How to refresh it! Erin at Time Saving Templates

434 views - 7 months ago

How to Use Donut Charts for Sales Pay-Mix Analysis in Excel

How to Use Donut Charts for Sales Pay-Mix Analysis in Excel Erin at Time Saving Templates

128 views - 8 months ago

Price Level Index: Using IMF PPP & Exchange Rates in Excel | HR Compensation & Salary Analysis

Price Level Index: Using IMF PPP & Exchange Rates in Excel | HR Compensation & Salary Analysis Erin at Time Saving Templates

168 views - 10 months ago

Global Compensation Management - Purchasing Power Parity Review by Country

Global Compensation Management - Purchasing Power Parity Review by Country Erin at Time Saving Templates

145 views - 11 months ago

HR Documents to Communicate Pay Changes to Employees + Rewards Statements: Transparency?

HR Documents to Communicate Pay Changes to Employees + Rewards Statements: Transparency? Erin at Time Saving Templates

92 views - 11 months ago

Inflation Insights for HR: What can HR actually do with inflation data?

Inflation Insights for HR: What can HR actually do with inflation data? Erin at Time Saving Templates

72 views - 1 year ago

How to Download Inflation and CPI data in excel for HR and Compensation Planning

How to Download Inflation and CPI data in excel for HR and Compensation Planning Erin at Time Saving Templates

384 views - 1 year ago

Track Years of Service Excel, How to add Months to a Date to Forecast Anniversaries

Track Years of Service Excel, How to add Months to a Date to Forecast Anniversaries Erin at Time Saving Templates

858 views - 1 year ago

Conditional Formatting with Bar Icons, Perfect for Visualizing Quartile Bars

Conditional Formatting with Bar Icons, Perfect for Visualizing Quartile Bars Erin at Time Saving Templates

94 views - 1 year ago

How to Add Icon Sets in Excel, Excel Conditional Formatting with Symbols

How to Add Icon Sets in Excel, Excel Conditional Formatting with Symbols Erin at Time Saving Templates

422 views - 1 year ago

How to Copy File Names from Folder to Excel, Plus add Hyperlinks to your Files

How to Copy File Names from Folder to Excel, Plus add Hyperlinks to your Files Erin at Time Saving Templates

345 views - 1 year ago

Prorate in Excel with Dates, Calculate a Proration Year End Bonus

Prorate in Excel with Dates, Calculate a Proration Year End Bonus Erin at Time Saving Templates

2.1K views - 1 year ago

Excel Date Hacks - Get Month from Date in Excel - part 2

Excel Date Hacks - Get Month from Date in Excel - part 2 Erin at Time Saving Templates

249 views - 1 year ago

How to Calculate Employee Tenure in Excel using DATEDIF and TODAY Formulas

How to Calculate Employee Tenure in Excel using DATEDIF and TODAY Formulas Erin at Time Saving Templates

3.1K views - 1 year ago

Display All Formulas in Excel + Troubleshooting Excel Formula Tips!

Display All Formulas in Excel + Troubleshooting Excel Formula Tips! Erin at Time Saving Templates

142 views - 1 year ago

KPI Examples - Time to Complete KPI: Link Employee Performance and Bonus Payout

KPI Examples - Time to Complete KPI: Link Employee Performance and Bonus Payout Erin at Time Saving Templates

455 views - 1 year ago

Filter Formula in Excel – Listing groups or categories (Location series)

Filter Formula in Excel – Listing groups or categories (Location series) Erin at Time Saving Templates

191 views - 1 year ago

Categorize location data in Excel – Excel Address Hacks!

Categorize location data in Excel – Excel Address Hacks! Erin at Time Saving Templates

475 views - 1 year ago

Rental Property Return on Investment Excel TEMPLATE

Rental Property Return on Investment Excel TEMPLATE Erin at Time Saving Templates

4K views - 1 year ago

Relocation Analysis: Cost of Employee Compensation

Relocation Analysis: Cost of Employee Compensation Erin at Time Saving Templates

161 views - 1 year ago

How Salary Ranges Vary by Location: Geo Zone Explained

How Salary Ranges Vary by Location: Geo Zone Explained Erin at Time Saving Templates

324 views - 1 year ago

HR Metrics and Job Design: How Salary Range Overlap Affects Promotions

HR Metrics and Job Design: How Salary Range Overlap Affects Promotions Erin at Time Saving Templates

885 views - 1 year ago

How to clear data in Excel Without Deleting Formulas, Delete Multiple Cells at Once!

How to clear data in Excel Without Deleting Formulas, Delete Multiple Cells at Once! Erin at Time Saving Templates

3.7K views - 1 year ago

HR & Compensation Guide to Using Regional Salary Range Differentials

HR & Compensation Guide to Using Regional Salary Range Differentials Erin at Time Saving Templates

564 views - 1 year ago

Compensation Management by Location: Salary Survey Process Explained

Compensation Management by Location: Salary Survey Process Explained Erin at Time Saving Templates

451 views - 1 year ago

How to Separate Address in Excel, Excel Address Format

How to Separate Address in Excel, Excel Address Format Erin at Time Saving Templates

4.4K views - 1 year ago

Calculate Distance Between Two Addresses, How to Compute Distance Formula

Calculate Distance Between Two Addresses, How to Compute Distance Formula Erin at Time Saving Templates

9.1K views - 1 year ago

Lookup Multiple Zip Codes at Once, Google Script for Zip Code

Lookup Multiple Zip Codes at Once, Google Script for Zip Code Erin at Time Saving Templates

1.9K views - 1 year ago

The Ultimate HR Excel Template Bundle: All-Star HR Templates & Tools

The Ultimate HR Excel Template Bundle: All-Star HR Templates & Tools Erin at Time Saving Templates

271 views - 1 year ago

Excel Spreadsheet Customization Options and Beyond!

Excel Spreadsheet Customization Options and Beyond! Erin at Time Saving Templates

363 views - 1 year ago

How to Find the Median with a Pivot Table in Excel | HR Metrics Example

How to Find the Median with a Pivot Table in Excel | HR Metrics Example Erin at Time Saving Templates

3.1K views - 1 year ago

Filter & Median Formula Tutorial | How to Calculate Median in Excel with Multiple Conditions

Filter & Median Formula Tutorial | How to Calculate Median in Excel with Multiple Conditions Erin at Time Saving Templates

1.8K views - 2 years ago

Vacation Tracking System – Track Employee PTO, Vacation, Sick time and more!

Vacation Tracking System – Track Employee PTO, Vacation, Sick time and more! Erin at Time Saving Templates

3.2K views - 2 years ago

Roadmap to Salary Growth using Step Rate Compensation, a Time-Based Pay Approach

Roadmap to Salary Growth using Step Rate Compensation, a Time-Based Pay Approach Erin at Time Saving Templates

834 views - 2 years ago

Vote for the next HR excel template package, human resource management

Vote for the next HR excel template package, human resource management Erin at Time Saving Templates

189 views - 2 years ago

How to Evaluate and Visualize Employee Pay with Scatter Charts

How to Evaluate and Visualize Employee Pay with Scatter Charts Erin at Time Saving Templates

4.5K views - 2 years ago

Data Visualization with Stacked Bar Charts Excel

Data Visualization with Stacked Bar Charts Excel Erin at Time Saving Templates

1.5K views - 2 years ago

Overtime Tracker Excel Template for HR Analytics

Overtime Tracker Excel Template for HR Analytics Erin at Time Saving Templates

3.7K views - 2 years ago

Percentile Rank Excel Formula for HR Analytics, Boost your Analytical Skills

Percentile Rank Excel Formula for HR Analytics, Boost your Analytical Skills Erin at Time Saving Templates

2.8K views - 2 years ago

Excel Data Analysis: How to Calculate Quartiles for Salary Ranges

Excel Data Analysis: How to Calculate Quartiles for Salary Ranges Erin at Time Saving Templates

4.8K views - 2 years ago

Compensation Administration: Calculate Range Spread in Excel

Compensation Administration: Calculate Range Spread in Excel Erin at Time Saving Templates

6.2K views - 3 years ago

If Formula in Excel – For Beginners, HR Data Management

If Formula in Excel – For Beginners, HR Data Management Erin at Time Saving Templates

1.4K views - 3 years ago

Human Resource Compensation: Customize Salary Structure Chart with Employee Data

Human Resource Compensation: Customize Salary Structure Chart with Employee Data Erin at Time Saving Templates

3.1K views - 3 years ago

HR Analytics with Conditional Formatting in Excel Color Coding, Progress Bar in Excel Cell

HR Analytics with Conditional Formatting in Excel Color Coding, Progress Bar in Excel Cell Erin at Time Saving Templates

775 views - 3 years ago

HR Compensation 101: Position in Range Metric Explained

HR Compensation 101: Position in Range Metric Explained Erin at Time Saving Templates

5.4K views - 3 years ago

Employee Bonus System + Quarterly Bonus Payouts

Employee Bonus System + Quarterly Bonus Payouts Erin at Time Saving Templates

4.2K views - 3 years ago

Print Rent Receipt Template, Receipt PDF for Tenant

Print Rent Receipt Template, Receipt PDF for Tenant Erin at Time Saving Templates

1.6K views - 3 years ago

How to Calculate Midpoint Formula for Salary Ranges, Compensation Analysis

How to Calculate Midpoint Formula for Salary Ranges, Compensation Analysis Erin at Time Saving Templates

13K views - 3 years ago

How to calculate Median in Excel, Median IF multiple criteria

How to calculate Median in Excel, Median IF multiple criteria Erin at Time Saving Templates

11K views - 3 years ago

Quick Hack to Award a Merit Increase [No Ranges Needed]

Quick Hack to Award a Merit Increase [No Ranges Needed] Erin at Time Saving Templates

2.7K views - 3 years ago

Using Excel Formulas for Bonus Payouts (AVERAGEIFS, MAXIFS)

Using Excel Formulas for Bonus Payouts (AVERAGEIFS, MAXIFS) Erin at Time Saving Templates

3.3K views - 3 years ago

Total Rewards and Compensation Statements, HR Templates Excel

Total Rewards and Compensation Statements, HR Templates Excel Erin at Time Saving Templates

2.1K views - 3 years ago

Salary Grade Table, Increasing Salary Ranges Cheatsheet

Salary Grade Table, Increasing Salary Ranges Cheatsheet Erin at Time Saving Templates

987 views - 3 years ago