Automate Sheets Sales Dashboard
Budget: €250 – €750 EUR
I am looking for an Excel / Google Sheets Expert (formulas, scripts, macros).
Here is the gist of the task: I have a document containing a complete technical specification for an automated dashboard (sales tracking + inventory management). It includes the data structure, required calculations, conditional formatting, and chart types.
inside, you will find a raw data sample + 3 specific formulas to write (dynamic ranges, nested IFs, QUERY / ARRAYFORMULA). If you review this document and immediately see the solution — you are 100% capable.
If, after viewing the file, you clearly know which functions to use and whether you need a script — DM me.
https://docs.google.com/presentation/d/1ipQPVPohKEfDSZ_Rqe1RAdN-n1yoayPIjxD59X8TMjw/preview?rm=minimal&slide=id.p1
open the link first. If you can do it — DM me.
Here is the gist of the task: I have a document containing a complete technical specification for an automated dashboard (sales tracking + inventory management). It includes the data structure, required calculations, conditional formatting, and chart types.
inside, you will find a raw data sample + 3 specific formulas to write (dynamic ranges, nested IFs, QUERY / ARRAYFORMULA). If you review this document and immediately see the solution — you are 100% capable.
If, after viewing the file, you clearly know which functions to use and whether you need a script — DM me.
https://docs.google.com/presentation/d/1ipQPVPohKEfDSZ_Rqe1RAdN-n1yoayPIjxD59X8TMjw/preview?rm=minimal&slide=id.p1
open the link first. If you can do it — DM me.