Đã Đóng

Task Tracking Smart Excel Sheet

I need a customized excel sheet where I can assign tasks to other staff with email tagging option, with email response creation for everyone tagged and a CC / BCC column. There should also be Current status column reflecting the status of tasks in percentage and colors. There will be assigned and due dates as well and in case of overdue, an automatic email will be sent to all the parties mentioned in the assignee, CC, BCC columns and myself.

I need a comprehensive dashboard view of the status of tasks on a weekly, monthly and yearly basis.

Column-1: Request# | Column-2: Request | Column-3: Requester | Column-4: Assigned To | Column-5: Action/Progress | Column-6: Start Date | Column-7: Due Date | Column-8: Charts and Dashboards.

During Allocation a task row will be shown green but one day before due date it will change to Blue and after Due date it will turn into RED.

Make this project as efficiently as possible. Simply explained, I need an excel sheet I can assign tasks to people and they receive a notification. also add columns like CC, BCC, so that whatever email id is put in these columns those emails also receive emails and reminders.
Mention columns with start project date and due dates. When a project is assigned color of project row is green, 2 days before the due date send automatic notifications and email reminders to assignee's, CC and BCC columns of that project. Once due date comes change the row colour to red and resend the email reminders and notifications.
Plz add some buttons or templates for Charts and Dashboard where i can create and extract reports of all tasks on weekly, monthly and yearly basis and task status.

Kĩ năng: Excel, Excel VBA, Microsoft Access, Microsoft Office, Microsoft Outlook

Xem nhiều hơn: DATA ENTRY OFFICE. SALES ANALYSIS, DAILY,WEEKLY,MONTHLY,YEARLY REPORTS, script task copy data excel sheet, sales tracking excel sheet, free excel project management tracking templates, multiple project tracking template excel, excel spreadsheet templates for tracking, excel task tracker template, free project management templates excel 2007, project tracking template excel free download, project management dashboard excel, project plan template excel 2013, microsoft excel, excel sheet sales tracking, excel sheet weekly sales, project tracking excel sheet, excel sheet tracking work progress, excel sheet tracking employees comp hours, excel sheet tracking job search graph, excel sheet tracking workload jobs, excel sheet issue tracking

Về Bên Thuê:
( 0 nhận xét ) United Arab Emirates

ID dự án: #17018427

23 freelancer đang chào giá trung bình $183 cho công việc này


Hello, I can help with you in your project Task Tracking Smart Excel Sheet. I have more than 5 years of experience in Excel, Excel VBA, Microsoft Access, Microsoft Office, Microsoft Outlook . We have worked on seve Thêm

$250 USD trong 3 ngày
(243 Nhận xét)

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Thêm

$211 USD trong 3 ngày
(86 Nhận xét)

Hello, I'm ready to work on tracking smart excel sheet project. Relevant Skills Excel, VBA Milestones 90 USD - project requirements done and delivered 90 USD - last milestone after full checking and testin Thêm

$250 USD trong 10 ngày
(114 Nhận xét)

Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks

$277 USD trong 3 ngày
(119 Nhận xét)

Hello Sir, I would like to discuss this project with you. I am an expert with VBA programming. Thanks Aanvik

$277 USD trong 3 ngày
(40 Nhận xét)

A proposal has not yet been provided

$138 USD trong 10 ngày
(117 Nhận xét)

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the project Thêm

$30 USD trong 1 ngày
(87 Nhận xét)

Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$200 USD trong 3 ngày
(67 Nhận xét)

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Thêm

$155 USD trong 3 ngày
(46 Nhận xét)
$150 USD trong 3 ngày
(35 Nhận xét)

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Thêm

$250 USD trong 5 ngày
(18 Nhận xét)
$166 USD trong 3 ngày
(34 Nhận xét)
$150 USD trong 3 ngày
(7 Nhận xét)

I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have worked on many projects like these, you can check my profile to read my clients reviews ! Pl Thêm

$155 USD trong 3 ngày
(6 Nhận xét)
$155 USD trong 3 ngày
(0 Nhận xét)

I would be great for this position for two major reasons. First, I have an accounting degree from the University of Iowa. The Tippie College of Business there offered a great program that effectively prepared me for a Thêm

$155 USD trong 3 ngày
(0 Nhận xét)

A proposal has not yet been provided

$166 USD trong 3 ngày
(0 Nhận xét)

I fully understood your needs...i have done the same thing for my regular docs followup work in my company...and i am sure that i can fulfill the things which u wanted...since it is my first project, pls help me to do Thêm

$111 USD trong 2 ngày
(0 Nhận xét)
$155 USD trong 3 ngày
(0 Nhận xét)

Doctorate in IT and Masters Web development Programming Infrastructure Audio and Visual 3D Productions International Broadcasting Satellite or Internet Based

$333 USD trong 3 ngày
(0 Nhận xét)