Google Sheets for HR

In this course, you’ll learn how to manage HR data in Google Sheets from start to finish. You’ll begin by mastering text functions, formulas, and data-cleaning techniques like Split Text to Columns, Smart Fill, and the TODAY function to calculate service lengths. You’ll then work with HR-related calculations, such as gross pay, remaining time off, and other employee metrics. The course dives deep into powerful database and lookup functions like COUNTIF, SUMIF, AVERAGEIF, and XLOOKUP to build interactive dashboards and analyze performance data quickly. You’ll also explore visualization techniques using charts, trend analysis, and sparklines to tell meaningful stories with data. Finally, Module 2 introduces advanced tools, including tables, conditional formatting, data validation with dropdowns, and pivot tables, giving you the skills to organize, filter, and summarize HR datasets with ease