Anulat

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

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.

Aptitudini: Excel

Vezi mai multe: workflow one, what is research design, website design worksheet, data entry, data processing, excel, database administration, database development, microsoft access, format and layout, website design workflow, want to be a manager, types of research design, table on how to design website, staff roster examples, seo worksheet, roster examples, research design types, re creation design, labour work

Despre angajator:
( 35 recenzii ) Birkdale, Australia

ID Proiect: #10199639

12 freelanceri licitează în medie 181$ pentru acest proiect

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(249 recenzii)
7.6
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(1 părere)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 8 zile
(1 părere)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(1 părere)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 14 zile
(0 recenzii)
0.0
sondoroy

A proposal has not yet been provided

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
amytheboyd

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(0 recenzii)
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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
aeroritesh1

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 14 zile
(0 recenzii)
0.0