已关闭

Excel formulas for progressing excel sheet

We have an excel file that keeps track of staff attendance and languages.

Each day an X is placed next to the name of the person who is working that day.

2. On the bottom of that column for that day, we need to add totals of:

a) How many sales staff total were there

b) How many sales staff per language was available

Lastly we need to clean up the sheets.

See SEPTEMBER 2017 for an example of how the column should look.

To do this we added another sheet at the end, called 'DATASOURCE'. That has all the info about which staff member speaks which languages.

I need this asap.

Attached the excel sheet to work on.

技能: Excel, Excel Macros

查看更多: excel progress bar chart, excel conditional formatting data bars based on another cell, progress bar in excel, cumulative formula in excel, excel 2016 progress bar, how to create progress bar in excel 2007, excel conditional formatting percentage bar, excel running total formula, microsoft excel formulas cheat sheet, excel formulas cheat sheet, excel formulas sheet expenses, excel estimated net seller sheet, vba excel lock columns refreshing sheet, excel automatic copy database sheet, accounting excel formulas pro forma

关于此雇主:
( 0个评论 ) Ravni Topolovac, Serbia

项目ID: #15230925

22 威客就此工作平均出价 $11/小时

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex 更多

$12 USD / 小时
(187条评论)
7.0
TonmoyRoy111

A proposal has not yet been provided

$10 USD / 小时
(199条评论)
6.2
abhinovpankaj

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 更多

$12 USD / 小时
(30条评论)
4.9
suyashdhoot

Hi I am a very experienced statistician and data analyst. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done 更多

$25 USD / 小时
(4条评论)
3.9
humayoonsheikh4u

Dear Sir I am an excel professional having hands on expertise in developing spreadsheet for analytical purpose I will do your project as per your requirements by applying advanced excel formulas. Relevant Skills and E 更多

$8 USD / 小时
(8条评论)
4.0
$12 USD / 小时
(3条评论)
3.0
aubrey03

I am an Excel expert. My specialization is creating complex formulas and macros. You may check some of my work here: [login to view URL]

$11 USD / 小时
(9条评论)
3.1
rameshmahala

Hello there, I would like to be considered for this job as I have good knowledge of Excel formulas and vb macros. Thanks, Ramesh

$8 USD / 小时
(3条评论)
2.6
sadaqatali408

hi thanks for the opportunity i have read out all the information related to your staff attendance and i can use all the formulas there. why you dont knock me here now for further details . you can pay me after checki 更多

$12 USD / 小时
(8条评论)
2.3
martInghia

I am Industrial Engineer graduated in 2005 with a certification as Project Manager Professional in September 2015. I have been working during the last 12+ years in industrial management in leading companies of Argenti 更多

$12 USD / 小时
(1条评论)
1.9
nelumindralal

Hi, there is no attachment to prefer I went through the description, and this can be done within 1-2 days. I am Mechanical Engineer and frequently I solve this kind of excel tasks by automating with Macro and VBA 更多

$8 USD / 小时
(1条评论)
0.2
sabilabry

A proposal has not yet been provided

$11 USD / 小时
(0条评论)
0.0
$8 USD / 小时
(1条评论)
0.0
ksalam7

Hi, I'm interested to work on your project. I've done a similar Excel worksheet for my current employer with Macros which can calculate Employee overtime for a month and generate reports like a calendar. I can use my 更多

$8 USD / 小时
(0条评论)
0.0
Mubarekha

A proposal has not yet been provided

$16 USD / 小时
(0条评论)
0.0
rrodriguez1407

A proposal has not yet been provided

$16 USD / 小时
(0条评论)
0.0
arinappsol

I have familiar experience in Excel and worked on this type work daily basis on my office as it needs. I can work on this project and help you to finish this project. Thanks, Arindam.

$8 USD / 小时
(0条评论)
0.0
EWORX

Please Allow Me To Assist You For Best. I am Expert In It. I Can Certainly Do Your Work According To Your Requirement With In Short Time. I Have More Then 9 Years Of Experience In Multiple Areas Of Computer Science and 更多

$12 USD / 小时
(0条评论)
0.0
tuanthanhle

A proposal has not yet been provided

$10 USD / 小时
(0条评论)
0.0
tcruzvany

I have 7+ years using Microsoft Excel. One of my jobs actually had me doing something very similar to the task at hand.

$11 USD / 小时
(0条评论)
0.0