Design an Excel Workbook to manage our workflow (Tasks) plus an Awesome Dashboard.

Avbrutt Lagt ut 7 år siden Betales ved levering
Avbrutt Betales ved levering

Hi

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.

Excel

Prosjekt-ID: #10199639

Om prosjektet

12 bud Eksternt prosjekt Aktiv 7 år siden

12 frilansere byr i gjennomsnitt $181 for denne jobben

jasmindz1ob

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 Mer

$100 USD på 3 dager
(1 anmeldelse)
2.8
haseriki2001

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 Mer

$105 USD på 8 dager
(1 anmeldelse)
0.6
kenkie

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 Mer

$90 USD på 3 dager
(1 anmeldelse)
0.8
kalliedb

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 Mer

$333 USD på 14 dager
(0 Omtaler)
0.0
sondoroy

A proposal has not yet been provided

$166 USD på 3 dager
(0 Omtaler)
0.0
johnkirbysantos

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 Mer

$222 USD på 5 dager
(0 Omtaler)
0.0
alihassan645

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.

$100 USD på 3 dager
(0 Omtaler)
0.0
aeroritesh1

Intensive experience using and creating tabs using excel and dashboards using softwares like tableau. Please contact me for any more details

$170 USD på 3 dager
(0 Omtaler)
0.0
OmagaIII

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 Mer

$277 USD på 14 dager
(0 Omtaler)
0.0