Back to Tutorials | Interactive Beginner

HR Payroll with Google sheet

30 minutes admin 13 views Internal

External Tutorial

This tutorial is hosted on Internal. Click below to access it.

Overview

A fully formula-driven payroll system for 12 employees where HR only updates Basic Salary and Days Present — every other column (HRA, Gross, PF, TDS, Net Pay, Grade, Status) calculates automatically using ARRAYFORMULA and nested IF. Plus a live VLOOKUP lookup tool

Prerequisites

Basic Understanding of Excels/google sheet and it filters

Learning Outcomes

Learn to use
ARRAYFORMULA — HRA, Gross, PF (Columns F, G, H)

Tutorial Info

Type Interactive

Difficulty Beginner

Duration 30 minutes

Provider Internal

Published Mar 18, 2026

Last Updated Jun 03, 2026