Warangkhana D.
Home
About
More
01
Use the QUERY function in Google Sheets to build a live filter over an employee table dropdowns for performance, gender, and salary range rewrite the result set instantly.
02
Use REGEXEXTRACT in Google Sheets to pull ID number, name, date of birth, address, and expiry date straight out of messy, unstructured customer text blocks plus an auto-calculated age and an expiry-year flag turning free text into a clean, structured table.
03
Use SUMIF and SUMPRODUCT functions in Google Sheets to roll up raw transaction data into branch, monthly, and channel summaries, then power an interactive dashboard — dropdown filters for employee, branch, and month recalculate every KPI, chart, and achievement status instantly.
