HR Data Labs

Karin Buchbinder - Death by Spreadsheet! Using Excel for Compensation


Listen Later

Send us a text

Summary:

Karin Buchbinder manages the team of compensation consultants at Salary.com. She is also, as it turns out, an Excel wizard. Having developed and implemented solutions globally, she’s familiar with myriad compensation management tools, including Excel. The latest version of Excel may have powerful business tools for managing compensation data, but that doesn’t mean it should be used without its own rules and procedures. 


In this episode, Karin talks about the pros and cons of using Excel for compensation data management. 


Chapters:

[0:00 - 4:59] Introduction

  • Welcome, Karin!
  • Today’s Topic: Working with Compensation Data in Excel
  • [5:00 - 11:45] The greatest challenges Karin has come across in the world of compensation

    • Many companies still rely on Excel for compensation data
    • Excel’s accessibility and ease of use can lead to compromised data integrity
    • [11:46 - 15:16] How to successfully use Excel for compensation management

      • Avoid overly complicating the spreadsheet; make it intuitive
      • Decisions and assumptions must be well-documented
      • [15:17 - 18:45] Will Excel ever be replaced as the go-to compensation management tool?

        • It will be difficult to replace a free, widely-accessible tool
        • Recent versions of Excel have introduced powerful tools like Power BI
        • [18:46 - 19:33] Final Thoughts & Closing

          • Thanks for listening!


          Quotes:

          “One of the largest challenges [I’ve come across working in compensation] is that a lot of companies and organizations have their processes done in Excel. . . . [The problem with this] is data integrity because that spreadsheet will get handed down from one person to another . . . with no parameters around the integrity of the data.”

          “I think people don’t make that connection [that their compensation spreadsheet is a system of record]. You need to have the assumptions written out and documented.”


          Contact:

          Karin's LinkedIn
          David's LinkedIn


          Production by Affogato Media
          Podcast Manger: Karissa Harris

          To schedule a meeting with us: https://salary.com/hrdlconsulting

          For more HR Data Labs®, enjoy the HR Data Labs Brown Bag Lunch Hours every Friday at 2:00PM-2:30PM EST. Check it out here: https://hrdatalabs.com/brown-bag-lunch/

          Produced by Affogato Media

          ...more
          View all episodesView all episodes
          Download on the App Store

          HR Data LabsBy WRKdefined Podcast Network

          • 5
          • 5
          • 5
          • 5
          • 5

          5

          17 ratings


          More shows like HR Data Labs

          View all
          Wait Wait... Don't Tell Me! by NPR

          Wait Wait... Don't Tell Me!

          38,866 Listeners

          The Ramsey Show by Ramsey Network

          The Ramsey Show

          39,017 Listeners

          NPR News Now by NPR

          NPR News Now

          14,390 Listeners

          Coaching for Leaders by Dave Stachowiak

          Coaching for Leaders

          1,462 Listeners

          HBR IdeaCast by Harvard Business Review

          HBR IdeaCast

          164 Listeners

          The Daily by The New York Times

          The Daily

          112,236 Listeners

          Up First from NPR by NPR

          Up First from NPR

          56,509 Listeners

          Wall Street Breakfast by Seeking Alpha

          Wall Street Breakfast

          1,037 Listeners

          Honest HR by SHRM

          Honest HR

          207 Listeners

          SHRM All Things Work by SHRM

          SHRM All Things Work

          146 Listeners

          Digital HR Leaders with David Green by David Green

          Digital HR Leaders with David Green

          80 Listeners

          Morning Brew Daily by Morning Brew

          Morning Brew Daily

          3,005 Listeners

          The Josh Bersin Company by Josh Bersin

          The Josh Bersin Company

          57 Listeners

          The AI Daily Brief: Artificial Intelligence News and Analysis by Nathaniel Whittemore

          The AI Daily Brief: Artificial Intelligence News and Analysis

          611 Listeners

          The Jefferson Fisher Podcast by Civility Media

          The Jefferson Fisher Podcast

          8,392 Listeners