video1.0<iframe src="https://www.loom.com/embed/45e20bf7e8e14aa3ada1a51bad5265d6" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/45e20bf7e8e14aa3ada1a51bad5265d6-667e91dde6d02863.gif190.166667This Loom explains how to set up an Excel hotcheat by connecting it to a PeopleHR query using an API key. It notes Excel hotcheats are not compatible with macOS and recommends downloading the Excel spreadsheet from the article each time. The video walks through creating queries, going to PeopleHR settings and the API tab to name the API and select the appropriate query builder, then copying the API key and pasting it into the PeopleHR query tab along with an exact query name. It also instructs enabling auto-refresh data and running all queries, and mentions using Enable Content for a yellow banner and contacting IT if the Settings tab does not load.