- Have done employee tax calculation based on Hourly rates.
- This case based on the employee hourly salary have them categorised into 40 groups based on different rates for each group.
- Next month compare the same employees against the group and arrive at the average for each groups.
- The logic could be discussed.
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
Sample HighComplex Projects using Macros:(via Freelancer)
- Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables.
- Project hours and budget tracking for a construction company based on daily hours and $ utlizsation.