PLEASE READ FIRST.
I want an Excel worksheet to be used by an SEO worker/s to manage all the tasks they need to do, on some days there will be 2 workers and other days there may be 4 workers so the Excel sheet needs to have a space to plan the available hours on a daily basis and divide the tasks up over the month based on the time each task requires (Some Tasks may require Hours others may be just 2 minutes etc..). So there also needs to be a new client input form to enter in all the tasks required on a monthly basis for the client.
I would think the following Tabs will be required:
1 - Dashboard
-Showing Today's Tasks that need to be done.
-Showing an overview of each clients progress for the month (i.e. if there is 40 tasks required and 10 completed, show clearly that this project is 25% complete so far for the month
2 - A New Client Form to select all the tasks that will be done for the client as well as how many and how often etc...
-This could also work as a table with selections, im not sure what's better.
3 - Staff Roster for the month, this is required to work out how to distribute the tasks, Based on number of Labour Hours available for the day.
4 - Archive sheet to store all the previous data, again this is just an idea, you may have a better solution
5 - An input Form or Table to Set-up the Different SEO tasks they do with a description of what has to be done to complete the task
One last thing, There will also be many tasks to complete for a new client in the first month which are only once off, meaning they will not be re-occurring so this need to be factored in also, possibly by having an option to set a task as a one off in its settings.
Plus any other Tabs you think will be required.
If you have an idea about SEO that's even better, then you will know the types of tasks required, here are some examples:
Tasks required once only, First Month:
* Setup Google Analytics Account
* Do Keyword Research
* Website Analyses
* Setup Google search console
* Setup Google Tag Manager
Tasks that maybe ongoing on a monthly basis:
* Local Directory Submission
* Image Tags
* Article creation (Blog)
* H1 Tags
* Facebook Posts
And so on....
Please only bid if you can produce a well developed sheet that makes the management of the SEO tasks easy to understand and follow.
12 freelanceri licitează în medie 181$ pentru acest proiect
Dear sir I have so much experience working with excel da sheets, entering data and formatting with optimisation such to satisfy employer in any aspect. I am hardworker, honest, with perfect skills working with excel Mai multe
I believe i am the best candidate for this project because i have more than enough hands on experience in entering and processing data using Microsoft Excel/VBA. I also pay good attention to speed, details and accuracy Mai multe
Providing reporting templates, dashboard, calculator, converting excel data into an access database are some of my task. I've been working in a BPO company here at the Philippines as a Reporting Expert on Workforce Ma Mai multe
I have extensive knowledge of using Excel as workflow & workforce management tool, and have created similar workbooks in the past. Having said that, requirements usually differ and final confirmation would be required Mai multe
I have experience in developing similar template for my property team at my school. i work in a school and i have developed various templates with macro to automate various tasks to improve efficiency at school. I dev Mai multe
Hi, My core competency revolves around production planning and creating tools for my clients to increase staff understanding of production requirements or quota's. I have been in the construction, mining and engineeri Mai multe
To work in a growth oriented organization with a motivating environment that will help me explore my skills, further enhance them and utilize them for ultimate objective of the organization.
Intensive experience using and creating tabs using excel and dashboards using softwares like tableau. Please contact me for any more details
As an Excel and Access master and specialist I believe I am the best suited to complete your project with the scope provided. I will be honest though, what you are requesting far exceeds the capabilities of an excel do Mai multe