Google Sheets / Excel Automation Expert

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Any

SALARY

?28,176 PHP

HOURS PER WEEK

40

DATE UPDATED

Apr 28, 2026

JOB OVERVIEW

Overview:
We’re looking for an experienced and detail-oriented Google Sheets and Excel professional to help us automate and organize reports based on payroll data. You’ll be responsible for building and optimizing spreadsheets that streamline data analysis, improve reporting accuracy, and reduce manual work.

Key Responsibilities:

Build and manage Google Sheets and Excel dashboards.

Create pivot tables and advanced formulas (e.g., IF, VLOOKUP, INDEX-MATCH, ARRAYFORMULA).

Automate reports and summaries for payroll and team performance tracking.

Clean and organize raw data for clear visualization and analysis.

Collaborate with management to design efficient data workflows.

Requirements:

Proven experience working with Google Sheets and Microsoft Excel.

Strong understanding of formulas, logic, and data validation.

Ability to create automations and custom templates.

Excellent attention to detail and problem-solving skills.

Familiarity with payroll or financial reporting is a plus.

Preferred Skills:

Experience using Google Apps Script or macros.

Basic understanding of data visualization or reporting tools (e.g., Looker Studio, Power BI).

Strong communication and organization skills.

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0010
Controller Execution Time ( Jobseekers / Job )  0.0362
Total Execution Time  0.0379
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,502,880 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Google-Sheets-Excel-Automation-Expert-1510819
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0279 seconds)  (Hide)
0.0009   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0013   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1510819
 LIMIT 1 
0.0019   SELECT *
FROM `employers`
WHERE `employer_id` = 618771
 LIMIT 1 
0.0045   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1510819
AND `misc`.`idIS NULL 
0.0011   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-07-14',ej.date_added) duration_daysDATEDIFF('2026-07-14',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_jobs ej WHERE e.employer_id ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-07-14',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1510819' 
0.0014   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1510819 
0.0014   UPDATE employer_jobs SET hit_counts '***Nov-10-2025=94***Nov-11-2025=240***Nov-12-2025=63***Nov-13-2025=58***Nov-14-2025=27***Nov-15-2025=16***Nov-16-2025=8***Nov-17-2025=26***Nov-18-2025=34***Nov-19-2025=10***Nov-20-2025=2***Nov-21-2025=4***Nov-23-2025=2***Nov-24-2025=4***Nov-25-2025=2***Nov-26-2025=2***Nov-27-2025=3***Nov-28-2025=1***Nov-29-2025=3***Nov-30-2025=2***Dec-02-2025=1***Dec-03-2025=2***Dec-04-2025=1***Dec-05-2025=1***Dec-06-2025=1***Dec-09-2025=1***Dec-10-2025=2***Dec-12-2025=1***Dec-15-2025=2***Dec-16-2025=1***Dec-17-2025=1***Dec-19-2025=1***Dec-22-2025=1***Dec-23-2025=1***Dec-26-2025=1***Dec-27-2025=1***Dec-30-2025=1***Dec-31-2025=1***Jan-01-2026=1***Jan-02-2026=2***Jan-06-2026=3***Jan-08-2026=2***Jan-09-2026=3***Jan-12-2026=1***Jan-14-2026=2***Jan-15-2026=1***Jan-16-2026=1***Jan-18-2026=1***Jan-23-2026=1***Jan-24-2026=1***Jan-27-2026=2***Jan-30-2026=1***Feb-01-2026=1***Feb-06-2026=1***Feb-07-2026=6***Feb-08-2026=2***Feb-10-2026=1***Feb-11-2026=2***Feb-12-2026=2***Feb-13-2026=1***Feb-19-2026=1***Mar-01-2026=1***Mar-22-2026=1***Mar-23-2026=1***Mar-25-2026=1***Mar-29-2026=1***Apr-01-2026=2***Apr-02-2026=1***Apr-22-2026=6***Apr-25-2026=2***Apr-27-2026=1***Apr-28-2026=438***Apr-29-2026=131***Apr-30-2026=50***May-01-2026=34***May-02-2026=20***May-03-2026=39***May-04-2026=38***May-05-2026=37***May-06-2026=37***May-07-2026=8***May-08-2026=15***May-09-2026=6***May-10-2026=4***May-11-2026=14***May-12-2026=8***May-13-2026=14***May-14-2026=5***May-15-2026=4***May-16-2026=3***May-17-2026=11***May-18-2026=6***May-19-2026=9***May-20-2026=9***May-21-2026=5***May-22-2026=14***May-23-2026=7***May-24-2026=8***May-25-2026=8***May-26-2026=13***May-27-2026=1***May-28-2026=5***May-29-2026=2***May-31-2026=3***Jun-01-2026=5***Jun-02-2026=7***Jun-03-2026=3***Jun-04-2026=22***Jun-05-2026=3***Jun-06-2026=4***Jun-07-2026=2***Jun-08-2026=10***Jun-09-2026=7***Jun-10-2026=8***Jun-12-2026=6***Jun-13-2026=3***Jun-14-2026=1***Jun-15-2026=5***Jun-16-2026=17***Jun-17-2026=7***Jun-18-2026=5***Jun-19-2026=5***Jun-20-2026=2***Jun-21-2026=6***Jun-22-2026=5***Jun-23-2026=7***Jun-24-2026=5***Jun-25-2026=1***Jun-26-2026=6***Jun-27-2026=4***Jun-28-2026=3***Jun-29-2026=3***Jun-30-2026=5***Jul-01-2026=9***Jul-03-2026=1***Jul-04-2026=4***Jul-05-2026=4***Jul-06-2026=5***Jul-07-2026=2***Jul-08-2026=1***Jul-09-2026=3***Jul-10-2026=6***Jul-11-2026=7***Jul-13-2026=1***Jul-14-2026=1' WHERE job_id'1510819'  
0.0011   UPDATE employer_jobs SET monthly_hits '***Nov-2025=601***Dec-2025=21***Jan-2026=22***Feb-2026=17***Mar-2026=5***Apr-2026=631***May-2026=387***Jun-2026=167***Jul-2026=44' WHERE job_id'1510819'  
0.0022   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1510819' AND status LIKE 'sent%' ORDER BY id DESC  
0.0009   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1510819 
0.0093   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '618771'
AND `date_added` >= '2022-06-08' 
0.0009   select from teasers 
0.0009   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)